Skip to content

Microsoft SQL Server 2005 Reporting Services

ISBN-10: 0072262397

ISBN-13: 9780072262391

Edition: 2nd 2006 (Revised)

Authors: Brian Larson, Brian Welcker

List price: $52.00
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

This hands-on guide to Microsoft's powerful new reporting technology lets you build reports from virtually any data source.
Customers also bought

Book details

List price: $52.00
Edition: 2nd
Copyright year: 2006
Publisher: McGraw-Hill Education
Publication date: 1/2/2006
Binding: Paperback
Pages: 767
Size: 7.10" wide x 9.10" long x 1.55" tall
Weight: 2.882
Language: English

Craig Hayden is assistant professor of international communication at the School of International Service at American University. He has taught at the University of Virginia�s Department of Media Studies and at the University of Southern California Annenberg School for Communication. Craig was named a Research Fellow at the USC Center on Public Diplomacy in 2009. He blogs at the International Media Argument Project (www.intermap.org).Brian Cogan is associate professor in the Department of Communication Arts at Molloy College. List of Contributors: Michael Chemers; Brian Cogan; Martha Mary Daas; David Scott Diffrient; Jonathan Gray; Stephanie Hammer; James Hewitson; Hioni Karamanos; Nick Marx; Louise Noble; MJ Robinson; Lori Snaith; John-Paul StephensonJoni Richards Bodart is assistant professor in the School of Library and Information Science at San Jose State University. She is the author of The World's Best Thin Books: What to Read When Your Book Report is Due Tomorrow (Scarecrow, 2000), Radical Reads: 101 YA Novels on the Edge (Scarecrow, 2002), and Radical Reads 2: Working with the Newest Edgy Titles for Teens (Scarecrow, 2010).Brian Larson, MCITP, MCDBA, served as a member of the Reporting Services development team on a contract basis, and has contributed to the code base. He is the Vice President of Technology for Superior Consulting Services (SCS), a Microsoft Certified Partner. Brian has been invited to speak on Reporting Services at several conferences including SQL Server Magazine Connections, has been interviewed as a subject matter expert by Microsoft TechNet, .NET Rocks, and others, and has written articles for SQL Server Magazine.Mark Davis, MCITP, is Business Intelligence Practice Manager with Superior Consulting Services in Minneapolis. He has created BI solutions for clients across a wide spectrum of industries, including health care, finance, manufacturing, insurance, and numerous others.Dan English, MVP, MCITP, is a Microsoft SQL Server MVP, a MCITP Business Intelligence Developer for Microsoft SQL Server 2005 and 2008, and an MCTS for Microsoft Office SharePoint Server 2007 – Configuring. Dan is a Principal BI consultant at Superior Consulting Services. He currently helps to lead the Minnesota Business Intelligence User Group and is an avid blogger (http://denglishbi.wordpress.com), Microsoft forums helper, and tweeter (@denglishbi).Paul Purington, MCITP, is a partner and member of the management team at Superior Consulting Services. As a BI consultant, Paul has experience with both large and small-scale business intelligence environments.

Foreword
Acknowledgments
Introduction
Getting Started
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
Report Serving Architecture
Report Server
Report Delivery
Diving In
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 2005 Installation
The Report Server Configuration Manager
Common Installation Issues
Administrative Rights
Server Components Not Shown on the Feature Selection Screen
Installation Error 1603
Installation Error 2755
The Installation Log File
Spending Some Time in Basic Training
Report Authoring
DB 101: Database Basics
Database Structure
Getting Organized
Retrieving Data
Galactic Delivery Services
Company Background
Querying Data
The SELECT Query
On to the Reports
A Visit to Emerald City: The Report Wizard
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
Removing the Training Wheels: Building Basic Reports
Riding Down Familiar Roads
The Transport List Report
Data Regions
The Repair Count By Type Report
New Territory
The Transport Information Sheet
Getting Graphical
Graphic Expression: Using Charts and Images in Reports
Chart Your Course
The Fuel Price Chart
The Fuel Price Chart, Version 2
The Business Type Distribution Chart
The Days in Maintenance Chart
Image Is Everything
Conference Nametags
Conference Place Cards
The Rate Sheet Report
Building Higher
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
Under the Hood
Viewing the RDL
Practicing Safe Source
Using Visual SourceSafe
Advance, Never Retreat
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
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
Printed Presentation Format
HTML Presentation Format
Data Exchange Formats
Comma-Separated Values (CSV) Data Exchange Format
XML Data Exchange Format
Call the Manager
Report Serving
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
Linked Reports
Creating a Linked Report
Delivering the Goods
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
Configuration Options and Default Values
My Reports
Other Pages Accessed from the Site Settings Page
A Sense of Style
The ReportingServices Style Sheet
Building On
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?
Appendixes
Report Item Reference
Report Objects
Layout Areas
Data Regions
Report Items
Property Reference
Properties
Web Service Interface Reference
Reporting Services Web Service
Creating a Web Reference
Credentials
Code Sample
ReportExecution2005 Properties
ReportExecution 2005 Methods
ReportService2005 Properties
ReportService2005 Methods
ReportService2005 and ReportExecution2005 Web Service Classes
Report Definition Language Reference
Report Definition Language
Default Values
RDL Structure
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