Print two or more copies based on fields value.

Posted on 2012-08-27
Last Modified: 2012-08-29
I have a crystal report  CRXI that prints  labels.
Report has detail line with several fields in,  no grouping
I am printing one label per detail line.
In report one of fields is  Qty.
Usualy Qty has value =  1.
Can I print two copies of particular record - label or 3 copies  or more if Qty =  2  or Qty=  3 or more.
The rest of records will be printed ones as they have qty = 1.
I hope that I explained properly what I need.
Question by:Taras
    LVL 18

    Assisted Solution

    This was discussed before and as far as I remember the solution was to create a table with multiple rows per label ( matching the number of the labels you want to print). You can join this table with your regular database tables and have multiple rows per label.
    LVL 100

    Assisted Solution

    That is one method.  There is another.

    Create a table with just numbers 1 - N where N is the max number of labels you might print

    You can join the table using a >= join

    LabelTable.Count >= NumberTable.Number

    Check this link from Ken Hamady

    LVL 34

    Accepted Solution

    If you will always have a small number of labels, for example if Qty will never be more than 5, another option would be to create multiple copies of your detail section, one for each potential label, and then suppress the extra sections.  Suppress the second section if Qty < 2, the third section if Qty < 3, etc.

     If Qty could be much higher, or you don't know how high it could be, then this approach probably isn't practical.


    Author Closing Comment

    Thanks to all, it was good sugestion from all

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    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…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now