Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 888

cells will indicate the sales amount of a product or a store for a given
time and a city. Select the tabular report type and click Next.
Figure 17-6
9. On the Design the Table page, you can choose the results from the
data source to be shown in the report as well as how you want to
show them. You can move the fields to one of the Page, Group, or
Details panes. If you choose a specific field on the page, then for
each value of that field a new page will be created that shows the
fields in groups and details. A typical example would be to show the
sales of products by each year or by each store. In this example you
will be creating a report that creates a new page for the sales of
products for each year. Select the CalendarYear field and click the
Page button. Rows can be grouped based on a specific field. For ex-
ample, sales of various sizes of televisions in a store can be grouped
under a category called TVs. In this example you will be grouping the
sales of products based on the subcategory name. Grouping helps
you to organize reports for enhanced readability. Select the Eng-
lishProductSubCategoryName and click the Group button. Typically
there is a one-to-many relationship between a field in the group and