SQL Server 2012 Reporting Services Blueprints

To get on top of your reporting services in SQL Server 2012, there’s no more direct route than this fantastic set of blueprints. They are the instant solution to a whole range of real-world reporting problems.

SQL Server 2012 Reporting Services Blueprints

Blueprints
Marlon Ribunal, Mickey Stuewe

To get on top of your reporting services in SQL Server 2012, there’s no more direct route than this fantastic set of blueprints. They are the instant solution to a whole range of real-world reporting problems.
$29.99
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 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.

+ Collection
Free Sample

Book Details

ISBN 139781849685085
Paperback246 pages

About This Book

  • Detailed coverage of the various reporting options available
  • Build end-to-end report solutions based on SSRS
  • Learn from realistic situations to offer outstanding solutions

Who This Book Is For

This book is for report developers, data analysts, and database administrators struggling to master the complex world of effective reporting in SQL Server 2012. Knowledge of how data sources and data sets work will greatly help readers to speed through the tutorials.

Table of Contents

Chapter 1: Let's Breakdown the Numbers
Defining a data source for the project
Defining the dataset for the project
Creating the report file
Creating a parameterized report
Creating a radio button parameter
Making a parameter optional
Populating a drop-down parameter with a dataset
Creating a multivalued parameter
Creating a cascading parameter
Creating a cascading multivalued parameter
Sales details report in action!
Summary
Chapter 2: Making a Good Impression
Report page setup
Formatting expression
Adding report objects
Formatting literals in an expression
Creating a row group
Implementing Drilldown with row visibility
Adding subtotals for each group
Adding the grand total
Adding a page header
Adding an image in the header
Adding a page footer
Adding a page number
Alternating row colors
Creating a report template
Using a custom report template
Summary
Chapter 3: Getting Some Actions
Creating the main report
Creating a detail report
Adding a subreport
Creating a drillthrough or linked report
The ALL parameter
Adding a hyperlink (go to URL)
Adding a tool tip
Interactive sorting
Adding a Document Map
Creating a bookmark
Summary
Chapter 4: Everything Looks Better with Charts
Creating a simple chart
Adding data to a chart
Formatting the chart
Adding a tool tip
Embedding data bars in a tablix
Showing a data label
Setting the bar color conditionally
Adding sparklines in the tablix
Aligning axes in the sparkline
Using gauge in a tablix
Configuring the pointer of a gauge
Adding a scale for the gauge
Defining a range of the gauge
Adding an Indicator
Summary
Chapter 5: Location, Location, Locations!
Creating a map (polygon) visualization
Options for spatial and data views
Options for theme and data visualization
Formatting the map
Changing the color rules
Adding center points
Customizing distribution options
Using a shapefile
Removing empty center points
Adding a random point layer
Adding a line layer
Adding a tile layer
Additional Formatting
Summary
Chapter 6: Let's Get Analytical!
Checking the TCP port of Analysis Services
Creating a new inbound rule for Analysis Services
Changing the deployment setting for Analysis Services
Deploying the multidimensional model
Creating the data source for the report
Adding a dataset based on the multidimensional model
Working with the query designer
Building a dataset using the query designer
Using the dataset on the report designer
Adding a filter in the dataset
Adding a parameter in the dataset
Creating a calculated member
Summary
Chapter 7: Sir, We're Ready to Deploy!
Deployment configurations
Development to production migration
User security
Shared schedules
Cached reports
Snapshots
Subscriptions – e-mail delivery / scheduled delivery
Subscriptions – data-driven subscription
Summary
Chapter 8: Beyond the Horizon!
Integrating SSRS with SharePoint
Creating Reporting Service Application
Provisioning subscriptions and alerts
Creating a web application
Creating a site collection
Deploying SSRS projects to SharePoint
Getting introduced to Power View
Understanding PowerPivot
Adding a data source to a model
Creating a Power View report in SharePoint
Summary

