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




Microsoft SQL Server 2005 Reporting Services
MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))
ISBN: 0735622507
EAN: 2147483647
Year: 2007
Pages: 115

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net