Flylib.com
List of Figures
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
Microsoft SQL Server 2000 Reporting Services Step by Step (Pro-Step by Step Developer)
ISBN: 0735621063
EAN: 2147483647
Year: 2003
Pages: 109
Authors:
Hitachi Consulting
,
Stacia Misner
BUY ON AMAZON
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Using the Data Link Properties Dialog Box
Raising and Handling Stored Procedure Errors
Creating Constraints, PrimaryKeys, Relationships Based on Multiple Columns
Formatting Column Values When Outputting Data as XML
Optimizing .NET Data Access
Qshell for iSeries
The Exit Status and Decision-Making
Additional Control Structures
Writing Programs for Qshell
Application Development Tools
Appendix C Qshell and CL Commands for the IFS
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Product Overview
Working with Framesets
Working with Shared Resources
How to Add Field Validation
Developer-Specific Enhancements
InDesign Type: Professional Typography with Adobe InDesign CS2
A Blank Sheet: Typing on Your Page
Swash Characters
Setting Tabs
Redefining Styles
Up Next
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Value Stream Mapping and Process Flow Tools
Descriptive Statistics and Data Displays
Variation Analysis
Identifying and Verifying Causes
Selecting and Testing Solutions
The Oracle Hackers Handbook: Hacking and Defending Oracle
The Oracle Network Architecture
Attacking the TNS Listener and Dispatchers
Attacking the Authentication Process
Oracle and PL/SQL
Defeating Virtual Private Databases
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies