'save'report results and compare these with new results

[JeroenBoon]

Hello,

I've made a report that sums up the total orderamount at the moment of running. So far so good ofcourse.
But now I want to save the generated total amount and when I run the report again, I want to display the difference between the former (saved) amount and the new amount. Is there a way to do this?



Thanks, Jeroen Boon.

 

[Madawc]

You can print or export the output. I don't think there's any way of saving the data and then doing another run.

Madawc Williams
East Anglia
Great Britain

 

[lbass]

I'm not a subreport expert, but maybe you can explore the idea anyway. There might be a way to incorporate a subreport that does not get refreshed at runtime.

Or, if your database has transaction dates, you could design a subreport based on a previous period by limiting the data to that entered by a specific period of time, with the main report reflecting data entered by the current end period.

An even simpler way would be to use running totals to capture sums of data--first limiting it by transaction dates and then not limiting it, e.g., for {#earlierdata} choose {amt},sum, evaluate using a formula:

{transactiondate} <= Date(2003, 03, 31)

Reset on change of group or never, depending on your needs.
For {#currentdata}, do the same without the formula limitation. Then you can write a formula {@diff} to capture the difference:

{#currentdata}-{#earlierdata}

-LB

 

[JeroenBoon]

Ibass,

your idea of a subreport that doesn't refresh at runtime migth be a possibillity.
The other options won't work because there are no datafields I can use to do this.

Jeroen Boon.