Passing parameters in Batch Mode

[crguy]

Hi there,

I am wondering if this could be done in Crystal. I need to pass parameters in some batch form, or url that will invoke Crystal as a desktop application, not on the web.

Right now this is what is going on:
Webpage: User pickes a deprtment that they want to query.
PARAMETERS ARE PASSED USING A BATCH MODE
Word is invoked and the report is generated.

Can this be done in Crystal?

 

[HowardHammerman]

It cannot be done directly in Crystal. You can do it by writing a VB program that stores the parameters in a table and then calls crystal.

there are some rather cheap third part utilities that can do just that. Let me know if you want the names... Crystal Reports training, consulting, books, training material and on-site support. Scheduled traing in 8 cities.

http://www.hammerman.com

800-783-2269

 

[crguy]

Hi HowardHammerman,

If you could direct me how I can proceed in doing this with VB then that would be great.

I think that would be the best way to approach my problem, right?

Thanks

 

[HowardHammerman]

Well, it works like this:

1) Learn how to call Crystal from VB. There are a number of resources for this including some white papers from Crystal Decisions. Ken Hammady has a nice download for sale ($12 +/-). We have a CD on it for $29.

2) Create report selection screens that prompt the user for the parameters.

3) Store the params in table(s).

4) Create a table with one record per report. One field in the report will be a true/false field indicating that the report is selected.

5) Create a do...while loop that goes through the above table looking for 'turned on' reports and processing them.

Or you can buy a utility for $295 that does all the above.
And schedules the report. Crystal Reports training, consulting, books, training material and on-site support. Scheduled traing in 8 cities.

http://www.hammerman.com

800-783-2269