Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Oct 20, 2005

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

By William Pearson

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.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date