Learning SQL server reporting services 2012 [electronic resource] / Jayaram Krishnaswamy.

Includes index.

"Get the most out of SQL Server reporting service 2012, both Native and SharePoint integrated modes."

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.

Installation choices and notesConfiguring 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 ServiceCreating 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 SSDTHands-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 fileMicrosoft 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.

The book is packed with clear instructions and plenty of screenshots, providing all the support and guidance you will need as you begin to generate reports with SQL Server 2012 Reporting Services. This book is for those who are new to SQL Server Reporting Services 2012 and aspiring to create and deploy cutting edge reports. This book is for report developers, report authors, ad-hoc report authors and model developers, and Report Server and SharePoint Server Integrated Report Server administrators. Minimal knowledge of SQL Server is assumed and SharePoint experience would be helpful.

Master record variable field(s) change: 072