Dynamically Repeating Records

[davez]

Hi, Im looking for a bit of help on repeating records in a report. I have a set of X number of records to print as labels. Of these records all will have at least 1 label, which prints 'Master' on the label. Now the part Im stuck on, some records need to be printed multiple times, the number of times varies depending on the record and each record needs the number printed on it eg No. 1....No. X. Is it possible to write a formula that for each record prompts the user to enter the number of repeats for each record.

Cheers
Dave

 

[synapsevampire]

The usual means for handling this is to create another table which has X number of rows of the recipient ID per label and join that to your table on the recipient id.

Then you have the right amount of labels and then the only trick is to check for the first of each to allow for printing MASTER.

Here you might group by the recipient, create a formula in the group header containing:

whileprintingrecords;
numbervar CurrCount := 0;

Then in the Details section have a conditional formula which uses this to determine whether to print MASTER, as in:

whileprintingrecords;
numbervar CurrCount := CurrCount+1;
If Currcount = 1 then
"Master"

-k

 

[IdoMillet]

Have a look at:
faq149-3226

Cheers,
- Ido

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

http://www.MilletSoftware.com