Is it possible to build cumulative reports without re-accessing the database each time?

[gabriel_schroedter]

Is it possible to build cumulative reports without re-accessing the database each time? In this case, I have a series of similar reports (daily weekly and monthly versions). For the daily report, each day it calculates rates based on a set of data that was generated during a certain time period. It then appends this on to all previous data. The benefit of this is that it doesn't have to do the calculation for, let's say, 6 months of data all at once but instead keeps persistent data from previous run and just adds a new set of values to the end of the set. I hope this wasn't extremely readily available information, I've done some searching and couldn't find answers that quite answered my questions.

[DellSC]

Or, you could build a stored procedure that will append to a reporting table with the latest day's data that's required for the report.  The stored proc would then return the data required by the daily report.  Your weekly and monthly reports would then just pull from this table the aggregated data for the correct time frame.  With this method, you would push all of the calculations and data aggregation that you might be doing in Crystal down to the database where it can be processed more efficiently and the weekly and monthly versions of the report would pull the pre-aggregated data that was generated for the daily report, which will be much faster than trying to recalculate everything.

-Dell

[former_member11696]

Hi Gabriel,

Short answer is no, when you refresh the report it refreshes all of it.

One way is the first time get all of the data and then use the Saved Data filter to filter it into parts. But only works for old data, still requires you to refresh the report.

Another way would be to export each duration to PDF.

There may be a third party application out there that may be able to do this...

Don

[former_member11696]

Another way is using a subreport, users could open the subreport up in the Designer and hit refresh, it will prompt for any parameters but it would not refresh the main report.

Don

[ido_millet]

At least one of the 3rd-party schedulers listed at: Crystal Reports Viewers, Schedulers and Related Products allows you to export the report data to ODBC and either APPEND or REPLACE the content in the target table.  That can address your use scenario by creating another report that uses the data accumulated in the target table.