How to add blank row in labels

[ndp]

Hi,
I have created labels(5x2). This is kind of urgent!
The problem is by mistake they got wrong labels. There are some other kind of labels which can be used. But, it is perforated on third row.
Is there any way to print blank labels on every third row on each page?

I would really appreciate if anybody can suggest anything! That would save me!

Thanks
ndp

 

[goranm]

Hi!

Is it right that you print ten different labels on each page down then across ?

Then maybe this is a solution:

Create a new empty detail section that have the same height as your existing section.
(You now have to format with multiple columns on the highest detail level, not on section a or b)

Create two formulas which you can have suppressed.
@Counter_reset
WhilePrintingRecords;
NumberVar counter := 0;
Place the formula in the page header

@counter
WhilePrintingRecords;
NumberVar counter := counter + 1;
Place this formula in detail a.

Now format detail section b with this suppress formula:
whileprintingrecords;
numbervar counter;

if counter <> 2 then
if counter <> 7 then
true

If you have format the section &quot;Across then down&quot; you change the suppress formula to:
if counter <> 2 then
true

/Goran

 

[Ngolem]

How is your label report set up?

Do you have 5 detail sections with 2 labels in each?

Are the sections set to the proper size of the label?

Do the labels each consist of a single formula with a &quot;Can Grow&quot; enabled? or are they a fixed size?

You really haven't described your report to us.

If there is 5 detail sections, you can simply remove the middle section.

Or you can have a parameter added to the report to designate which labels are printed. This is often done when only printing one or two labels ... not a complete sheet of them.

In this case, number your labels left to right, top to bottom.

Now create a string parameter to designate which labels are to be printed

//?LabelsPrinted

Type: String
Description: type in the number position of the labels to be printed separated by a comma Eg. 1,2 or &quot;ALL&quot; for a complete sheet.
Default Value: ALL

OR you could say 1,2,3,4,7,8,9,10 to eliminate labels 5,6

Now in the report header create this suppressed formula field

//@Init

WhilePrintingRecords;
StringVar Array LabelNo := Split({?LabelsPrinted,&quot;,&quot;
&quot;&quot;; //just put here to make the formula legal

Now in each label formula in the report put this formula
In the conditional suppress for the field

For Label 1

WhilePrintingRecords;
StringVar Array LabelNo;
Not (1 in LabelNo) ;

For Label 2

WhilePrintingRecords;
StringVar Array LabelNo;
Not (2 in LabelNo) ;

That is my best guess....not knowing how your report is set up.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[ndp]

Many Thanks to Goran and Jim for instant reply.

I tried the way Goran suggested. It is quite close to what I need. Only thing, It gives me second row blank, but I want to have third label(and 8th) to be blank. Here is exactly my labels should look.

Label1 Label5
Label2 Label6
Blank Blank
Label3 Label7
Label4 Label8

The width of each label is 5 inch and Height is 2 inch. It should print Down then Across. I incresed the height to 4 inch and inserted the section below. Did exactly what you suggested. Is there any way I can have the third row of the labels blank?
I hope I could explain enough! It looks I am very close to it.
Thanks so much for the help!
ndp

 

[goranm]

Hi !

I tried it myself just now, and I get the third label blank, but on the other hand I saw that my suggestion wasn´t quite the way that you wanted.
To achieve that I changed the suppress formula to:
if counter <> 2 then
if counter <> 6 then
true

I hope it will be alright. If you still have problems try to change the numbers to 3 and 7 instead.

Otherwise we will look at it again.

/Goran

 

[ndp]

Hi Goran,
I tried that. But, seems like I am not doing correctly. Some settings might not be proper in my report. Can you tell me exact settings for your detail section and margins etc? I am using paper size as tabloid and landscape. and also the labels are different records.
I increased the height of label to 4 inches and inserted the section b.
You had mentioned earlier that...
(You now have to format with multiple columns on the highest detail level, not on section a or b)
I didn't quite understand what exactly that meant. I know becuase of pressure it seems like I can not think straight.
I have got the temporary solution which is just to print four labels on a page. But, I would like to do what you have suggested to save papers.

Thank you very much
ndp

 

[goranm]

Hi ndp !

If you will give me your email adress I can send you my testreport which is based on Crystals Xtreme Sample Database and maybe we can come out with the solution.

/Goran