# Sequential Numbering in Batches

## Recommended Posts

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.

##### Share on other sites

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

##### Share on other sites

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.

##### Share on other sites

• 4 weeks later...
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?

##### Share on other sites

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.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×

• #### FusionPro.com

• MarcomCentral
×
• Create New...