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.
|
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->ShowColumnGrandTotalsas false.
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.