SQL Server 2012 Reporting Services Blueprints

Use real-world situations to develop real-world solutions

Overview

• 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

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.

What you will learn from this book

• 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

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 written 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
Chapter 2: Making a Good Impression
Chapter 3: Getting Some Actions
Chapter 4: Everything Looks Better with Charts
Chapter 5: Location, Location, Locations!
Chapter 6: Let’s Get Analytical!
Chapter 7: Sir, We’re Ready to Deploy!
Chapter 8: Beyond the Horizon!
Appendix A: SSRS Best Practices
Appendix B: Transactional Replication for Reporting Services