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: Microsoft Visual Studio .NET 2003
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: Checking for ASP.NET support
Figure 2-6: The services entry for the Distributed Transaction Coordinator
Figure 2-7: The Distributed Transaction Coordinator Properties (Local Computer) dialog box
Figure 2-8: The Component Update screen
Figure 2-9: The System Prerequisites Check screen with required software missing
Figure 2-10: The System Prerequisites Check screen with all required software detected
Figure 2-11: The Feature Selection screen with the default configuration
Figure 2-12: The Feature Selection screen for a full installation
Figure 2-13: The Feature Selection screen for a server installation
Figure 2-14: The Service Account screen
Figure 2-15: The Reporting Services Virtual Directories screen
Figure 2-16: The Report Server Delivery Settings screen
Figure 2-17: The Report Server Delivery Settings screen
Figure 2-18: The Report Server Samples Setup screen
Figure 2-19: The Licensing Mode screen
Figure 2-20: The Component Update screen
Figure 2-21: The System Prerequisites Check screen for a report designer installation
Figure 2-22: The Feature Selection screen with the default configuration
Figure 2-23: The Feature Selection screen for a report designer installation
Figure 2-24: The Report Server Web Farm Setup screen

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 department 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 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 custom templates
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 after Task 3
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
Figure 7-11: The Employee List Report preview
Figure 7-12: The Overtime Report layout
Figure 7-13: The Overtime Report preview
Figure 7-14: The RDL for the Overtime Report
Figure 7-15: The Color element within the tmpl_Name Textbox element

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 Employee Evaluation Detail Report layout
Figure 8-14: The Employee Evaluation Report preview after Task 2
Figure 8-15: The Employee Evaluation Report layout with a rectangle
Figure 8-16: The Employee Evaluation Report preview with a rectangle
Figure 8-17: The Invoice Report layout with an invoice header
Figure 8-18: The Invoice Report preview

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

Figure 9-1: The Export button on the Preview tab
Figure 9-2: The Print Preview button on the Preview tab
Figure 9-3: The RenderingTest report in the Preview tab
Figure 9-4: The Windows Picture and Fax Viewer with an 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 an Excel file
Figure 9-9: The RenderingTest report exported to an 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 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 Configurations 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 (top)
Figure 10-12: The New Data Source page (bottom)
Figure 10-13: The Chapter 06 folder list view
Figure 10-14: The Chapter 06 folder detail view
Figure 10-15: The Refresh Report button in the Report Viewer toolbar
Figure 10-16: Code access security
Figure 10-17: The security page for the Home folder
Figure 10-18: The New Role Assignment page
Figure 10-19: Browser rights in the Home folder
Figure 10-20: Content Manager rights in the Galactic Delivery Services folder
Figure 10-21: Browser rights for the RenderingTest report
Figure 10-22: View Report rights for the SubReportTest report
Figure 10-23: Insufficient rights error
Figure 10-24: 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, the 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, top
Figure 11-10: The Subscription Properties page, bottom
Figure 11-11: The My Subscriptions page
Figure 11-12: Data-Driven Subscription process, first page
Figure 11-13: Data-Driven Subscription process, Shared Data Source page
Figure 11-14: Data-Driven Subscription process, Query page
Figure 11-15: Data-Driven Subscription process, Data Association page
Figure 11-16: Data-Driven Subscription process, Parameter Values page
Figure 11-17: Data-Driven Subscription process, Notify Recipients page
Figure 11-18: 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




Microsoft SQL Server 2000 Reporting Services
Microsoft SQL Server 2000 Reporting Services Step by Step (Pro-Step by Step Developer)
ISBN: 0735621063
EAN: 2147483647
Year: 2003
Pages: 109

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