Skip to main content

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

 

Resolved this by:

  1. Created table with 1 field (SEQ_NO)
  2. Populated table with sequential number from 1 to 5000
  3. Created View bases on table
  4. Granted SELECT to view for required users
  5. Added table to Crystal Report with no linkage
  6. Updated report filter so to include:     {TNM_CRYST_REP_SEQ_A.SEQ_NO} <= {SHOP_ORD_A.QTY_COMPLETE}
Terms & ConditionsCookie settings