Printing sequence #'s in crystal

Yahoo Archive
1
The only way we found to dynamically control this is to link the crystal report to an Access database 'numbers' table.  The table contains some linking fields such as company and a qty field.  The qty field would have to contain one row of 1, two rows of 2's, three rows of 3's and so on.

For example, you would join your UD field to qty field on the numbers table and it would find 25 records for the number 25.  Place this qty field from the numbers table in the report and you get 25 pages of the same record.  We typically hide it in the report footer.  Your sequence numbering can be based on page number or a formula at that point.
2

In Job Entry, we have added 2 UD Fields to capture a sequence range.  For example, the job is to make 25 pcs so in the UD fields we capture 1 and 25.  When the job traveler is printed, is there a way in crystal reports to print 25 copies of the job traveler and on each copy to print the next sequential sequence #.  For example, the first copy would show Seq #1, the second copy would show Seq #2, the third copy would show Seq #3, etc.

 

Thanks

 

Michelle Chamberlain

ERP Analyst

Sabre Industries

Direct Line:  (712) 224-1452

Phone: (712) 258-6690 ext. 11452

Fax: (712) 279-0817