Run and Save Report

[beezier]

I run 4 reports monthly from CR9 with multiple parameters and save the report with the data to a new file. The total number of report files created from the original 4 is about 100.

How do I:
a) Pass the report parameters. (Command line, VB code?)
b) Save the report with the data to a new report file

 

[chelseatech]

You have several choices:

1) You can use one of the 3rd party utilities out there. Ken hamady has a list on his site, including my cViewMANAGER report scheduler. One of the options I've included is a data stamp on the output file name, so each month it has a different name.

2) You can develop your own VB app to open the reports, log in to the database, and pass parameters. Ken also has examples to do this. The utilties (above) are usually written in VB or .NET so that would be the easiest approach. Using the RDC you can interrogate the parameters, load them with values, and export the report to another format.

3) CR8.5 included Crystal Enterprise Std, that had the ability to schedule reports. Sorry, not available in CR9 pro or developer. You will need the advanced version to schedule reports.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[IdoMillet]

Ken Hamady's list of 3rd-party utilities is at:

http://www.kenhamady.com/bookmarks.html

In the case of my Visual CUT software:

a) you can schedule or invoke processing of a report using pre-saved parameter values as well as pass commnad line arguments that override those saved values.

b) the exported file names (and folders) can be specified using a combination of static and dynamic text. The software detects fields/formulas in the report header/footer and in the Group Level 1 headers/footers and allows you to drag & drop them into the exported file name option.

If you need the file name to reflect a parameter value, simply place (even if suppressed) a formula that returns the parameter value in the report header or footer. Then, within Visual CUT, drag that formula name into the exported file name option. You can see a video demonstration of how this is done on my web site.

If what you are doing with the different parameter values is actually bursting the report to dedicated output for each group, consider using the electronic bursting feature that is provided by some of the 3rd-party utilities listed by Ken under the "Report Managers" section.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com