MSSQL Server Reporting Services: The Authoring Phase: Overview Part I - Page 8

February 26, 2004


6.  Click, and then drag, the Category field from the Fields window to the left-most cell in the Detail row of the newly created table.


7.  Drag the SubCategory field to the middle cell in the Detail row, to the immediate right of the Category field.


8.  Drag the Product field to the right-most cell of the Detail row, to the right of the SubCategory field.


9.  Right-click the top of the right-most column (where we installed the Product field in the last step), as shown in Illustration 21, to open the context menu.


Click for larger image

Illustration 21: Right-Click the Top of the New Product Column


10.  Select Insert Column to the Right on the context menu (circled in Illustration 21 above).


A new, empty column appears.


11.  Drag the List_Price field to the Detail row cell in the newly appearing column, to the right of the Product field inserted above.


The table appears as shown in Illustration 22.



Illustration 22: The Table, with our Field Additions, on the Design Surface

12.  Click the Preview tab atop the Report Designer.

Report Designer generates a preview of the report that appears, within a moment, as partially shown in Illustration 23.


Illustration 23: The Report Preview (Partial View)

We have thus generated our basic report, entraining the data from our source, via a query, and placing it within the Report Design using a table.

Completing the report requires several steps that we will take up in our next article, The Authoring Phase: Overview Part II. We will rejoin our report file within the article, to accomplish the setting of various properties, grouping and other arrangements to meet the needs of the information consumers for whom we have designed and begun our example report.

13.  Select File --> Save Report1.rdl as ... from the main menu, as depicted in Illustration 24.


Illustration 24: Saving the Report Definition File

The Save File as dialog appears.

14.  Navigate to a convenient storage location.

15.  Type RS02_Authoring in the File name box of the dialog.

16.  Click Save to save the file as named.

We see the file appear in the Solution Explorer pane (upper right corner of the Report Designer), within the Reports directory. This shows, as an aside, the manner in which we can author numerous reports within a project, based upon the same data source / query combination. We will see in later articles how useful this can be in creating similar reports in an enterprise reporting environment that have differences in filters, among a host of other attributes.

17.  Select File --> Exit from the main menu.

18.  Save the Project and associated files, when prompted.

We will return to this Report Project, and the Report File and associated components that it contains, in our next article, where we will conclude our overview of Authoring.

Summary and Conclusion ...

In this article, we began an overview of the first of the main phases of the enterprise reporting life cycle. We introduced the article with observations surrounding the objectives of the MSSQL Server 2000 Reporting Services series, as well as the objectives of the initial phase overview articles, and then discussed the Authoring phase in general. We began an exploration of the steps involved in Authoring a blank report, mentioning in passing the general ways of creating reports, each of which we will revisit numerous times in later articles.

After introducing the Authoring phase, we began a practice example in which we set out to create a tabular report. First, we created the Report Project to house the Report File that we created next. Within the Report File, we established a Data Connection, and then built a simple SQL query to use against our specified data source, the AdventureWorks2000 sample OLTP database. We then designed the report Layout, and, finally, added data from the dataset resulting from our query.

» 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