PacktLib: SQL Server 2012 Reporting Services Blueprints

SQL Server 2012 Reporting Services Blueprints

Credits

About the Authors

Acknowledgments

About the Reviewers

www.PacktPub.com

Preface

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

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

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

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

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

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

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

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

SSRS Best Practices

SSRS Best Practices

SSRS Best Practices

SSRS Best Practices

SSRS Best Practices

SSRS Best Practices

SSRS Best Practices

Transactional Replication for Reporting Services

Transactional Replication for Reporting Services

Transactional Replication for Reporting Services

Transactional Replication for Reporting Services

Transactional Replication for Reporting Services

Transactional Replication for Reporting Services

Transactional Replication for Reporting Services

Transactional Replication for Reporting Services

Index