This sample demonstrates showing and hiding grand totals and subtotals in rows, columns, or both at runtime. Also, end users can specify and hide subtotals of specific fields.
Grand totals position
|
|
|
|
|
|
Hide grand totals
|
|
|
|
|
|
|
|
|
|
Hide sub-totals
|
|
|
In this sample, you can hide grand totals in row, column, or both using radio buttons available under the Hide grand totals category. To hide grand totals in both row and column, set the property DataSourceSettings->ShowGrandTotals
as false. To hide the row and column grand totals separately, set the property DataSourceSettings->ShowRowGrandTotals
and DataSourceSettings->ShowColumnGrandTotals
as false.
You can also, display the grand totals either at the top or bottom of the row and column axes using radio buttons available under the Grand totals position category. To display the grand totals at top, set the property DataSourceSettings->GrandTotalsPosition
as Top. And, to display the grand totals at botton, set the property DataSourceSettings->GrandTotalsPosition
as Bottom.
Also, in this sample, you can hide subtotals for specific fields too. It can be achieved by selecting appropriate fields from the drop-down available under the Hide sub-totals category. To hide subtotals for a specific field, set the ShowSubTotals
property as false inside the field definition.