Running Totals or a Conditional Group

[Wabush]

I have a big challenge :

I have a 'Transactions' table that has a date_completed, source_location, destination_location, and the amount_moved.

I have to display three columns on my report;
Location (locations can be the destination or the source)
the amount taken from it (if it was a source)
and the amount added to it (if it was the destination).

The client wants to choose a date range, and the location.

Should I use running totals for this?

 

[chris777]

Running totals would work very well, but do you have some way of determining whether the amount goes into the destination or source totals? Chris
DFW Crystal User Group

http://www.dfwcug.com

 

[Wabush]

In case anyone will benefit from this, I managed to do this by
1. creating a subreport that linked the Source from the main to the destination in the subreport.
2. In the main report, I grouped on Source and
3. Added a summary column in both the main report and the subreport and displayed them side by side

 

[Trainingjason]

Have you tried doing a conditional running total

Hence in running total in the evaluate choosing formula and
placing a formula such as

source_location="Source 1" or destination_location="Manchester"

Hope it helps


jason