![activereports 7 sort matrix activereports 7 sort matrix](https://global-cdn.grapecity.com/en/pages/activereports/usecase-acroforms.jpg)
Right-click the Year cell and select Subtotal.Adding subtotals displays totals for each group in a new column to the right of the group. Without subtotals, viewing the report at run time shows data for each year, or if expanded, for each quarter or month.
#ACTIVEREPORTS 7 SORT MATRIX PLUS#
This enables users to click the plus sign next to the quarter to view the monthly details at runtime. In the drop down enabled below, enter TextBox5 (Textbox containing Quarter values in the Matrix) and click OK to close the dialog.Under Visibility, change the Initial visibility to Hidden and select the check box next to Visibility can be toggled by another report item.On the Column Groups page, select the Matrix1_Month group and go to the Visibility tab.Select the Matrix data region and under the Properties Window select Property dialog command to open the Matrix dialog.This adds a cell below the Year cell and automatically adds a Month grouping to the Column Groups for the matrix. In the Report Explorer from the Sale dataset, drag the Month field to the Quarter cell and move the cursor down slightly so that the bar appears at the bottom edge of the cell before dropping it.This enables users to click the plus sign next to the Year to view the quarterly details at runtime. In the drop down enabled below, enter TextBox3 (Textbox containing Year values in the Matrix) and click OK to close the dialog.Tip: In order to provide drill-down functionality, we must set visibility on the group we want to hide. To add nested grouping and drilldown features to the matrix With the SalesAmount cell selected, in the Properties window set the Format property to Currency and the Value property to =Sum(Fields!SalesAmount.Value).This is the detail data cell, and displays aggregated data for the intersection of each column and row at run time. In the Report Explorer from the Sale dataset, drag the SalesAmount field into the bottom right cell in the matrix.
![activereports 7 sort matrix activereports 7 sort matrix](https://us-east-1.tchyn.io/snopes-production/uploads/2017/08/virgin_of_guadalupe_fb.jpg)
![activereports 7 sort matrix activereports 7 sort matrix](http://www.enhansoft.com/wp-content/uploads/2019/05/Interactive-Sorting-in-a-SSRS-Matrix-Interactive-Icons.jpg)
The matrix initially has four textbox cells. From the toolbox, drag a Matrix data region onto the body of the report in the top left corner.Click the gray area below the design surface to select the report, go to the Properties Window, expand the PageSize property and set the Width to 10in and Height 11in.