Pro SQL Server 2012 Reporting Services

1. Front Matter

   Pages i-xxi

   PDF

2. Introducing the Reporting Services Architecture

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 1-17

3. Report Authoring: Designing Efficient Queries

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 19-37

4. Introduction to Reporting Services Design with SQL Server Data Tools

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 39-59

5. Laying Out a Report

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 61-88

6. Implementing Dashboard-Style Report Objects

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 89-123

7. Building Reports

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 125-183

8. Using Custom .NET Code with Reports

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 185-211

9. Deploying Reports

   • Brian McDonald, Shawn McGehee, Rodney Landrum

   Pages 213-242

10. Rendering Reports from .NET Applications

    • Brian McDonald, Shawn McGehee, Rodney Landrum

    Pages 243-278

11. Managing Reports

    • Brian McDonald, Shawn McGehee, Rodney Landrum

    Pages 279-327

12. Securing Reports

    • Brian McDonald, Shawn McGehee, Rodney Landrum

    Pages 329-359

13. Delivering Business Intelligence with SSRS

    • Brian McDonald, Shawn McGehee, Rodney Landrum

    Pages 361-399

14. Creating Reports Using Report Builder 1.0, 2.0, and 3.0

    • Brian McDonald, Shawn McGehee, Rodney Landrum

    Pages 401-482

15. Back Matter

    Pages 483-492

    PDF

Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft’s enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you’ll want to take advantage of if you’re running SQL Server as your database engine.

Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic.

• Provides best practices for using Reporting Services
• Covers the very latest in new features for SQL Server 2012
• Your key to delivering business intelligence across the enterprise

Brian K. McDonald, MCDBA, MCSD, is a business intelligence and data warehouse geek working for Acosta, the top sales and marketing company in the US. Brian was born and raised in Cincinnati, Ohio but he currently lives in Jacksonville, Florida with his beautiful wife and his two little ninja's; Bailey and Kylie. As an independent consultant, Brian has experiences in architecting data warehouses, data modeling, database administration, SQL Server Reporting Services, Integration Services, and Analysis Services. He has worked as an application developer, network administrator, and database administrator throughout his 12 years in the IT industry. A characteristic groomed while serving his country in the United States Marine Corps, Brian takes pride in all his projects and diligently works to not only meet expectations, but greatly exceed them. Brian has written for many industry websites and continually strives to improve his skill-set both professionally and personally. Brian is an active member of his local SQL Server User's Group and has presented for user groups, Code Camps and many SQL Saturday events in the southeast U.S. When not working, Brian enjoys "geeking" out with his wife Sherri and allowing his children to practice their UFC style moves on him.

Policies and ethics