Wrox Programmer Forums
|
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
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 20th, 2009, 11:59 AM
Authorized User
 
Join Date: Sep 2009
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Sales record system mytouch Pro PHP 0 January 31st, 2007 06:26 AM
How to do sales report in php? mytouch Pro PHP 0 January 29th, 2007 02:12 PM
Sales Tax RaCheer ASP.NET 1.0 and 1.1 Basics 5 January 31st, 2006 10:54 AM
Table for sales forecast hosefo81 MySQL 0 November 25th, 2003 10:29 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.