Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Overview and Installation - SQL Server Reporting Services 2012 -- SQL Server 2012 - mission statement by Microsoft -- Overview of Reporting Services 2012 -- Installing software used in the book -- SQL Server 2012 installation requirements -- Operating system requirements (64-bit) -- Hardware requirements -- Software requirements -- Configuring the hardware used for the book -- Hands-on exercise 1.1 - installing SQL Server 2012 -- Downloading the source file -- Installation steps -- Hands-on exercise 1.2 - verifying the installation -- Installation choices and notes -- Configuring SQL Server Reporting Services -- Hands-on exercise 1.3 - configuring SQL Server 2012 Reporting Services in Native mode -- Report Server - configuration options -- Installing sample databases -- Downloading files and running scripts -- SharePoint Server 2010 Enterprise Edition -- Installing SharePoint Server 2010 Enterprise Edition on Windows 7 (64-bit) -- Installing Reporting Services 2012 in SharePoint Integrated mode -- Reporting Services add-in for SharePoint 2010 -- Installing and starting the Reporting Services SharePoint Service -- Hands-on exercise 1.4 - installing the Reporting Services SharePoint Service -- Creating the Reporting Services Service application -- Activating the Power View site collection feature -- Summary -- Chapter 2: SQL Server Reporting Services 2012 Projects with Visual Studio 2012 -- What is business intelligence? -- Introduction to SQL Server Data Tools -- BI Projects on SSDT -- Report Server Project -- Report Server Project Wizard -- Creating reports using SSDT -- Hands-on exercise 2.1 - creating a report using the Report Server Project Wizard.

Hands-on exercise 2.2 - deploying the report to the Report Server -- Hands-on exercise 2.3 - creating a report using the Report wizard in SSDT -- Hands-on exercise 2.4 - modifying the report in Project RSPW2012 using an expression -- Report formats supported in Report Server Reports -- Report-related projects in Visual Studio 2012 -- Creating reports using Visual Studio 2012 -- Software and hardware requirements -- Hands-on exercise 2.5 - creating a report for a Windows Form application using Report Viewer Control -- Hands-on exercise 2.6 - creating a report using Report Viewer Control for the Web -- Hands-on exercise 2.7 - using Report Viewer Control in the remote mode -- Hands-on exercise 2.8 - converting an RDLC to a RDL file -- Microsoft Report Viewer Runtime -- Summary -- Chapter 3: Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools -- Structural design of SQL servers and SharePoint environment -- Native mode -- SharePoint Integrated mode -- Reporting Services configuration -- Native mode -- SharePoint Integrated mode -- Hands-on exercise 3.1 - modifying the configuration file in Native mode -- Turn on/off the Report Server Web Service -- Turn on/off the scheduled events and delivery -- Turn on/off the Report Manager -- Hands-on exercise 3.2 - turn the Reporting Service on/off in SSMS -- Salient features of Reporting Services 2012 -- Report definition -- XML-based report definition (.rdl file) -- Power View report contents -- Creating reports -- Report data -- New toolbox items in Report Builder 3 -- Report parts and their reusability -- Customizing reports -- Saving and deploying reports -- Report validation -- Viewing reports -- Managing reports -- Report scheduling -- Subscriptions and delivery -- Features new in RS2012 SharePoint Integrated -- Power View -- Data Alerts.

Implementing security - authentication and authorization -- Authentication -- Authorization -- URL access -- Reporting Services extensions -- Reporting Services tools -- Tools for Report Server administration -- Tools for report authoring -- Tools for report content management -- Summary -- Chapter 4: Working with Report Manager -- Tasks performed using Report Manager -- Starting Report Manager -- Starting Report Manager for the URL -- User access to Report Server (Report Manager) -- Considerations for giving user access to the Report Server -- First step - deploying reports -- Report Manager user interface -- Hands-on exercise 4.1 - creating, modifying, moving, and deleting folders -- Navigating the folders -- Creating a folder and a subfolder -- Moving an item into a folder -- Configuring permissions from Report Manager -- Configuring role-based security -- Hands-on exercise 4.2 - assigning a Windows user to the System Administrator role -- Creating a Windows user -- Assigning RSMax to the RS System Administrator role -- Assigning users to Item-Level roles -- Review users on reporting services database -- Hands-on exercise 4.3 - assigning a user to a Custom role -- Hands-on exercise 4.4 - creating permission to a specific report -- Report data sources -- Embedded data source -- Shared data source -- Hands-on exercise 4.5 - creating a shared data source on Report Manager -- Hands-on exercise 4.6 - creating a data model from a data source -- Viewing, searching, and printing reports -- Hand-on exercise 4.7 - view, print, and search on Report Manager -- Viewing reports -- Printing reports -- Search -- Uploading and downloading files from the Report Server to the file system -- Uploading a report on the computer to the Report Server -- Hands-on exercise 4.8 - uploading a report to the Report Server.

