Hoe to Automate A Seagate Crystal report? 3

[ravurik1]

Hello All
I need to automate a report which has a input as parameter.
The input parameter is Lot, there are 30 lots. So I need to produce 30 outputs i.e one report for each lot.
The database we use is Oracle 8i Operating system is Windows NT.
I am planning to automate the process with MS-DOS batch file.
If possible please provide the syntax.


Thanks in Advance
-Kiran Ravuri
-Boston

 

[synapsevampire]

You can't automate CR from DOS.

You can use a Windows macro recorder (cheesy but cheap), write code or use a scheduling program.

As for needing 30 reports, you can probably do this from within a single report.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[IdoMillet]

Have a look at Ken Hamady's site for a listing of Crystal utilities:

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

My "CUT" User Function Library would allow you to burst, export, and e-mail your report but would require that you run a Crystal report to invoke the User Functions to trigger this processing.

My "Visual CUT" software does all of the above and can also schedule and invoke the processing via command lines or Batch files.

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

http://www.MilletSoftware.com

 

[chelseatech]

Also have a look at cViewMANAGER - my report scheduler. it has a "Multirun" feature which reruns a report and sends each run to a different email address(s). Editor and Publisher of Crystal Clear

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

 

[kenhamady]

Unfortunately, you will need a program to process the batch commands - CR doesn't support this directly. At least one of the available report viewers supports batch file commands - Report Viewer 9.0 by Crystal Desk.

I have links to all of the viewers mentioned here on my webstite LINKS page if you want to check on the others, but they are the only one that I have seen that specifically mentioned Batch File Commands. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[ravurik1]

Thanks for the Responses!
Our Company has bought APOS Business Calendars, will I be able to use that and schedule the report so that I will get 30 different out puts for 30 diff parameters.
Thanks
-K

 

[GaryRogers]

We have some products that may help you.

Report Scheduler will automatically output and email Reports to many formats.

Report Viewer will allow your reports run from a batch file or view print and email them from an interface
Gary Rogers CrystalDesk (Report Scheduler)
Crystal Reports consulting, and software interface development.

http://www.crystaldesk.com/