Figure 8-9: Reseller Sales by Qtr & Region
The example shown in figure 8-9 is available in the downloaded reports under Chapter 05-08 Misc Report Samples / Reseller Sales by Quarter and Region (matrix 3 groups per axis). The data source for this report is the sample Analysis Services database and the data set returns sales for only domestic (US) regions. If I modify the data set to return all sales regions, I find that the column headings "Qty" and "Amount" repeat for each country group. This tends to clutter the presentation and I have tried change the format so that these heading appear only at the top of the page. For example, a row can be inserted above the row group headers and the above column headings moved there. The downside is that these headings would not be able to be repeated on additional pages if multiple pages are generated. While this doesn't happen in this example, I am thinking of how this would be handled where the data required that. Is there a way to do this?