print multiple copies of the same report based on a field value

Trying to find a formula or procedure that will allow me to reprint the same report (pick list) based upon a total cube field. For example, if the total cube field in <=2800, 1 pick ticket prints/ <=5600, 2 will print/ <=8400, 3 will print, etc. The formula cannot be a parameter since the total cube field is not known at printing and many tickets are qued simultaneously. Running CR 8.5    Thanks everyone
bella459Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
The only thing I can think of is to create a report using the ticket report as a subreport.

Insert the subreport as many time s as might be necessary each time in a new detail section.  The detail sections can be suppressed at print time using the total.

Detail section 2 suppression
TotalCubeField <= 2800
Detail section 3 suppression
TotalCubeField <= 5600
Detail section 4 suppression
TotalCubeField <= 8400

etc

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.