book

Pro SQL Server 2012 Reporting Services, Third Edition

by Brian McDonald, Shawn McGehee, Rodney Landrum

August 2012

Intermediate to advanced

504 pages

13h 27m

English

Apress

Read now

Unlock full access

Understanding the Benefits of SSRSSQL Server 2008 R2 and 2012 Reporting Services EnhancementsSSRS and Business IntelligenceSSRS ArchitectureClient ApplicationsInstalling and ConfiguringDeploying SSRS SecurelySummary
Introducing the Sample Relational DatabaseIntroducing Query Design BasicsUsing a Parameterized Stored ProcedureSummary

Exploring the Elements of BIDSSetting Up a Basic IDEUnderstanding Report Definition Language (RDL)Adding a ReportSetting Up Data Sources and DatasetsConfiguring ParametersSetting up FiltersExpressionsSummary
Setting Up PaginationUsing Report ObjectsImplementing a ListImplementing a TextboxImplementing a TableImplementing a RectangleImplementing a MatrixSummary
Understanding the Chart Data RegionImplementing an ImageImplementing a GaugeImplementing a MapImplementing a Data BarImplementing a SparklineImplementing an IndicatorSummary
Creating a Report with the Report WizardBuilding Reports from ScratchFormatting the OutputAdding SubtotalsAdding InteractivitySetting Report Parameters with Stored ProceduresWorking with Multivalued ParametersApplying a FilterAdding a ChartAdding Tablix ElementsConfiguring Report and Group VariablesAdding the Gauge ControlAdding the Final TouchesSummary
Using Embedded Code in Your ReportUsing the ExceedMaxCosts FunctionUsing the ExceedMaxCost Function in a ReportAccessing .NET Assemblies from Embedded CodeUsing Custom Assemblies with Your ReportAdding a Class Library Project to Your Reporting SolutionDeploying a Custom AssemblyTroubleshooting Your ProjectSummary
Using Report ManagerUsing Report Builder 3.0Using BIDS and Visual Studio 2012Using the rs.exe UtilityUsing the Report Server Web ServiceRunning the ApplicationSummary
Implementing URL AccessURL Report Access Path FormatIntegrating SSRS 2012 with .NET ApplicationsRendering the Report LocallySummary
Exploring Management Roles in SSRS DeploymentManaging ContentSetting Up a Data Source for the ReportAltering Report Data SourcesCreating Snapshots for the Report HistoryPerforming Execution Auditing and Performance AnalysisDesigning the Log ReportMonitoring PerformanceControlling SSRS ProgrammaticallySummary
Encrypting DataIntroducing EncryptionSecuring Network Traffic Using SSLIntroducing SSRS RolesAuditing ReportsSummary
Building SSRS Reports for SQL Analysis ServicesInstalling SharePoint 2010 and SQL Server 2012 on a Stand-Alone ServerDeploying Reports in a SharePoint-Integrated SSRS InstallationCreating a Simple Dashboard to Display SSRS ReportsCreating Data AlertsSummary
Creating a Data Source ViewCreating Reports with Report Builder 1.0Creating a Table ReportCreating a Matrix ReportCreating a Chart ReportSummary

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