BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2008 Reporting Services by Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee; ISBN: 9780470242018
You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8 section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
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?
Figure 8-9: Reseller Sales by Qtr & Region
Linear Mode
