Solved

Crystal reports, run multiple reports / print

Posted on 2011-02-11
5
488 Views
Last Modified: 2012-05-11
Hello, Ii have two crystal reports that I could do with running as a batch.  I have invoice and delivery note that run off the same data but have different printed data.  I need to ideally print / run both at the same time.  I looked at sub reports but I just need it as a page in its own right or as per it’s page setup / design.  I f I put a sub report in it ends up as a nested report, smaller and not the full expanded page?

Any ideas?

Also on the same lines, I need to print the invoice separately at times (just created the singular report) but need to print it on different coloured paper, I guess I can use a multi bin printer with paper in different colours in different bins.  Has anyone used crystal to print a report say three times to different paper bins?

Thanks.
0
Comment
Question by:Prefuse
  • 2
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 34872501
What version of Crystal do you have?

Most versions do not allow you to change the bin in the middle of the report.

I haven't printed report that often but you should be able to set the "subreport" to have 0 margins and then when you insert it make sure the box for it is the full width of the page.

As for running them in order, you could have an application that opens the first report and prints it then closes it out and runs the second.

Similarly for multiple colors, you could the report in a loop changing the bin each time through code.
Look at this question and instead of changing the printername change the bin
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_25601312.html?cid=1576

mlmcc
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 34875883
At least one of the 3rd-party Crystal Reports Desktop Scheduling tools listed at: http://www.kenhamady.com/bookmarks.html provides that functionality (including the ability to split the printout across different paper trays).
0
 

Author Comment

by:Prefuse
ID: 34886218
Thanks for that. I cannot see any info on the page regarding split print to different pages. Will have a browse through the links.  I know - being lazy!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34888976
Since he is the developer of the product in question he can't directly mention it.

Look at Visual Cut

mlmcc
0
 

Author Closing Comment

by:Prefuse
ID: 34895688
Thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

21 Experts available now in Live!

Get 1:1 Help Now