Solved

Quick Report (Crystal Report) Printing x Copies based on field value

  • 9 April 2021
  • 1 reply
  • 435 views
R
Rank
Userlevel 7
Badge +18

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

 

icon

Best answer by RutJWhalen 9 April 2021, 17:40

View original
This topic has been closed for comments

1 reply

R
Rank
Userlevel 7
Badge +18

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