Solved

Need to increment a running count

Posted on 2008-10-30
2
1,243 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 101

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

Industry Leaders: 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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

632 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