Skip to main content
Solved

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

  • April 9, 2021
  • 1 reply
  • 523 views

Forum|alt.badge.img+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

 

Best answer by RutJWhalen

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}
View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

1 reply

Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 367 replies
  • Answer
  • April 9, 2021

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}

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings