Saturday, February 25, 2012

Only displaying the subtotal value in a matrix report.

Is there a way to make it so that a data column in a matrix only displays a value for the subtotal of a field?

If you add a toggle to the matrix column/row group, it will enable to switch between the detailed group instances (when expanded) or show the subtotals only (when collapsed). Take a look at the "Company Sales" sample report in the Adventure Works sample project that comes with RS.

-- Robert

No comments:

Post a Comment