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 Dec 18, 2006

Black Belt Components: Support Simple Navigation with a Document Map - Page 4

By William Pearson

14.  Click the Groups tab.

15.  Click Add ... to the right of the Rows list, in the upper half of the tab, as shown in Illustration 9.

Illustration 9: Adding a New Group ...

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

16.  Atop the General tab, replace the default entry that appears in the Name box with the following name:


17.  Click the currently empty top row in the Expression list within the Group on section of the tab, to enable the selector.

18.  Select =Fields!Product.Value within the selector, as depicted in Illustration 10.

Illustration 10: Selecting a “Group On” Expression for a New Group ...

19.  Click OK, to accept our selection, and to close the Grouping and Sorting Properties dialog.

We return to the Groups tab, where we see the new matrix1_Product entry (currently highlighted) within the Rows list, underneath the originally appearing matrix1_Sales_Reason group, as shown in Illustration 11.

Illustration 11: Two Row Groups Appear in the Groups Tab

20.  Click OK on the Groups tab, to close the Matrix Properties dialog.

A wider report layout appears, as expected.

21.  Once again on the Layout tab, within the Matrix Data Region, right-click the value appearing underneath the Internet Orders column heading (the leftmost of the three value cells).

22.  Select Properties on the context menu that appears, as depicted in Illustration 12.

Illustration 12: Modifying Properties for the Count Value ...

23.  On the Textbox Properties dialog that next appears, click the Format tab.

24.  Replace the existing Format code setting (in the upper left corner of the Format tab) with the following string:


Here we are simply changing the existing format to one more appropriate for a count value. The Format code appears on the Format tab of the Textbox Properties dialog as shown in Illustration 13.

Illustration 13: Replacing the Existing Format Code ...

25.  Click OK to accept our modifications, and to dismiss the Textbox Properties dialog.

We will next execute the report to ascertain that our modifications are complete, and that we have a working report for the practice session that follows.

26.  Click the Preview tab, as depicted in Illustration 14.

Illustration 14: Click the Preview Tab to Execute the Report

27.  Select Bikes in the Product Category parameter selector, as shown in Illustration 15.

Illustration 15: Select Bikes in the Parameter Selector ...

28.  Click the View Report button, as required.

The Report is being generated message briefly appears, and then the report displays. The modified report appears as partially depicted in Illustration 16.

Illustration 16: The Modified Report (Partial View)

We now have a clone OLAP report file within our Reporting Services 2005 Project, with which we can proceed in the next section to add the navigation support that our client colleagues need, using the Document Map feature.

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