Solved

Need to increment a running count

Posted on 2008-10-30
2
1,239 Views
Last Modified: 2013-11-15
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
Comment
Question by:fselliott
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 22841971
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 22851619
I agree.  That is the standard method for creating N labels for a specific record.

mlmcc
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Store total calculated duration sessions. 44 97
Multiple Parameters in Crystal 11 84
Crystal Reports total formula with groups? 4 63
Visual Studio .Net 2012 and Crystal Reports 9 115
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question