Synopses & Reviews
Design and deliver insightful and interactive Web-based reports
Transform your companys valuable data into easily shared information with help from this definitive resource. Written by a member of the development team, this hands-on guide covers everything from installation to administration and shows you how to create visually appealing reports with ease and accuracy. Youll get a firm understanding of the entire report-building process by following a case study throughout the course of the book. Learn first-hand how to extract data using Query Builder and master key tools such as the Report Wizard and Report Manager. Leverage the power of Microsofts most powerful server-based reporting solution to improve business decision-making and facilitate company-wide--even worldwide--communication.
Essential Skills for Database Professionals
- Follow steps to prepare for a smooth installation process
- Explore the ins and outs of the SELECT query and ensure data integrity
- Create cleanly designed interactive reports and deliver them in a timely manner
- Generate reports with the aid of the Report Wizard and from scratch
- Work with line, text box, and rectangle controls
- Add polish to your reports with images, color, and charts
- Control the properties of a report item using Visual Basic expressions
- Use the Report Manager to share information in a secure, managed environment
About the
Synopsis
Key Features and Benefits- Get practical, re-usable report and code samples.- Use a structured approach to report development.- Work with both administration and implementation to get the most from SQL Server Reporting Services.
Synopsis
Generate and distribute comprehensive, integrated reportsTransform disparate corporate data into business intelligence with help from this hands-on guide. Microsoft SQL Server 2005 Reporting Services explains how to create, manage, and deliver traditional and interactive reports with this powerful server-based reporting solution. Written by a member of the Reporting Services development team, the book covers the entire report-building and distribution process and offers complete details on all the product's integrated features. Improve business decision-making in your organization by getting the right information to the right people at the right time.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS
- Install and set up SQL Server 2005 Reporting Services
- Use the SELECT query to extract report data from your data sources
- Add charts, images, and other graphics
- Generate reports using the Report Wizard and from scratch
- Maintain a secure, managed environment
- Integrate reports with desktop and web applications
- Enable end-user access to reports via the Report Server and its Report Manager web interface
- Export reports to other presentation and data exchange rendering formats
Synopsis
Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.
Synopsis
Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.
About the Author
Brian Larson (Arden Hills, MN), MCSD, served as a member of the Reporting Services development team on a contract basis, and has contributed to the code base. He is the Chief of Technology (COT) for Superior Consulting Services (SCS) in the Twin Cities. SCS is a Microsoft Certified Partner and is currently developing a client solution that uses Microsoft Reporting Services for report production and distribution.
Brian has been invited to speak on Reporting Services at several conferences including SQL Server Magazine Connections (both in Vegas and Orlando), has been interviewed as a subject matter expert by Microsoft TechNet, .NET Rocks, and others and has written articles for SQL Server Magazine.
Table of Contents
FOREWORDACKNOWLEDGMENTSINTRODUCTIONPart I: Getting StartedChapter 1: Let's Start at the Very BeginningChapter 2: Putting the Pieces in Place: Installing Reporting ServicesPart II: Report AuthoringChapter 3: DB 101: Database BasicsChapter 4: A Visit to Emerald City: The Report WizardChapter 5: Removing the Train Wheels: Building Basic ReportsChapter 6: Graphic Expression: Using Charts and Images in ReportsChapter 7: Kicking It Up a Notch: Intermediate ReportingChapter 8: Beyond Wow: Advanced ReportingChapter 9: A Leading Exporter: Exporting Reports to Other Rendering FormatsPart III: Report SavingChapter 10: How Did We Ever Manage Without You? The Report ManagerChapter 11: Delivering the Goods: Report DeliveryChapter 12: Extending Outside the Box: Customizing Reporting ServicesPart IV: AppendixesAPPENDIX A: REPORT ITEM REFERENCEAPPENDIX B: WEB SERVICE INTERFACE REFERENCEAPPENDIX C: REPORT DEFINITION LANGUAGE REFERENCEAPPENDIX D: AD HOC REPORTINGINDEX