Print the same Crystal report multiple times automatically

Posted on 2009-12-23
Last Modified: 2012-06-21
I have a report that is several pages and includes subreports.  If the customer address is not domestic, I need the report to print three times.  Because it has subreports, I cannot make it a subreport, as well, so that method will not work.  I appreciate any advice.
Question by:ginsburg7
    LVL 77

    Accepted Solution

    There is nothing you can do within CR itself.

    You will need an external program of some sort to do this automatically.
    That could be a VB program of your own or you might find a 3rd party report manager here:
    LVL 100

    Expert Comment

    Agree.  You need an application to run the reports and control the printiing.


    Author Comment

    Thank you both.
    LVL 13

    Expert Comment

    Alternatively, create a table in the database with a primary key of export type and a counter.

    Export key of 'H' (Home), one row, counter 0.
    Export key of 'E' (Export), three rows, counter 1,2,3.

    You then link this table in to the main report and you get three groups for the same customer. Therefore three copies of the same section of the report.

    Advantages are, you don't have to get/learn anything else. You can tell which copy you are printing from the counter field in the database, so the heading can be subtly different.
    (Invoice, Duty Invoice, Export Document....)

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    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…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    730 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

    18 Experts available now in Live!

    Get 1:1 Help Now