[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1249
  • Last Modified:

Need to increment a running count

Our Service Deparment uses a labeling system to ship defective parts back to the vendor. The "basics" of the labels stay the same - part number, part description and "X of Y" (where X is an incrementing number up to the value of Y which is the total number of identical parts being returned). The quantity they return may be different from that in the original order so it is not as easy as pulling the qty from the order.  Their label use, for example, is this: out of an order of 10, 6 of the parts are defective and need to be returned. They would want a label for each of the 6 parts so the labels would pull the order details into Crystal and then print the same label 6 times, and use the incrementing X of Y until it gets up to 6. The Crystal Report would require them to input the "single" order number and order line, therefore only returning one record.

With Crystal returning only one record, is it possible to increment to print count until it reaches "Y"? If so, how is it done?
0
fselliott
Asked:
fselliott
1 Solution
 
peter57rCommented:
In my opinion, the simplest way to handle this is to have a pre-built table which has just one column containing :
1 record holding value 1
2 records holding value 2
3 records holding value 3 and so on.

Add this table to your report and link the field that holds label quantity required to it.
This will create the required number of records in CR and you can then just print one label per record.
0
 
mlmccCommented:
I agree.  That is the standard method for creating N labels for a specific record.

mlmcc
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now