Crystal Reports XI vs R&R dynamic parameter passing

Does Crystal Reports have a concept similar to R&R runtime that can run reports through control tables?

For anybody who is not familiar with R&R, then I mean that you can run multiple Crystal reports with dynamic parameters passed from a database table (called a control table in R&R) with field values passed as parameters? I need to be able to get my application to process the table in record order, launching a report with different parameters for each record. I have already achieved this in R&R, but due to problems with R&R not being able to operate with my native database driver (Advantage Database Server), I'm wondering if I can do this with Crystal that does indeed have an Advantage database driver?

An example of the type of parameters that are passed are:

(Please read as FIELD = VALUE)

RI_REPORT = MYREPORT.RRW
RI_SCOPE = TRUE
RI_MASTER = RESULTS.DBF
RI_WPTR = TRUE
TRAY = 3
CLIENTCODE = A0001

Where RI_REPORT is the name of the report being run. RI_SCOPE will override any scope saved with the report. RI_MASTER can override the master table saved with the report. RI_WPTR is used to determine whether to print to pdf file (true) or direct to printer (false). TRAY is the tray number to print from where a printer has multiple bins. CLIENTCODE can be passed as a dynamic parameter used in the report's query.

For any hardened R&R fans, please excuse the politcal correctness of some of my parameters. They are merely illustrative.

This is likely to be a fairly tough question, so good points being awarded to someone that knows or who can suggest a good Crystal solution.
limsmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gopatincCommented:
Crystal (Server and Reports) does not have the capability you need (Report bursting). There are other tools like R&R which work well with crystal.
One of them is CRD (Crystal Reports Distributor http://www.christiansteven.com/main_alt.htm). There are other tools on the market as well but am not aware of how well they perform or how they compare to CRD.
0
limsmanAuthor Commented:
Thanks gopatinc. This looks like a very good mass reporting app, although I'm not sure it would serve our purpose. The lowest priced version that could be used at present are the Enterprise editions which are very costly and still limiting to the number of users allowed and really, the app is just doing what my application does (report bursting as you rightly say) except that my licence is unlimited. I was really hoping that if Crystal didn't support this feature, to have something that could be "plugged into" a development environment such as a Delphi VCL component to give full application control and be unrestrictive. It does make me ponder that if CRD can interface so closely with Crystal, whether they have some kind of SDK from Business Objects or some other software interfacing agreement with them? They must have found some way to run reports dynamically from within CRD?

Thanks again for your valued contribution. I shall leave this question open for a few more days for any further comments before awarding points.
0
mlmccCommented:
You probably could write an application to do the processing and calling of the reports.

As gopatinc stated Crystal doesn't have the ability to do what you want.

mlmcc
0
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Yes, a Crystal Developer license gets you an api that allows you to call Crystal reports, pass parameters to them, export, print, etc.

A list of 3rd-party Crystal report managers is at: http://www.kenhamady.com/bookmarks.html
Some of these tools are cheaper or even free and some provide a command line interface so you can use them as a balck box from within your application.

At least one of these tools can burst your report in a single pass so that all selected client codes are printed or exported to individual destinations without a need to request processing for each one separately.

By the way, R&R used to be my favorite report generator for many years...  :o)

- Ido  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
limsmanAuthor Commented:
IdoMillet,
Thanks for your comments. This has been very helpful and answers my main question. The Crystal Developer API may be what I would need to have complete control through my application. We would have to buy a Crystal package anyway to develop all the reports (of which there are hundreds). However, I was also interested in these two command line products:

http://www.crystaldesk.com/products.htm
http://www.milletsoftware.com/datalinkBenefit.htm

The Millet Software DataLink Viewer is your own creation I believe? I presume then from what it states on your Key Benefits page, that it would probably work in conjunction with my application? That is, the commands and parameters could be added to each record in a table and then sequentially processed and executed through a WinExec API call to produce printed and pdf reports without any further interaction required by the end users? This is really what I must achieve to make my app successful if I was to go the Crystal route.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.