MSSQL Server Reporting Services: A New Paradigm for Enterprise Reporting - Page 3

January 28, 2004



The Managing Phase



Central management of the enterprise reporting function is a common and natural requirement in most organizations. Reporting Services again leverages its integration within MSSQL Server, and across the spectrum of the Microsoft applications that are pervasive in our enterprises. Reporting management functions, as many of us know, include a wide range of activities. Among these are security, scheduling, data source management, custody and control of the physical report files and the folders that contain them, and the maintenance of a diverse set of properties and resources.



One of the principal advantages that Reporting Services offers is the capability to manage reports and related items from a central location. Items that we can manage include reports, folders, data source connections, and resources. For these items, we define security, properties, and in some cases, scheduled operations. We can also create shared schedules and shared data sources, and make them available for general use.



The Report Manager centralizes these and other Reporting Services functions. Reports can be uploaded to the report server easily from either the Report Designer or the Report Manager, and can be viewed thereafter via a web browser. Multiple types of security can be assigned during the upload process, as well as elsewhere, as we see in Illustration 3, where I have chosen the sample reports folder, along with Windows NT Integrated Security, in the selection of the reports location (called the "data source" in this step).



Illustration 3: Tell Report Manager Which Reports to Upload via the New Data Source Window

NOTE: We will explore the many options available in Report Manager in our article, The Managing Phase, later in the series.

Next, we can simply select the reports we wish to upload by typing them in, or by navigating to their locations, with the Upload capability, after which the Report Manager window is populated with the reports in variable presentations, as shown in Illustration 4.


Illustration 4: Report Manager Displays Uploaded Reports for Selection by Information Consumers

Management capabilities can be controlled for end users by an Administrator, who can assign permissions, so in addition to the access security provided within Reporting Services, we are also given functional security options, for a refined set of controls over user activities. We will explore the degrees of management and various capabilities that are possible in our article, The Managing Phase, later, but suffice it to say that the overhead involved is widely customizable to an organization's needs. I will also present a subsequent article on report server administration to explore the options and processes that can be involved from that perspective.

Report Access and Delivery

Like most web-enabled enterprise reporting packages that exist today, Reporting Services allows "self-serve" access, where information consumers can view reports on demand. Consumers can also access reports via subscription processes, whereby reports are generated and delivered to the consumer at a specific destination on a recurring basis. Consumers that are granted access privileges can select a report from a folder hierarchy on the web server, in a process as simple as clicking one of the reports as depicted in Illustration 4 of our last section. The result is a report generated on demand, an example of which is depicted in Illustration 5.


Illustration 5: Sample Report Selected and Generated from the Browser of an Authorized Consumer

Subscription options include notification when a report is run, after which intended consumers can browse it at a standard location. E-mailing of a copy of the report to the intended audience is also accommodated. Notification and other processes can be based upon data-driven criteria: the recipient list can rely upon stored data that exists when the subscription is triggered, such as the data found in a customer database, for example.

Many interchangeable options exist with regard to viewing / exporting formats, as depicted in Illustration 6. Selections within the browser interface include XML file with data, CSV, TIFF, PDF (Adobe Acrobat), Web Archive, Excel, and HTML with Office Web Components. As we have already noted, integration with Microsoft Office is another obvious advantage offered by Reporting Services.


Illustration 6: Interchangeable Viewing Options Abound in Reporting Services

Summary and Conclusion ...

When Microsoft decided not to wait until the arrival of Yukon, the next release of MSSQL Server, to deliver Reporting Services, it offered organizations an early opportunity to shed the high-priced baggage of proprietary reporting options that have dominated enterprise reporting for many years. Reporting Services offers true integrated report authoring, management, and access and delivery in a single package, providing organizations a new paradigm in enterprise reporting. As we continue in our new series, we will examine in detail many of the capabilities of Reporting Services, comparing and contrasting them to the approaches of the past, and looking forward to a more cost effective, integrated tomorrow.

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

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

