Overview
Teach yourself the fundamentals of SQL Server Reporting Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization.
Discover how to:
- Install and configure Reporting Services
- Author, manage, and access reports
- Create attractive, information-rich reports with the Report Designer
- Calculate values, organize information, and manipulate report data
- Build, deploy, and maintain a report model
- Render and distribute reports in various formats
- Implement role-based security to restrict access to information
- Explore more advanced report design techniques
- Programmatically customize any stage of the reporting lifecycle
CD features all practice exercises.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
Synopsis
Your hands-on guide to learning Microsoft SQL Server Reporting Services, Microsoft's customizable reporting solution for business data analysis. Reporting Services is a powerful tool for business intelligence, so an understanding of the essentials-how to architect a report, as well as how to install and program Reporting Services-is key to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to use the report project wizard, how to think about and access data, and how to build queries. It also walks you through the creation of charts and visual layouts to enable maximum visual understanding of the data analysis. Interactivity features (enhanced in SQL Server 2005) and security are also covered in detail. With Step By Step, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using Reporting Services. A companion CD includes data sets and sample code.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewWhether you're a manager or developer, you already know the fastest way to get results with SQL Server 2005 Reporting Services: hands-on, step-by-step, with an expert guide. That's why you want Microsoft SQL Server 2005 Reporting Services Step by Step.
Microsoft's Step by Step series has always taught well via example: this book's no exception. You don't need a background in enterprise reporting: Stacia Misner introduces all those concepts. Then, just load the practice files, and go.
Within a few chapters, you'll be comfortable connecting to data sources, designing reports, running the report wizard, and publishing. Then, you'll gain increasingly deep mastery over the data you select and how it looks: from simple formatting to sophisticated report modeling. There's a full section on managing and securing Report Server; and another on report delivery (print, online, Web). Reporting has rarely been this accessible. Bill Camarda, from the May 2006 Read Only