SQL Server 2012 Reporting Services Blueprints -- Table of Contents -- SQL Server 2012 Reporting Services Blueprints -- Credits -- About the Authors -- Acknowledgments -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- Step 1 - specify the type of data-driven subscription -- Step 2 - select the location of the shared data source.

Step 3 - set up the SQL statement or stored procedure that will return the data-driven property data. -- Step 4 - set up the delivery properties -- Step 5 - set up the parameter values -- Step 6 - set up the schedule for the subscription -- Summary -- 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 -- A. SSRS Best Practices -- Location of SSRS database installation -- Utilizing the SSRS execution logs -- Report management -- Standardizing queries -- Report standards -- Testing reports -- B. Transactional Replication for Reporting Services -- Options for report delivery -- Transactional replication to the rescue -- Implementing transactional replication -- Setting up the distributor -- Configuring the publication -- Getting the subscription ready -- Summary -- Index.