MSSQL Server Reporting Services : Mastering OLAP Reporting: Drilling Through Using MDX - Page 11

October 20, 2005

Now that we have the Dataset in place, let's begin working within the Layout tab for the new report.

35.  Click the Layout tab.

The blank Layout tab for the report appears.

36.  Open the Toolbox to expose its component selection. (If it is not docked in the development environment, open it by simply selecting View --> Toolbox from the main menu, as depicted in Illustration 74.)


Illustration 74: Select View --> Toolbox, as Required ...

37.  Click the Table item.

38.  Click the Layout area, at approximately the center of the canvas (the mouse pointer has become a small table icon with a "crosshairs" symbol).

The Table Data Region appears on the canvas, similar to that shown in Illustration 75.


Illustration 75: Creating the Table Data Region on the Canvas

39.  From the Fields list, drag the_date to the middle row of the leftmost column in the Table Data Region, as depicted in Illustration 76.


Illustration 76: Inserting a Data Field into the Table

40.  From the Fields list, drag store_state to the middle row of the second column from the left (dropping it to the immediate right of the cell in which we dropped the_date in the preceding step).

41.  From the Fields list, drag store_city to the middle row of the third column from the left (dropping it to the immediate right of the cell in which we dropped store_state in the preceding step).

42.  Right-click the gray bar atop the third column.

43.  Select Insert Column to the Right from the context menu that appears, as shown in Illustration 77.


Illustration 77: Adding an Additional Column ...

A fourth, empty column is added.

44.  From the Fields list, drag store_name to the middle row of the new fourth column from the left within the Table Data Region.

45.  Right-click the gray bar atop the fourth column.

46.  Select Insert Column to the Right from the context menu that appears, as before.

47.  From the Fields list, drag brand_name to the middle row of the new fifth column from the left within the Table Data Region.

48.  Right-click the gray bar atop the fifth column.

49.  Select Insert Column to the Right from the context menu that appears, once again.

50.  From the Fields list, drag product_name to the middle row of the new sixth column from the left within the Table Data Region.

51.  Right-click the gray bar atop the sixth column.

52.  Select Insert Column to the Right from the context menu that appears, as before.

53.  From the Fields list, drag store_sales to the middle row of the new seventh column from the left (and the rightmost column) within the Table Data Region.

Now, let's narrow the columns to make working with them easier in the next steps.

54.  Hold down the SHIFT key, and beginning with the gray bar atop the first column, click the bar atop each of the seven columns in the Table Data Region to select / highlight all seven columns.

55.  With all columns selected, type a "1" n the very bottom box ("Width" in the Layout section) of the Properties window, as depicted in Illustration 78.


Illustration 78: Adjusting All Columns to 1-Inch Width ...

56.  Click just below the Properties window, to accept the setting and compact the columns in the Table Data Region.

The columns of the Table Data Region are each compacted to 1-inch widths.

57.  Right-click the gray bar (click anywhere within the table to make it reappear, if necessary) to the left of the middle row in the Table Data Region.

58.  Select Insert Group from the context menu that appears, as partially shown in Illustration 79.


Illustration 79: Adding a Group to the Newly Compacted Table ...

The Grouping and Sorting Properties dialog appears, defaulted to the General tab.

59.  Type the following into the Name box of the dialog.

gP_ProductName

60.  Click the top row in the Group on list, just beneath the Expression label, to expose the selector.

61.  Using the selector, select the following from the picklist provided to populate the top row of the list:

=Fields!product_name.Value

The Grouping and Sorting Properties dialog - General tab, with our input, appears as depicted in Illustration 80.


Illustration 80: The Completed Grouping and Sorting Properties Dialog – General Tab

62.  Click OK to accept our input and close the Grouping and Sorting Properties dialog.

The new Group Header and Footer appear.








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers