List of Figures

Chapter 1: Let’s Start at the Very Beginning

Figure 1–1: The New Project dialog box

Figure 1–2: Report structure

Figure 1–3: The Report Designer in the Business Intelligence Development Studio

Figure 1–4: Report serving architecture

Figure 1–5: The Report Manager website

Chapter 2: Putting the Pieces in Place—Installing Reporting Services

Figure 2–1: Reporting Services component parts

Figure 2–2: The server installation

Figure 2–3: A distributed installation of Reporting Services

Figure 2–4: A web farm installation of Reporting Services

Figure 2–5: The services entry for the Distributed Transaction Coordinator

Figure 2–6: The Distributed Transaction Coordinator Properties (Local Computer) dialog box

Figure 2–7: The Feature Selection page for a Reporting Services full installation

Figure 2–8: The Feature Selection page for a Reporting Services server installation

Figure 2–9: The Feature Selection page for a Reporting Services report author installation

Figure 2–10: The Feature Selection page for a Reporting Services distributed or web farm installation

Figure 2–11: The Instance Name page

Figure 2–12: The Service Account page

Figure 2–13: The Report Server Installation Options page

Figure 2–14: The Report Server Installation Instance Selection dialog box connecting to a server

Figure 2–15: The Report Server Installation Instance Selection dialog box selecting an instance

Figure 2–16: The Report Server Virtual Directory Settings page

Figure 2–17: The Report Manager Virtual Directory Settings page

Figure 2–18: The Windows Service Identity page

Figure 2–19: The Web Service Identity page

Figure 2–20: The Database Connection page

Figure 2–21: The Encryption Key page

Figure 2–22: The Initialization page

Figure 2–23: The E-mail Settings page

Figure 2–24: The Execution Account page

Chapter 3: DB 101—Database Basics

Figure 3–1: My attic, with no organization

Figure 3–2: An unorganized database

Figure 3–3: My attic in my fantasy world

Figure 3–4: A database organized by tables

Figure 3–5: A database table organized by rows and columns

Figure 3–6: Database tables with duplicate data

Figure 3–7: A database relation

Figure 3–8: A one-to-one relation

Figure 3–9: Tracking business type using a one-to-many relation

Figure 3–10: Tracking the business type using a many-to-many relation

Figure 3–11: The result set from the Customer table-to-Invoice Header table join

Figure 3–12: The set representation of the Customer and Invoice Header tables

Figure 3–13: The set representation of the inner join of the Customer table and the Invoice Header table

Figure 3–14: The set representation of the left outer join of the Customer table and the Invoice Header table

Figure 3–15: The result set from the left outer join of the Customer table and the Invoice Header table

Figure 3–16: The result set from the join of the Customer table, the Customer To Business Type Link table, and the Business Type table

Figure 3–17: The Customer/Parent Customer relation

Figure 3–18: The result set from the Customer table self-join

Figure 3–19: The sorted result set from the left outer join of the Customer table and the Invoice Header table

Figure 3–20: The package tracking tables from the Galactic database

Figure 3–21: The personnel deportment tables from the Galactic database

Figure 3–22: The accounting department tables from the Galactic database

Figure 3–23: The transport maintenance tables from the Galactic database

Figure 3–24: The SELECT statement in its simplest form

Figure 3–25: A SELECT statement with a FIELD LIST

Figure 3–26: A DISTINCT query

Figure 3–27: A SELECT statement with a JOIN clause

Figure 3–28: A SELECT statement with two JOIN clauses

Figure 3–29: A SELECT statement with an INNER JOIN and an OUTER JOIN

Figure 3–30: A SELECT statement with a WHERE clause

Figure 3–31: A SELECT statement with two logical expressions in the WHERE clause

Figure 3–32: A SELECT statement with an ORDER BY clause

Figure 3–33: A SELECT statement with a constant in the FIELD LIST

Figure 3–34: A SELECT statement with a calculated column in the FIELD LIST

Figure 3–35: A SELECT statement using the ISNULL() function

Figure 3–36: A SELECT statement with a GROUP BY clause

Figure 3–37: A SELECT statement with a HAVING clause

Chapter 7: Kicking It Up a Notch—Intermediate Reporting

Figure 7–1: The report template layout

Figure 7–2: The report template on the Preview tab

Figure 7–3: The report template in Print Preview mode

Figure 7–4: The Add New Item dialog box with a custom template

Figure 7–5: Employee Time Report layout after Task 2

Figure 7–6: Employee Time Report preview after Task 2

Figure 7–7: Employee Time Report preview

Figure 7–8: The Employee Time Report layout after Task 4

Figure 7–9: The Employee Time Report preview after Task 4

Figure 7–10: The Employee List Report layout after Task 2

Figure 7–11: The Employee List Report preview after Task 2

Figure 7–12: The Employee List Report with interactive sorting

Figure 7–13: The Edit Expression dialog box with parameter information

Figure 7–14: The Employee Mailing Labels Report preview after Task 1

Figure 7–15: The Employee Moiling Labels Report layout after Task 2

Figure 7–16: The Employee Mailing Labels Report preview after Task 2

Figure 7–17: The Overtime Report layout

Figure 7–18: The Overtime Report preview

Figure 7–19: The RDL for the Overtime Report

Figure 7–20: The Prompt element of the Week report parameter

Chapter 8: Beyond Wow—Advanced Reporting

Figure 8–1: The Delivery Status Report layout after Task 3

Figure 8–2: The Delivery Status Report preview after Task 3

Figure 8–3: The Delivery Status Report preview after Task 4

Figure 8–4: The Lost Delivery Report layout after Task 2

Figure 8–5: The Lost Delivery Report preview after Task 2

Figure 8–6: The Lost Delivery Report layout after Task 3

Figure 8–7: The Lost Delivery Report preview after Task 3

Figure 8–8: The payroll check layout after Task 1

Figure 8–9: The payroll check layout after Task 2

Figure 8–10: The payroll check preview

Figure 8–11: Weather Report layout

Figure 8–12: Weather Report preview

Figure 8–13: The MDX Query Designer

Figure 8–14: The MDX Query Designer containing the query for the Delivery Analysis Report

Figure 8–15: The Employee Evaluation Detail Report layout

Figure 8–16: The Employee Evaluation Report preview after Task 2

Figure 8–17: The Employee Evaluation Report layout with a rectangle

Figure 8–18: The Employee Evaluation Report preview with a rectangle

Figure 8–19: The Invoice Report layout with on invoice header

Figure 8–20: The Invoice Report preview

Figure 8–21: The Transport Monitor Report preview

Chapter 9: A Leading Exporter—Exporting Reports to Other Rendering Formats

Figure 9–1: The Export menu on the Preview tab

Figure 9–2: The Print Layout

Figure 9–3: The RenderingTest report in the Preview tab

Figure 9–4: The Windows Picture and Fax Viewer with on annotated report

Figure 9–5: The RenderingTest report exported to a TIFF file

Figure 9–6: The RenderingTest report exported to a PDF file

Figure 9–7: The RenderingTest report exported to a web archive file

Figure 9–8: The document map from the RenderingTest report exported to on Excel file

Figure 9–9: The RenderingTest report exported to on Excel file

Figure 9–10: The RenderingTest report exported to an HTML file

Chapter 10: How Did We Ever Manage Without You? The Report Manager

Figure 10–1: The Report Manager with no folders defined

Figure 10–2: The New Folder page

Figure 10–3: The Chapter09 Property Pages dialog box

Figure 10–4: A report and a shared data source ready to deploy

Figure 10–5: Deploying the report and shared data source

Figure 10–6: Modifying the shared data source to point to the production database server

Figure 10–7: A subsequent deployment with OverwriteDataSources set to False

Figure 10–8: The Solution Configuration drop-down list

Figure 10–9: The Upload File page

Figure 10–10: The Reporting Services Error page

Figure 10–11: The New Data Source page

Figure 10–12: The Chapter 06 folder list view

Figure 10–13: The Chapter 06 folder detail view

Figure 10–14: The Refresh Report button in the Report Viewer toolbar

Figure 10–15: Code access security

Figure 10–16: The security page for the Home folder

Figure 10–17: The New Role Assignment page

Figure 10–18: Browser rights in the Home folder

Figure 10–19: Content Manager rights in the Galactic Delivery Services folder

Figure 10–20: Browser rights for the RenderingTest report

Figure 10–21: View Report rights for the SubReportTest report

Figure 10–22: Insufficient rights error

Figure 10–23: A linked report

Chapter 11: Delivering the Goods—Report Delivery

Figure 11–1: Serving a report without caching

Figure 11–2: Serving a report with caching, the first time

Figure 11–3: Serving a report with caching, subsequent times

Figure 11–4: The Execution Properties page

Figure 11–5: The Schedule page

Figure 11–6: Report caching with parameters

Figure 11–7: The History Properties page

Figure 11–8: The Create/View History page

Figure 11–9: The Subscription Properties page

Figure 11–10: The My Subscriptions page

Figure 11–11: Data-Driven Subscription process, first page

Figure 11–12: Data-Driven Subscription process, Shared Data Source page

Figure 11–13: Data-Driven Subscription process, Query page

Figure 11–14: Data-Driven Subscription, Data Association page

Figure 11–15: Data-Driven Subscription, Parameter Values page

Figure 11–16: Data-Driven Subscription, Notify Recipients page

Figure 11–17: The main Site Settings page

Chapter 12: Extending Outside the Box—Customizing Reporting Services

Figure 12–1: Browsing folder contents using URL access

Figure 12–2: The Axelburg Invoice-Batch Number Report front end

Figure 12–3: Placing a Report Viewer control on a Windows form

Figure 12–4: Opening the ReportViewer Tasks dialog box

Figure 12–5: The Report Viewer control with the parameter entry area

Figure 12–6: The Report Viewer displaying a report with drilldown

Figure 12–7: Layout of the local report

Figure 12–8: Authentication and authorization at the amusement park

Appendix D: Ad Hoc Reporting

Figure D-1: Creating a Report Model project

Figure D-2: The Select Report Model Generation Rules page of the Report Model Wizard

Figure D-3: The Report Model Wizard creating the report model

Figure D-4: Entities in the Galactic Report Model

Figure D-5: Attributes and roles of the Customer entity in the Galactic Report Model

Figure D-6: The Galactic Report Model deployed to the Report Server

Figure D-7: The Report Model Properties dialog box in the SQL Server Management Studio

Figure D-8: The Model Item Security page of the Report Model Properties dialog box

Figure D-9: Selecting a source of data from a Report Model with four perspectives

Figure D-10: The Report Builder screen

Figure D-11: The Define Formula dialog box

Figure D-12: Narrowing a column in the Report Builder

Figure D-13: Adding a column to the report

Figure D-14: The table report layout

Figure D-15: The table report preview

Figure D-16: The column Context menu

Figure D-17: The Delivery Month field formula

Figure D-18: The table report layout with monthly information

Figure D-19: The Filter Data dialog box

Figure D-20: The Sort dialog box

Figure D-21: The completed table report layout

Figure D-22: The completed table report preview

Figure D-23: The Back to Parent Report arrow in the Report Viewer

Figure D-24: Adding a new column grouping to the matrix

Figure D-25: Expanding the chart report item

Figure D-26: The chart report preview