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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 21, 2006

Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 1 - Page 6

By William Pearson

Replicate the Existing Sales Reason Comparisons Report Data within a New Matrix Data Region

We are now positioned to replicate the existing matrix data region that comprises the report with a new matrix data region, which will present identical information while supporting the new navigation and presentation business requirements of our users.

1.  1. Placing the mouse cursor over the bottom and right edges of the canvas, one after another, until the cursor becomes an "I" beam, drag edges of the canvas (not the data region) to approximately the measurement marks of 5 and 10 on the horizontal and vertical axes, respectively, as depicted in Illustration 22.

Click for larger image

Illustration 22: Extending the Report Canvas on the Layout Tab

2.  Drag a matrix data region object from within the Toolbox to the canvas area of the Layout tab.

3.  3. Drop the matrix data region onto the canvas below the existing table data region, as depicted in Illustration 23.

Click for larger image

Illustration 23: Adding a Matrix Data Region to the Report

The matrix data region appears on the canvas approximately as shown in Illustration 24.

Click for larger image

Illustration 24: The Matrix Data Region Appears ...

Our first task in replicating the information presented by the existing data region is to make the appropriate data source / data field associations within the new matrix. (Because we are using the same .rdl file as the former report, we can assume that the DataSets in place are adequate for our needs).

4.  4. Align the matrix data region just below the existing data region, so that it approximates the position of the original data region for easy reference as we proceed, as shown in Illustration 25.

Illustration 25: Align the Matrix for Easy Field Replication ...

5.  Click the top row of the matrix to select it.

6.  Increase the height of the top row in the Properties window to 1.5, as depicted in Illustration 26.

Illustration 26: Increase Height to 1.5 Inches ...

7.  7. Drag and drop a textbox, from the Toolbox, outside, and to the right of, the new matrix data region.

8.  Type the following title into the newly added textbox:

Adventure Works Cycles

9.  Highlight the text we have just typed, and then make the following settings from the tool bar atop the design environment:

Font Name: Arial

Font size: 12 pt.

Bold: Button Depressed

Italic: Button Depressed

10.  Click the Foreground Color button (to the immediate right of the Italic button).

11.  Select Dark Slate Blue from the Choose Color dialog that appears, as shown in Illustration 27.

Illustration 27: Select Dark Slate Blue in the Choose Color Dialog ...

12.  Click OK to accept the color setting, and to close the Choose Color dialog.

13.  Click the Center button in the alignment buttons group, to the right of the settings we have already made, as depicted in Illustration 28.

Illustration 28: Click the Center Button to Center the Title in the Textbox ...

MS SQL Archives

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