General discussion


Running Total problem in Crystal 8.5

By ehall ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by lilangel369 In reply to Running Total problem in ...

I'm having the same problem. Did you find a solution for this?

Collapse -

by ehall In reply to Running Total problem in ...

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.

Collapse -

by Dr Dij In reply to Running Total problem in ...

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.

Related Discussions

Related Forums