Crystal Reports XI vs R&R dynamic parameter passing
Posted on 2006-04-26
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.