What You Will Learn

  • Fully understand the structure and properties of your reports
  • Add interactive elements to your reports
  • Use parameters effectively in different scenarios
  • Utilize a range of advanced graphs
  • Make use of geospatial data and maps
  • Use OLAP Cubes in your reports
  • Deploy your SSRS projects
  • Integrate SharePoint, PowerPivot, and Power View into your reports

In Detail

SQL Server 2012 accounts for a huge share of the database market, and more and more companies are implementing SSRS as part of their BI implementation. Its Reporting Services offers a comprehensive, highly scalable solution that enables real-time decision making.

SQL Server 2012 Reporting Services Blueprints is intended to be just that, a series of Blueprints – things that work straight out of the box and that mirror what a real job requires real report developers to do. You will not be bored with an “Introduction to X” or “What’s under the hood of Y”. We go straight to the practical development of reporting skills, explaining actions as they are taken.

This book is a step-by-step, task-driven tutorial. It provides enterprise reporting blueprints that address your day-to-day issues and requirements. Right from the very start, you’ll learn SSRS beyond the basics, giving you the skills to create the best reports for any task. Explore the possibilities, master your options, and choose the best tool for the job.

Authors

Table of Contents

Chapter 1: Let's Breakdown the Numbers
Defining a data source for the project
Defining the dataset for the project
Creating the report file
Creating a parameterized report
Creating a radio button parameter
Making a parameter optional
Populating a drop-down parameter with a dataset
Creating a multivalued parameter
Creating a cascading parameter
Creating a cascading multivalued parameter
Sales details report in action!
Summary
Chapter 2: Making a Good Impression
Report page setup
Formatting expression
Adding report objects
Formatting literals in an expression
Creating a row group
Implementing Drilldown with row visibility
Adding subtotals for each group
Adding the grand total
Adding a page header
Adding an image in the header
Adding a page footer
Adding a page number
Alternating row colors
Creating a report template
Using a custom report template
Summary
Chapter 3: Getting Some Actions
Creating the main report
Creating a detail report
Adding a subreport
Creating a drillthrough or linked report
The ALL parameter
Adding a hyperlink (go to URL)
Adding a tool tip
Interactive sorting
Adding a Document Map
Creating a bookmark
Summary
Chapter 4: Everything Looks Better with Charts
Creating a simple chart
Adding data to a chart
Formatting the chart
Adding a tool tip
Embedding data bars in a tablix
Showing a data label
Setting the bar color conditionally
Adding sparklines in the tablix
Aligning axes in the sparkline
Using gauge in a tablix
Configuring the pointer of a gauge
Adding a scale for the gauge
Defining a range of the gauge
Adding an Indicator
Summary
Chapter 5: Location, Location, Locations!
Creating a map (polygon) visualization
Options for spatial and data views
Options for theme and data visualization
Formatting the map
Changing the color rules
Adding center points
Customizing distribution options
Using a shapefile
Removing empty center points
Adding a random point layer
Adding a line layer
Adding a tile layer
Additional Formatting
Summary
Chapter 6: Let's Get Analytical!
Checking the TCP port of Analysis Services
Creating a new inbound rule for Analysis Services
Changing the deployment setting for Analysis Services
Deploying the multidimensional model
Creating the data source for the report
Adding a dataset based on the multidimensional model
Working with the query designer
Building a dataset using the query designer
Using the dataset on the report designer
Adding a filter in the dataset
Adding a parameter in the dataset
Creating a calculated member
Summary
Chapter 7: Sir, We're Ready to Deploy!
Deployment configurations
Development to production migration
User security
Shared schedules
Cached reports
Snapshots
Subscriptions – e-mail delivery / scheduled delivery
Subscriptions – data-driven subscription
Summary
Chapter 8: Beyond the Horizon!
Integrating SSRS with SharePoint
Creating Reporting Service Application
Provisioning subscriptions and alerts
Creating a web application
Creating a site collection
Deploying SSRS projects to SharePoint
Getting introduced to Power View
Understanding PowerPivot
Adding a data source to a model
Creating a Power View report in SharePoint
Summary

Book Details

ISBN 139781849685085
Paperback246 pages
Read More