Crystal Reports 10 switch datasource from multiple tables to single stored procedure
Posted on 2013-11-12
I have a Crystal Reports 10 report that was originally created using direct links to several database tables. It contains about 15 running total fields, 20 formula fields, grouping, conditional formatting, and selection criteria based on the fields from the database tables.
In order to help speed up performance (and do some database user-specific filtering), I would like to change the data source to a stored procedure.
Removing the tables actually deletes the fields (and any dependent running totals) from the report. All the formulas depend on the running totals.
I tried using Database > Set Datasource Location to replace the tables with the stored procedure. It was successful in replacing one table, but trying to select multiple tables grays out the Update button. Selecting single tables after replacing the first one brings up the Map Fields screen, but the available fields only correspond to the table I previously replaced with the procedure.
What am I missing? How can I replace everything with the fields in the stored procedure?
Random side note: Upgrading to Crystal XI is an option, if there's a feature available to do this; we have a copy floating around here somewhere.
Thanks in advance!