Creating a multicolumn matrix report
This recipe will show how a multicolumn matrix can be implemented. Here we will expand our report to see how we can dissect it into detail where the rows are further split by months following years and the columns will also show the average price other than the quantity.
This recipe requires that you complete the recipe Creating a matrix report in this chapter.
- Create a new design as in the previous recipe or extend the design created in the previous recipe with the steps detailed here.
- From the Report Data toolbar, drag the control MonthOfYearId1 to the Row Group control next to Year. When you drop it a blue bar appears and it must face the Year column as shown here:
- From the Report Data ...