Front Matter....Pages i-xxi Introducing the Reporting Services Architecture....Pages 1-17 Report Authoring: Designing Efficient Queries....Pages 19-37 Introduction to Reporting Services Design with SQL Server Data Tools....Pages 39-59 Laying Out a Report....Pages 61-88 Implementing Dashboard-Style Report Objects....Pages 89-123 Building Reports....Pages 125-183 Using Custom .NET Code with Reports....Pages 185-211 Deploying Reports....Pages 213-242 Rendering Reports from .NET Applications....Pages 243-278 Managing Reports....Pages 279-327 Securing Reports....Pages 329-359 Delivering Business Intelligence with SSRS....Pages 361-399 Creating Reports Using Report Builder 1.0, 2.0, and 3.0....Pages 401-482 Back Matter....Pages 483-492
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 toolswithwhich 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
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 Annotation Pro SQL Server 2012 Reporting Servicesopens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsofts enterprise-level reporting platform. It is included with many editions of SQL Server, and is something youll want to take advantage of if youre running SQL Server as your database engine. Reporting Services provides a full set of toolswithwhich 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 expertsBrian McDonald, Rodney Landrum, andShawn McGeheeshow 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 ServicesCovers the very latest in new features for SQL Server 2012Your key to delivering business intelligence across the enterpriseWhat youll learnWrite efficient queries on which to base a reportBuild and lay out a report using Report DesignerEnable end users to create ad hoc reports on demandCombine Reporting Services with Analysis Services, SharePoint Server, and other technologies to deliver business intelligence across the enterpriseSecure and audit your reports as part of your regulatory compliance effortsCustomize your reports using C♯ assemblies and embedded Visual Basic .NET codeWho this book is forPro SQL Server 2012 Reporting Servicesis 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 Architecture2. Report Authoring: Designing Efficienc Queries3. Introduction to Reporting Services Design with SQL Server Data Tools4. Laying Out A Report5. Implementing Dashboard-Style Report Objects6. Building Reports7. Using Custom .NET Code with Reports8. Deploying Reports9. Rendering Reports from .NET Applications10. Managing Reports11. Securing Reports12. Delivering Business Intelligence using SSRS13. Creating Reports using Report Builder 1.0, 2.0, and 3.0
