• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

Restate Group totals at end of Report

Experts,

"Restate Group totals at end of Report"
Crystal 9.0

My sections are as follows:
Group Header #1 - Job
Group Header #2 - CSI
Group Header #3 - CC
Group Header #3b - CC
Group Header #3c - CC
Group Header #4 – Cat (suppressed – drill down ok)
Details  (suppressed – drill down ok)
Group Footer #4 – Cat (suppressed – drill down ok)
Group Footer #3 - CC
Group Header #3b - CC
Group Header #3c - CC
Group Footer #2 - CSI
Group Footer #1 - Job
Report footer

The report generates approx. 4 to 20 pages of CC "detail". The readers like the detail, however would like to see recap of only Group footer -#2 CSI subtotals at the end of the job/report.

Objective: I’d like to restate the subtotals from CSI group for at the end of the report.

Note A:  Some of the groups (i.e. Group Header #3 – CC) have subsections b, c that contain “shared variables” and pass amounts from a subreport (also contained in Group#3 subsections).

Note B: I’d prefer the solution to not be “another subreport” in the Group #1 or Report Footer for two reasons stated below:
B.1. The report is not fast (due to existing subreports in Group #3).  If we add another subreport that recaps the CSI totals it will further slow the report.
B.2.  Suppressing the section Group #3 – CC suppresses shared variables amounts and subreports which results in zero amounts (on my report).  It seems that a shared variable and/or subreport can not pass data if suppressed.

Thank you
0
LFreehauf
Asked:
LFreehauf
  • 2
  • 2
  • 2
2 Solutions
 
frodomanCommented:
If a section is suppressed, then the subreport in that section will not run and therefore will not update any variables.

I understand from Note B that you don't want to do another subreport.  That is however, by far the most effective way to accomplish what you want.  Otherwise, I think what you'll need to do is to create a shared variable array.  Create a formula in group footer #2 that redims the array to add an element, then stores the subtotal value in the array.  Then you can create a formula in the report footer that itterates through the array and shows the stored totals.

I can give some assistance with the code if you need it.

frodoman
0
 
mlmccCommented:
Agree,  The only way to get the group totals is to save them in a global array or reproduce them.

mlmcc
0
 
LFreehaufAuthor Commented:
OK – Thanks.  
It’s not the answer I hoped; but you provided the expertise and (the best) direction that I should take.  Very valuable.  Thanks.

I'll add some points and split.

I'll pursue the subreport type solution “because I know how to execute”.

I guess I’ll need to create/modify a subreport, passing the variable at the CSI level (since I can not simply copy this Main/container report and suppress the CC section – due to the shared variables at the CC level).

Hopefully this issue will stay open for follow-up question; In case I need to try the “shared variable array”.  But I doubt I’ll attempt such.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
frodomanCommented:
The shared variable solution will be a bit messy - I do think you'll ultimately be better off with a more manageable subreport but post back if you decide you want to use the other option.

frodoman
0
 
LFreehaufAuthor Commented:
I understand and appreciate.
Thanks.
0
 
mlmccCommented:
Glad i could help.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now