Hands-on execise 4.9 - downloading and reviewing a report definition file from the Report Server -- Report subscription and delivery -- Hands-on exercise 4.10 - creating an event-driven report subscription for delivery by e-mail -- Hands-on exercise 4.11 - creating an event-driven report subscription for delivery to a file share -- Hands-on exercise 4.12 - creating data-driven report subscription for delivery to a file share -- Create a Subscribers database in SQL Server -- Creating the data-driven Subscription and testing it -- Report caching -- Report processing options -- Cache refresh options -- Hands-on exercise 4.13 - creating a cache refresh plan by preloading the cache -- Snapshot and snapshot history -- Hands-on exercise 4.14 - creating a snapshot and snapshot history -- Summary -- Chapter 5: Working with Report Builder 3.0 -- Report authoring with Report Builder -- Downloading and installing Report Builder -- Report Builder 3.0 user interface -- Report authoring -- Hands-on exercise 5.1 - creating a report with an embedded data source -- Hands-on exercise 5.2 - creating a report from a shared data source -- Creating a List report -- Parameterized reports -- Subreports -- Hands-on exercise 5.3 - creating a report that has a subreport -- Creating the subreport -- Creating the main report -- Embedding the subreport in the main report -- Report with groups -- Hands-on exercise 5.4 - setting up a group and creating a document map -- Bring up the report from the previous hands-on exercise and remove parameter -- Adding a Document Map to the report -- Configuring page breaks -- Adding interactive sorting -- Drill-through and drill-down reports -- Drill-through reports -- Hands-on exercise 5.5 - Creating a drill-through report -- Source report -- Destination report -- Set up the drill-through action -- Drill-down report.

Hands-on exercise 5.6 - Creating a drill-down report -- Linked reports -- Hands-on exercise 5.7 - creating linked reports -- Customizing the linked report in the France folder -- Creating a report with XML data sources -- Creating a well-formed XML data -- Displaying data with sparklines, maps, data bars, and indicators -- Hands-on exercise 5.8 - creating a report and highlighting data with data bars -- Displaying data with sparklines -- Hands-on exercise 5.9 - creating reports with sparklines -- Creating a table -- Creating a report and inserting sparklines -- Indicators -- Hands-on exercise 5.10 - creating reports using indicators -- Reports with map -- Hands-on exercise 5.11 - creating reports with embedded maps -- Report parts -- Hands-on exercise 5.12 - creating report parts and reusing an item -- Saving report as report parts -- Reusing the report parts items -- Summary -- Chapter 6: Power View and Reporting Services -- What is Power View? -- Helpful resources -- What do you need to author a Power View report? -- Creating a tabular model -- Hands-on exercise 6.1 - creating a tabular model -- Brief review of SSDT ribbon -- Creating a connection to the Northwind database -- Getting tables from the database -- Default field set and table behavior -- Adding measures -- Deploying the model -- Hands-on exercise 6.2 - deploying the model -- Tabular model permissions -- Hands-on exercise 6.3 - creating a role in SQL Server Data Tools -- Creating a Power View -- Hands-on exercise 6.4 - connecting to model from SharePoint Server 2010 -- Connecting to the model -- Creating a data source using the model as the source -- Creating a Power View report using the data source -- Hands-on exercise 6.5 - exploring a Power View report -- Creating the first view of the Power View report -- Creating a chart showing sales orders from NW Employees shipped from cities.

Adding a second view to the Power View report.