invaricconsulting Posted September 20, 2012 Posted September 20, 2012 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 Posted September 20, 2012 Posted September 20, 2012 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 Posted September 20, 2012 Author Posted September 20, 2012 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 Posted October 15, 2012 Posted October 15, 2012 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 Posted October 16, 2012 Posted October 16, 2012 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.