Free Sample
+ Collection

Learning SQL Server Reporting Services 2012

Learning
Jayaram Krishnaswamy

For a newcomer to SQL Reporting Services 2012, things can seem a bit daunting, but this book will ease your path to becoming an expert. Clear instructions and screenshots will have you generating reports in no time.
$32.99
$54.99
RRP $32.99
RRP $54.99
eBook
Print + eBook

Want this title & more?

$21.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849689922
Paperback566 pages

About This Book

  • Build applications using the latest Microsoft technologies: SSIS 2012, SSDT, WPF, and SharePoint 2010
  • Reach out to the cloud and master Windows Azure Reporting Services
  • Learn the ins and outs of SQL Server Reporting Services 2012 for Native and SharePoint Integrated modes
  • Step-by-step learning, guided by a large number of screenshots in every chapter makes it a simple

Who This Book Is For

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.

Table of Contents

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
Summary
Chapter 2: SQL Server Reporting Services 2012 Projects with Visual Studio 2012
What is business intelligence?
Introduction to SQL Server Data Tools
Creating reports using SSDT
Report-related projects in Visual Studio 2012
Creating reports using Visual Studio 2012
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
Reporting Services configuration
Salient features of Reporting Services 2012
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)
First step – deploying reports
Report Manager user interface
Report data sources
Viewing, searching, and printing reports
Uploading and downloading files from the Report Server to the filesystem
Report subscription and delivery
Report caching
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
Linked reports
Creating a report with XML data sources
Summary
Chapter 6: Power View and Reporting Services
What is Power View?
What do you need to author a Power View report?
Creating a tabular model
Creating a Power View
Summary
Chapter 7: Self-service Data Alerts in SSRS 2012
Getting ready for Data Alerts
Creating a report and saving to the Report Server
Creating a report in Report Builder and saving it to the Documents library
Giving permission to a report
Creating a Data Alert
Troubleshooting
Summary
Chapter 8: Reporting Services and Programming
Overview of programming interfaces and utilities
URL access
ReportViewer control
Report Server Web Services API
PowerShell
Reporting Services command prompt utilities
Incorporating custom code into reports
Summary
Chapter 9: Windows Azure SQL Reporting
What is Windows Azure SQL Reporting?
Creating content for reports and viewing them
Summary
Chapter 10: Applications Accessing Report Servers
Hands-on exercise 10.1 – accessing the Native mode Report Server using SSIS
Accessing reports from a Windows Presentation Foundations classes project
Accessing Native Report Server reports from SharePoint Web parts
Accessing the Web parts
Summary

What You Will Learn

  • Install SQL Server 2012, SharePoint Server 2010, and configure Reporting Services both native and SharePoint Integrated on Windows 7
  • Install SSDT and author reports, both local and remote, and deploy them to report servers
  • Develop desktop and web applications by using Report Viewer controls
  • Author different kinds of reports with the latest gadgets by working with Report Builder
  • Manage access to the report server, report scheduling, report delivery, report uploads, and downloads with Report Manager
  • Create Tabular Models with SQL Server Analysis Services and deploy them to SSAS Server using SSDT
  • Author Power View Reports from your SharePoint Site and export them as Power Point files
  • Learn to create Data Driven alerts in SharePoint and monitor them on SQL Agent on SSMS
  • Work with SQL Azure Reporting Services using Windows Azure Portal and SSMS
  • Write applications in SSIS and WPF to access reports and access native server reports from SharePoint Site

In Detail

In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012, native and fully integrated with SharePoint Server 2010 including new features like Power View and Data Alerts.

"Learning SQL Server Reporting Services 2012" will get you started right from installation and then move on to configuration of SQL Server Reporting Services 2012. Start learning right from Chapter 1 and build your skill to create reports using the latest tools and deploy them to the latest servers, both Native and SharePoint. No guessing; you will learn all—Power View, Data Alerts, SQL Azure Reporting,the latest Reporting Services Gadgets, and more.

"Learning SQL Server Reporting Services 2012" is a definitive guide to a step-by-step, metered approach to get a jump start on the latest features in SQL Server Reporting Services.Reporting Services in Microsoft SQL Server 2012 is more tightly integrated not only with the Microsoft Business Stack but also with SharePoint, Windows Azure, and the Visual Studio suite of products, with many new features.

You will install and configure the toolset to work with SSRS 2012 integrated with SharePoint 2010. Using SQL Server Data Tools, you will author reports and deploy. You will learn about security to work with Report Manager and Central Administration in SharePoint. Using Report Builder, you will learn about authoring cutting edge reports. You will create Tabular Models and begin experiencing the thrill of creating Power View Reports.

Authors

Read More

Recommended for You

Microsoft SQL Server Analysis Services Demystified [Video]
$ 72.25
What's New in SQL Server 2012
$ 20.99
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
$ 26.99
Microsoft SQL Server 2008 R2 Administration Cookbook
$ 32.99
Creating Reports with SQL Server 2012 Reporting Services [Video]
$ 72.25