Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grand Totals in a sub report for three columns

Status
Not open for further replies.

AssetRecovery

Programmer
Sep 17, 2003
14
US
I have a report that needs to be modified slightly and I'm having trouble figuring out how to add grand totals to the end of three coluns. The three columns are in a sub report that prints out in the middle of the main report. My three columns are called 'Sum of @Create Total(Number)' 'Sum of @Resolved Total(Number)' '@Resolution Percentage(Number)'

As you can see each one is showing me numbers for an individual so it would look like:

Technicians Total Create Total Resolved Resolution%
Mike Smith 1 1 !00%
Kerry Brown 2 1 50%
Allen Rogers 5 1 20%

What I need is a count of each column and a total at the bottom showing 8 3 170%
 
If these are formulas at the detail level as well, right click them and select insert->Summary->Grand Total.

If they aren't in the details, place them in temporarily and do the above.

But this depends on several factors, such as how they were created, the version of Crystal, where in the main report they are, and if you want totals per subreport firing, or overall.

-k
 
The subreport is in the main reports details and the results of the subreport are in the subreports footer a There is a footer b but it is supressed and for what ever reason the developer of the original report did not put the results in the details of the subreport. This is all Crystal 9
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top