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 Aug 15, 2005

MSSQL Server Reporting Services: Mastering OLAP Reporting: Extending Conditional Formatting: SWITCH and Drilldown Defaults - Page 9

By William Pearson


Preview the Report to Ascertain that It Meets Business Requirements

Let's preview the report as it currently stands, to ensure that we have met the expressed business requirements of the information consumers.

1.  Click the Preview tab, atop the design environment.

The report executes, and appears as depicted in Illustration 34.

Click for larger image

Illustration 34: The Report Appears in Preview, Reflecting Our Changes

We see the effects of our handiwork. As we noted earlier, the conditional formatting of the Store_Profit value has the intended presentation effect. Moreover, we note that the Drink and Food families are presented in a "drilled down" state by default, while the Non-Consumable family is presented with a default of "rolled up," with regard to drill down attributes. We find, too, that we can conduct drill down of the Non-Consumable family on an ad hoc basis, should the need arise, adding value to the report though the provision of capabilities to meet needs that the information consumers may not have foreseen at the time they communicated their initial specifications for the report to us.

2.  Select File --> Save All to save all work to this point.

3.  Select File --> Exit when ready to leave the Reporting Services development environment.

Conclusion ...

In this article, we extended our exploration of conditional formatting within Reporting Services to address a common need within the reporting environment, the requirement to present one of multiple possible formats, based upon the value of a given report measure. To introduce an approach to meeting such a requirement, we discussed briefly the SWITCH() function, and then embarked upon a practice example within which we address the presentation needs of a hypothetical group of information consumers.

After preparing for our practice session by creating a project within Reporting Services, and by creating a "clone" report (based upon an existing sample OLAP report to save time), we presented a technique for formatting negative values (as enclosed within parentheses, using red characters to draw attention) using a combination of properties settings and expressions, including the SWITCH() function. We then presented an approach for conditionally controlling the presentation of the default drilldown state of a given line item within a matrix report region. Finally, we reviewed the report in Report Designer, to verify the operation of the calculations that formed the scope of our practice exercise.

» See All Articles by Columnist William E. Pearson, III

Discuss this article in the MSSQL Server 2000 Reporting Services Forum.

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