duplicate labels, need same amt each time. 1

[newtosql0001]

I need to create 60 labels always, the number of labels never changes, i've tried creating a small 2nd table with just 60 in it but cannot follow previous posts and modify them to my situation/understanding of what is being said. I use report expert and create label, not sure how subreport could play a part. Thanks.

the one parameter will look for a date, everyone with a pmt due that day and then their names will appear on 60 labels and then the next persons name for however many people have a pmt due that day.

 

[lyanch]

Create a detail section with 60 repeats of the data for the single record.

Lisa

 

[IdoMillet]

You can adapt the solution I describe in faq149-3226 by simply changing the record selection condition from:
-----------------------------------
Order.quantity >= Repeater.How_Many
-----------------------------------
to
-----------------------------------
60 >= Repeater.How_Many
-----------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[newtosql0001]

My label table has only LABELQTY with a value of 60 as that newly created table for this situation, and I inserted a field into main table called label and gave it the value 60, if i look at database link, this is the common link, then with select expert i chose labelqty <= 60, I'm not getting how 60 should print, parameter, or formula still needed?, subreport? the one parameter i do have is in group selection which calls for a date. thanks again.

 

[IdoMillet]

To use my proposed solution you need to create a &quot;REPEATER&quot; table as per the FAQ: FAQ149-3226

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[newtosql0001]

Ok using the REPEATER table do I need 60 in there 60 times or just once?

 

[IdoMillet]

You need:
1
2
3
4
...
60

in the REPEATER table.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[newtosql0001]

BINGO, Thanks for the help Ido, works like a charm.

 

[IdoMillet]

A good example of how evil (Record Inflation) can be turned to good... )


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com