Solved

Need to increment a running count

Posted on 2008-10-30
2
1,233 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dynamic Image won't display if no data is returned 11 60
Help with a Crystal Report Formula 8 48
Crystal image Object type? 7 34
Cognos BI 7.5 calculated date syntax 2 46
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

825 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