Summarizing and outlining

No coding is required to add this feature to your report.
Update the template and that is all.

Totals   |   Subtotals   |   Nested subtotals   |   Advanced formatting

Totals

To summarize data, you make your customer click the AutoSum button in Excel worksheet or use the SUM column option in XL Report template.

See how we change the template to produce a report with a total inserted under a column.

And now see the total inserted.

You can also use the following summary options: Sum Count CountNums Avg Max Min Product StDev StDevP Var VarP

Subtotals

To insert automatic subtotals you should group the data in a column and use summary options in columns you want the subtotals to be calculated. To group your data, use the GROUP column option in XL Report template.

See how we change the template to produce a report with subtotals inserted.

And now see the subtotals inserted.

Nested subtotals

To create nested subtotals, use the GROUP option more than once. This time we decided to insert subtotals for two columns and hide some of the detail data.

See how we change the template.

And now see the report.

Advanced formatting

A special option pack provides a lot of advanced formatting features for grouping and subtotaling.

Conditional formatting  |  Filtering  |  Summarizing and outlining  |  PivotTable and PivotChart  |  Master-detail reports  |  Multiple-sheet reports  |  Charts  |  VBA macros