We have a quick report the runs via RMB on the Shop Order. This creates a label for the item. The user has asked whether it is possible for the report to print a number of copies equal to the Qty Complete and at the bottom of the report print 1/5 2/5 3/5 4/5 5/5 on the respective page/copy.
Is this possible? And pointers much appreciated.
Thanks
John
Best answer by RutJWhalen
Resolved this by:
Created table with 1 field (SEQ_NO)
Populated table with sequential number from 1 to 5000
Created View bases on table
Granted SELECT to view for required users
Added table to Crystal Report with no linkage
Updated report filter so to include: {TNM_CRYST_REP_SEQ_A.SEQ_NO} <= {SHOP_ORD_A.QTY_COMPLETE}
