Pro SQL Server 2012 Reporting Services

Pro SQL Server 2012 Reporting Services

by Brian McDonald, Shawn McGehee, Rodney Landrum
     
 

View All Available Formats & Editions

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

See more details below

Overview

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 Contents1. 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

Read More

Product Details

ISBN-13:
9781430238119
Publisher:
Apress
Publication date:
07/31/2012
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
516
File size:
21 MB
Note:
This product may take a few minutes to download.

Related Subjects

Meet 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.
strongRodney Landrum/strong 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 emWindows and .NET/em, emSQL Server/em, emConnected Home/em, emT-SQL Solutions/em, emMicrosoft Certified Professional/em, and emElectronic House/em.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >