Basic Stored Procedure Question

[DataDog]

If written about 100 complex reports with a vast amount of formulas,running totals, shared variables, parameters, etc. Now thery are saying we need to write Stored Procedures to drag down the data (for speed). Do I have to, in effect, start over on the reports with the SP instead of the Tables? Putting it another way, adding in the SP with the table report, deleting a table field, adding in the SP field over and over is going to be a time consuming process. Is there a better way?

P.S.

CR8.5, CE8.5, and SQL Server data.

Thanks in advance for your help

 

[rosemaryl]

Dear DataDog,

I haven't had time to test this - so theory only!

You could try setting the location of the report table to the stored procedure. The field mapping dialog box should come up and you can map the fields to "columns" in the stored procedure. Do this for each table in the report. When you set location, the field names in formulas etc will get updated.

However, this seems as manual a process as redoing the reports. Redoing the reports, while time consuming, may actually be your best options. You can include in the SP some of your formulas and "running totals" so that Crystal Reports does minimal processing.

I hope this was helpful - it is never a good answer to tell someone they have to do it all over again.

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Rooble]

Crystal doesn't support Tables and Stored procedures together as data source to one report. So you will have to go either way.
Stored proc is the best approach if the aggregation/calculation/running totals is taking too much time for the report to come as there is a performance hit with these.
You will have to be careful about using stored proc but definitely it's the best way if the data set is too large.

Hope it helps...

Rooble