Tracking the Change in Count

[SchwabTerex]

Would anyone have an idea on how to use a count from the previous time a report was run in a calculation when the report is refreshed?

What I'd like to do is track the change in the # of orders (in each group) on the report from the previous day to today. I assume that it would involve storing the number in a variable at the end of the refresh script and then calculating with that variable at the beginning of the next run. I have done something similar in vb.net before, however I am unsure how to approach it in Crystal as I am not sure how to make the timing work. Also can you store a variable or will it reset?

Any ideas??

 

[IdoMillet]

Can't be done just with Crystal but consider a 3rd-party Crystal add-on tool as a solution (for a list of such tools, see

http://www.kenhamady.com/bookmarks.html).

One option is to use a UFL that provides Crystal functions allowing you to write and then read values to/from an ini file via Crystal formulas. There's at least one such UFL listed at the link above.

Another option is to use a Report Manager (see list at the same link) that allows you to automate the process of exporting records from a Crystal report and appending the records to a table in a database. Again, at least one of the Report Managers listed there can do this.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Ido is right, but you could, of course, design a report that captures data for yesterday and today, and then do a comparison, but this might not result in the same values as the report run the previous day, if there were other database changes since the previous run.

-LB