• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

How can I print multiple CR reports using VB with 1 Parameter

I have 2 crystal reports and 2 network printers

c:\report1.rpt or \\server\reports\report1.rpt (preferred)
c:\report2.rpt or \\server\reports\report2.rpt (preferred)

\\server\printer1
\\server\printer2

Each Crystal Report asks for the same parameter.  @WorkOrder which is an INT datatype.

report1.rpt always prints to printer1, and report2.rpt always prints to printer2.  

I would like to create an application that asks user for the Work Order parameter then uses it to fire off both reports and print the results to the appropriate printer.  

I do not have a clue how to get started with this, other than I suspect using VB.  I have downloaded and installed Visual Studio Express 2008.  I've played around with some online tutorials, but I fear I am just spinning my wheels.

I am using Crystal Reports XI.

Any and all direction on this one is greatly appreciated.
0
sphilip951
Asked:
sphilip951
  • 2
  • 2
2 Solutions
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
I'm biased but my advice would be to purchase one of the 3rd-party Crystal report viewers listed at: http://www.kenhamady.com/bookmarks.html
At least one of these viewers has a command line API that allows passing parameters and printer destinations to a report.

You could then use a simple batch file that prompts the user for the Work Order Number and triggers the printout of each report to the desired printer.

0
 
mlmccCommented:
I would agree.  Also VS Express doesn't support Crystal.

What version of Crystal do you have?

mlmcc
0
 
sphilip951Author Commented:
Thanks for the responses.  I am using CR Developer 11.5.
0
 
sphilip951Author Commented:
mlmcc, I saw your response to this question. http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_20762547.html and it is very close to what I am looking for.

Do I just need Visual Studio to accomplish this?  If so which version should I get?  I think I should be able to easily justify the cost in labor saved.  I'd rather buy a solid product I can do more with and learn from than purchase additional viewer licenses for this one off application.
0
 
mlmccCommented:
That code is VB 6.  You should be able to use any edition of VS except Express.

mlmcc
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now