Book description
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.
- 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
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.
Table of contents
-
Learning SQL Server Reporting Services 2012
- Table of Contents
- Learning SQL Server Reporting Services 2012
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
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
- Configuring the hardware used for the book
- Hands-on exercise 1.1 – installing SQL Server 2012
- Hands-on exercise 1.2 – verifying the installation
- Configuring SQL Server Reporting Services
- Hands-on exercise 1.3 – configuring SQL Server 2012 Reporting Services in Native mode
- Installing sample databases
- SharePoint Server 2010 Enterprise Edition
- Installing Reporting Services 2012 in SharePoint Integrated mode
- Hands-on exercise 1.4 – installing the Reporting Services SharePoint Service
- Summary
-
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
- 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-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
-
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
- Report definition
- Creating reports
- Report parts and their reusability
- Customizing reports
- Saving and deploying reports
- Report validation
- Viewing reports
- Managing reports
- Features new in RS2012 SharePoint Integrated
- Implementing security – authentication and authorization
- URL access
- Reporting Services extensions
- Reporting Services tools
- Tools for Report Server administration
- Tools for report authoring
- Tools for report content management
- Summary
-
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
- Customizing Report Manager
- Hands-on exercise 4.1 – creating, modifying, moving, and deleting folders
- Configuring permissions from Report Manager
- Configuring role-based security
- Hands-on exercise 4.2 – assigning a Windows user to the System Administrator role
- Assigning users to item-level roles
- Review users on a Reporting Services database
- Hands-on exercise 4.3 – assigning a user to a Custom role
- Hands-on exercise 4.4 – creating a permission to a specific report
- 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
-
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
- Parameterized reports
- Subreports
- Hands-on exercise 5.3 – creating a report that has a subreport
- Report with groups
- Hands-on exercise 5.4 – setting up a group and creating a document map
- Drill-through and drill-down reports
- Drill-through reports
- Hands-on exercise 5.5 – Creating a drill-through report
- Drill-down report
- Hands-on exercise 5.6 – Creating a drill-down report
- Linked reports
-
Creating a report with XML data sources
- Creating 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
- Indicators
- Hands-on exercise 5.10 – creating reports using indicators
- Reports with maps
- Hands-on exercise 5.11 – creating reports with embedded maps
- Report parts
- Hands-on exercise 5.12 – creating report parts and reusing an item
- Summary
-
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
- Hands-on exercise 6.4 – connecting to the 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
- Highlighting of data
- Displaying data as a card
- Using tiles
- Slicing the data
- Advanced filtering
- Scatter and bubble charts
- Animation with Power View
- Navigating through the views of the Power View report
- Save, do, undo, and refresh
- Saving to PowerPoint
- Summary
- 7. Self-service Data Alerts in SSRS 2012
-
8. Reporting Services and Programming
- Overview of programming interfaces and utilities
- URL access
- ReportViewer control
- Report Server Web Services API
-
PowerShell
- Hands-on exercise 8.6 – a quick review of basics
- PowerShell and reporting services with SharePoint Integration
- Hands-on exercise 8.7 – exploring reporting services in SharePoint Integrated mode
- PowerShell and Native mode Reporting Services 2010
- Hands-on exercise 8.8 – exploring Native mode Reporting Services
- Windows Management Instrumentation
- Hands-on exercise 8.9 – exploring the Native mode Report Server programmatically
- Report Server properties using WMI
- Reporting Services command prompt utilities
- Incorporating custom code into reports
- Summary
-
9. Windows Azure SQL Reporting
- What is Windows Azure SQL Reporting?
-
Creating content for reports and viewing them
- Preparing to author reports
-
Hands-on exercise 9.2 – creating a report using SSDT and deploying it to the Windows Azure Reporting on the Cloud
- Creating a SQL database on Windows Azure
- Creating a table for the report
- Populating the table in SSMS
- Creating a SQL Reporting Service in Windows Azure
- Creating a report based on the Skyblue database on the Windows Azure Platform
- Deploying the report to the SQL Reporting Services on Windows Azure
- Viewing the report on the SQL Reporting Web server
- Hands-on exercise 9.3 – using the Windows Azure SQL Reporting Services to create folders, share data sources, and upload reports
- Managing your reports and users is easy
- Managing users
- Managing reports
- Managing the report Dashboard
- Status of activities
- Managing permissions
- Report viewing
- Using Report Builder to view reports
- URL access to reports on the Report Server
- Hands-on exercise 9.4 – migrating a table on an on-premise SQL Server 2012 to the Windows Azure SQL database
- Summary
- 10. Applications Accessing Report Servers
- Index
Product information
- Title: Learning SQL Server Reporting Services 2012
- Author(s):
- Release date: June 2013
- Publisher(s): Packt Publishing
- ISBN: 9781849689922
You might also like
book
Head First Design Patterns, 2nd Edition
You know you don’t want to reinvent the wheel, so you look to design patterns—the lessons …
book
Learning SQL, 3rd Edition
As data floods into your company, you need to put it to work right away—and SQL …
book
Microsoft SQL Server 2012 Security Cookbook
Over 70 practical, focused recipes to bullet-proof your SQL Server database and protect it from hackers …
book
Professional Azure SQL Database Administration - Second Edition
Leverage the features of Azure SQL database and become an expert in data management Key Features …