Microsoft SQL Server 2008 Reporting Services

Name: Microsoft SQL Server 2008 Reporting Services
Brand: McGraw-Hill
Price: 115.59 EUR
Availability: OnlineOnly

Brian Larson(Autor*in)

McGraw-Hill (Verlag)

1. Auflage

Erschienen am 21. August 2008

956 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-0-07-154809-0 (ISBN)

115,59 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Cover Page
Microsoft® SQL ServerT 2008 Reporting Services
Copyright Page
Contents
Foreword
Acknowledgments
Introduction
The Galactic Database and Other Supporting Materials
Part I Getting Started
Chapter 1 Let's Start at the Very Beginning
Sharing Business Intelligence
The Need to Share
Possible Solutions
Microsoft Reporting Services
Report Authoring Architecture
The Business Intelligence Project Type
Report Structure
Report Designer
Standalone Report Builder
Report-Serving Architecture
Report Server
Report Delivery
Diving In
Chapter 2 Putting the Pieces in Place: Installing Reporting Services
Preparing for the Installation
The Parts of the Whole
Editions of Reporting Services
Types of Reporting Services Installations
Installation Requirements
Other Installation Considerations
The Installation Process
The SQL Server 2008 Installation
The Reporting Services Configuration Manager
Common Installation Issues
Administrative Rights
Server Components Not Shown on the Feature Selection Screen
Installation Error 2755
Reporting Services and IIS on the Same Server
The Repair Utility and Installation Log File
Spending Some Time in Basic Training
Part II Report Authoring
Chapter 3 DB 101: Database Basics
Database Structure
Getting Organized
Retrieving Data
Galactic Delivery Services
Company Background
Querying Data
The SELECT Query
On to the Reports
Chapter 4 A Visit to Emerald City: The Report Wizard
Obtaining the Galactic Database
Your First Report
The Customer List Report
An Interactive Table Report
The Customer-Invoice Report
Creating Matrix Reports
The Invoice-Batch Number Report
Report Parameters
The Parameterized Invoice-Batch Number Report
Flying Solo
Chapter 5 Removing the Training Wheels: Building Basic Reports
Riding Down Familiar Roads
The Transport List Report
The Tablix and Data Regions
The Repair Count By Type Report
New Territory
The Transport Information Sheet
Getting Graphical
Chapter 6 Graphic Expression: Using Charts, Images, and Gauges
Chart Your Course
The Deliveries versus Lost Packages Chart
The Fuel Price Chart
The Fuel Price Chart, Version 2
The Business Type Distribution Chart
The Days in Maintenance Chart
Gauging the Results
The Digital Dashboard
Image Is Everything
Conference Nametags
Conference Place Cards
The Rate Sheet Report
Building Higher
Chapter 7 Kicking It Up a Notch: Intermediate Reporting
Never Having to Say "I'm Sorry
The Report Template
Handling Errors in Reports
The Employee Time Report
Data Caching During Preview
The Employee List Report
The Employee Mailing Labels Report
The Overtime Report
The Revised Employee Time Report
Under the Hood
Viewing the RDL
Practicing Safe Source
Using Visual SourceSafe
Advance, Never Retreat
Chapter 8 Beyond Wow: Advanced Reporting
Speaking in Code
The Delivery Status Report
The Lost Delivery Report
The Customer List Report-Revisited
Payroll Checks
The Weather Report
The Delivery Analysis Report
Reports Within Reports
The Employee Evaluation Report
The Invoice Report
Interacting with Reports
The Invoice Front-End Report
The Transport Monitor Report
A Conversion Experience
The Paid Invoices Report
What's Next
Chapter 9 A Leading Exporter: Exporting Reports to Other Rendering Formats
A Report in Any Other Format Would Look as Good
Exporting and Printing a Report
Presentation Formats
TIFF Image Presentation Format
Adobe PDF Presentation Format
Web Archive Presentation Format
Excel Presentation Format
Word Presentation Format
Printed Presentation Format
Data Exchange Formats
Comma-Separated Values (CSV) Data Exchange Format
XML Data Exchange Format
Call the Manager
Part III Report Serving
Chapter 10 How Did We Ever Manage Without You? The Report Manager
Folders
The Report Manager
Moving Reports and Supporting Files to the Report Server
Deploying Reports Using the Report Designer
Uploading Reports Using Report Manager
Uploading Other Items Using Report Manager
Uploading Reports Using .NET Assemblies
Modifying Reports from the Report Server
Managing Items in Folders
Moving Items Between Folders
Deleting a Folder
Renaming a Folder
Seek and Ye Shall Find: Search and Find Functions
Searching for a Report
Finding Text Within a Report
Printing from Report Manager
Printing Options
Managing Reports on the Report Server
Security
Roles
Linked Reports
Creating a Linked Report
Delivering the Goods
Chapter 11 Delivering the Goods: Report Delivery
Caching In
Report Caching
Enabling Report Caching
Execution Snapshots
Enabling Execution Snapshots
Report History
Enabling Report History
Managing Report History Snapshots
Updating Report Definitions and Report History Snapshots
Subscriptions
Standard Subscriptions
Managing Your Subscriptions
Data-Driven Subscriptions
Site Settings
The General Site Settings Page
Other Pages Accessed from the Site Settings Page
Managing Reporting Services Through the SQL Server Management Studio
Additional Settings
A Sense of Style
The ReportingServices Style Sheet
Building On
Chapter 12 Extending Outside the Box: Customizing Reporting Services
Using Reporting Services Without the Report Manager
URL Access
Web Service Access
The Report Viewer Control
SharePoint Web Parts
Reporting Services Utilities
Custom Security
Authentication and Authorization
Issues with Custom Security
Creating a Custom Security Extension
Deploying a Custom Security Extension
Using the Custom Security Extension
Other Extensions
Best Practices
Report-Authoring Practices
Report Deployment Practices
Where Do We Go from Here?
Part IV Appendixes
Appendix A Report Item Reference
Report Objects
Layout Areas
Data Regions
Report Items
Property Reference
Properties
Appendix B Web Service Interface Reference
Reporting Services Web Service
Creating a Web Reference
Credentials
Compatibility
ReportExecution2005 Properties
ReportExecution2005 Methods
ReportService2005 Properties
ReportService2005 Methods
ReportService2006
ReportService2005 and ReportExecution2005 Web Service Classes
Appendix C Ad Hoc Reporting
The Report Model
Creating a Report Model
Creating Reports with the Report Builder
Report Builder Basics
Creating a Table Layout Report
Creating a Matrix Layout Report
Creating a Chart Layout Report
Give It a Try
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken