General discussion

  • Creator
    Topic
  • #2288493

    Running Total problem in Crystal 8.5

    Locked

    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?

All Comments

  • Author
    Replies
    • #3235264

      Reply To: Running Total problem in Crystal 8.5

      by lilangel369 ·

      In reply to Running Total problem in Crystal 8.5

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

    • #3234902

      Reply To: Running Total problem in Crystal 8.5

      by ehall ·

      In reply to Running Total problem in Crystal 8.5

      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.

    • #3246034

      Reply To: Running Total problem in Crystal 8.5

      by dr dij ·

      In reply to Running Total problem in Crystal 8.5

      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.

Viewing 2 reply threads