Call Stored Procedure Multiple Times
Posted on 2005-03-07
I have a Crystal Report that pulls data from a SQL Server stored procedure.
The report compares statitics from certain weeks from year to year.
An example of the report is as follows:
2005 Notifications 45 67 100
2004 Notifications 34 92 55
Total 79 159 155
2005 Charges 3 9 5
2004 Charges 7 14 1
Total 10 23 6
There are a couple of rows of data, and then a total line. The stored procedure only retreives data for one year at a time.
Is there a way to call a stored procedure multiple times for a report?
I have tried to just add the stored procedure to the document multiple times, but it only gives me one parameter field, and all the rows bring back the same data.