Web Development

Ask something
Discussion Locked

Running Total problem in Crystal 8.5

0 helpful
3 replies

by ehall

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have two groups in my report. Group 1 defines the group names (group a, group b, etc.) Group 2 defines stratums within the group (Group a stratum 1). I have manual running totals in each group. I need to create a formula that references the running totals in both groups and calculates a percentage that displays in the footer of Group A. Example: (RunningTotal Group A -RunningTotal Group B)/RunningTotal Group A. When I try this calcuation either 0 or the last value in the running total is displayed. How do I get around this?

3 replies

by ehall

I did find a solution. I created a subreport that stores the running total for one of the groups in a shared variable. In the main report, I reference the variable in a formula to calculate the percentage between both report groups.

by dr dij

In some cases you don't even need subreports as xtal allows you to put subtotals ahead of group, etc. when xtal parses report, if there are any needing to be subtotaled ahead it makes an extra pass to calculte these totals 1st.

subreports can be slow if using another data source, but they are slick. xtal can't read two databases in one report. but add a subreport and you could have an external access table you read with key from your companies erp system for example.

This discussion is closed to new replies.