SQL Server 2012 reporting services blueprints

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. Approach Follow the fictional John Kirkland through a series of real-world reporting challenges based on actual business conditions. Use his detailed blueprints to develop your own reports for every requirement. 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.

Includes index.

Cover -- Copyright -- Credits -- About the Authors -- Acknowledgments -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- 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 parameterSales 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 templateSummary -- Chapter 3: Getting Some Actions -- Creating the main report -- Creating a detail report -- Adding a subrepor…