MSSQL Server Reporting Services
Introducing the Tablix Data Region: Basic Grouping Concepts
Introducing the Tablix Data Region in Reporting Services 2008
100% Stacked Column Chart for Analysis Services Data
XY (Scatter) Chart for Analysis Services Data
Simple Doughnut Chart for Analysis Services Data
Exploded Pie Chart for Analysis Services Data
Stacked Bar Chart for Analysis Services Data
Line Chart for Analysis Services Data
Stacked Column Chart for Analysis Services Data
A More Advanced Pie Chart for Analysis Services Data
Simple Pie Chart for Analysis Services Data
Simple Bar Chart for Analysis Services Data
Simple Column Chart for Analysis Services Data
Introducing Reporting Services Charts for Analysis Services
Mastering OLAP Reports: Parameterized Grouping
Mastering OLAP Reports: Parameterizing Number of "Top" Items with the MDX TopCount() Function, Part II
Mastering OLAP Reports: Parameterizing Number of "Top" Items with the MDX TopCount() Function, Part I
Mastering OLAP Reports: Parameterizing Number of "Look Back" Periods with the MDX LastPeriods() Function, Part II
Mastering OLAP Reports: Parameterizing Number of "Look Back" Periods with the MDX LastPeriods() Function, Part I
Support Parameterization from Analysis Services - Parameter Defaults
Parameterization from Analysis Services - Cascading Picklists
Support Parameterization from Analysis Services
Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets
Reporting Services: Customize Automatically Created Parameter Support Objects
Snapshot Reports II: SQL Server Management Studio Perspective
Snapshot Reports I: Report Manager Perspective
Report Execution Caching II: Report Manager Perspective
Report Execution Caching I: SQL Server Management Studio Perspective
Report Session Caching in Reporting Services 2005
Black Belt Administration: Reporting Services Configuration Manager
Intelligent Layering: Leverage Conditional Formatting Logic from Analysis Services
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part II
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part I
Mastering OLAP Reports: Extend Reporting Services with Custom Code
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II
Black Belt Components: Support Simple Navigation with a Document Map
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. I
Black Belt Components: Interactive Sorts within a Matrix Data Region
BlackBelt Authoring: Conditional Drillthrough to Multiple Reports
Mastering OLAP Reporting: Prototype KPIs in Reporting Services
BlackBelt Administration: Linked Reports in SQL Server Management Studio
BlackBelt Administration: Linked Reports in Report Manager
Mastering OLAP Reporting: Reporting with Analysis Services KPIs
Report Builder: Creating a Report Model
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part II
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 1
Mastering OLAP Reporting: Display a Dataset Field in a Report Page Header
Interactive Sorting Within Reporting Services
MSSQL Server Reporting Services: Mastering OLAP Reporting: Multiple Value Selection in a Parameter Picklist
MSSQL Server Reporting Services : Mastering OLAP Reporting: Drilling Through Using MDX
MSSQL Server Reporting Services: Mastering OLAP Reporting: Relationally-Based Picklists for OLAP Reporting
MSSQL Server Reporting Services: Mastering OLAP Reporting: Extending Conditional Formatting: SWITCH and Drilldown Defaults
MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of Total - Chart Presentation Nuances
MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of Total - Two Perspectives
MSSQL Server Reporting Services : Mastering OLAP Reporting: Ad Hoc TopCount and BottomCount Parameters
MSSQL Server Reporting Services: Black Belt Components: Ad Hoc Sorting with Parameters
MSSQL Server Reporting Services: Black Belt Administration: "Governor" Capabilities: Report Execution Timeout
MSSQL Server Reporting Services : Black Belt Administration: Execution Log Performance and Audit Reports
MSSQL Server Reporting Services: Black Belt Administration: Prepare the Execution Log for Reporting
MSSQL Server Reporting Services: Black Belt Components: Ad Hoc Conditional Formatting for OLAP Reports
MSSQL Server Reporting Services : Black Belt Components: Manage Nulls in OLAP Reports
MSSQL Server Reporting Services: Reporting Services Basics: Create a Reusable Template Report
MSSQL Server Reporting Services: Master Chart Reports: Track Exchange Rates in a Line Chart
MSSQL Server Reporting Services: Master Chart Reports: Pie Charts in Reporting Services
MSSQL Server Reporting Services: Mastering OLAP Reporting: Cascading Prompts
MSSQL Server Reporting Services: Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data
MSSQL Server Reporting Services: Managing Reporting Services: Report Execution and Standard Subscriptions
MSSQL Server Reporting Services: Managing Reporting Services: Data Connections and Uploads
MSSQL Server Reporting Services: The Authoring Phase: Overview Part II
MSSQL Server Reporting Services: The Authoring Phase: Overview Part I
MSSQL Server Reporting Services: A New Paradigm for Enterprise Reporting








The Network for Technology Professionals

Search:

About Internet.com

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