Sequential Numbering in Batches

[invaricconsulting]

Does anyone know a way to accomplish the following?

 

The data contains a field for quantity (of output) for each record, e.g. -

 

Record 1: Qty=50

Record 2: Qty=75

Record 3: Qty=25

 

and the need includes sequential numbering, such that:

 

record 1 repeats numbered 1-50, record 2 repeats numbered 1-75, record 3 repeats numbered 1-25.

 

Thanks.

[ThomasLewis]

Put this in OnRecordStart: (assuming "Qty" is a field name)

FusionPro.Composition.repeatRecordCount = Int(Field("Qty"));

 

Make a text rule for the number:

return FusionPro.Composition.repeatRecordNumber;

 

You can split the records into separate files as well. There is a sample of that here: http://forums.pti.com/showthread.php?t=2906

[invaricconsulting]

O.K., I had repeatRecordCount in place already, so I added repeatRecordNumber, and the code to split into separate files.

 

Works like a charm!

 

Thanks.

[digitalsig-1.com]

Does anyone know a way to accomplish the following?

 

The data contains a field for quantity (of output) for each record, e.g. -

 

Record 1: Qty=50

Record 2: Qty=75

Record 3: Qty=25

 

and the need includes sequential numbering, such that:

 

record 1 repeats numbered 1-50, record 2 repeats numbered 1-75, record 3 repeats numbered 1-25.

 

Thanks.

Doing something similar, but there are 456 lots, but it's more like lot 1: 1-20, lot 19: 21-40, lot 37: 41-60... lot 2: 1521-1540, lot 20: 1541-1560...

 

is it possible?

[Dan Korn]

Doing something similar, but there are 456 lots, but it's more like lot 1: 1-20, lot 19: 21-40, lot 37: 41-60... lot 2: 1521-1540, lot 20: 1541-1560...

 

is it possible?

Sure, it's just a matter of telling FusionPro how many times to repeat each record, and then using FusionPro.Composition.repeatRecordNumber, FusionPro.Composition.outputRecordNumber, or a similar property. As I said in the other thread though, if you collect up the job, or a small sample which shows more specifically what you're trying to do, that would make it a lot easier for someone to help you with the exact rule syntax you need.