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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Showing multiple groups subtotals all at end of report

Status
Not open for further replies.

plarson3

Vendor
Sep 3, 2004
26
US
Is there a way to show subtotals from subgroups (Group #2 or #3) together at the end of the report instead in their respective group footer throughout the report?
 
You could try a crosstab using the group field as your row field. Or, you could use running totals where you use the evaluate based on a formula option and enter:

{table.group} = "group 2"

Reset never. You'd need a separate running total for each group total.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top