Pro SQL Server 2012 Reporting Services (Professional Apress) (Repost)

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

What you’ll learn

- Write efficient queries on which to base a report
- Build and lay out a report using Report Designer
- Enable end users to create ad hoc reports on demand
- Combine Reporting Services with Analysis Services, SharePoint Server, and other technologies to deliver business intelligence across the enterprise
- Secure and audit your reports as part of your regulatory compliance efforts
- Customize your reports using C# assemblies and embedded Visual Basic .NET code

Who this book is for

Pro SQL Server 2012 Reporting Services is aimed at data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services.
Table of Contents
1. Introducing the Reporting Services Architecture
2. Report Authoring: Designing Efficienc Queries
3. Introduction to Reporting Services Design with SQL Server Data Tools
4. Laying Out A Report
5. Implementing Dashboard-Style Report Objects
6. Building Reports
7. Using Custom .NET Code with Reports
8. Deploying Reports
9. Rendering Reports from .NET Applications
10. Managing Reports
11. Securing Reports
12. Delivering Business Intelligence using SSRS
13. Creating Reports using Report Builder 1.0, 2.0, and 3.0

About the Author
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.

Shawn McGehee is the senior database administrator for a nationwide health care company, residing in the Orlando area. He has been working in the IT industry for over 12 years and came from a development background before he moved into database administration in 2004. Shawn contributes to several online publications and speaks at SQL Saturdays and Code Camps as much as possible. Shawn was a co-author on Pro SQL Server 2008 Reporting Services, also by Apress. Shawn works with his local SQL Server user groups and was a founding member of the Pensacola SQL Server Users Group before making the move to the Orlando area and becoming active with OPASS.

Rodney Landrum is a MCSE working as a systems engineer, database administrator, and data analyst for a software development company in Pensacola, Florida, that specializes in applications for the healthcare industry. He writes software reviews and feature articles for numerous magazines, including Windows and .NET, SQL Server, Connected Home, T-SQL Solutions, Microsoft Certified Professional, and Electronic House.