SQL Server 2012 Reporting Services Blueprints

Book Description

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.

  • 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.

Table of Contents

  1. SQL Server 2012 Reporting Services Blueprints
    1. Table of Contents
    2. SQL Server 2012 Reporting Services Blueprints
    3. Credits
    4. About the Authors
    5. Acknowledgments
    6. About the Reviewers
    7. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
        3. Instant Updates on New Packt Books
    8. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    9. 1. Let's Breakdown the Numbers
      1. Defining a data source for the project
      2. Defining the dataset for the project
      3. Creating the report file
      4. Creating a parameterized report
      5. Creating a radio button parameter
      6. Making a parameter optional
      7. Populating a drop-down parameter with a dataset
      8. Creating a multivalued parameter
      9. Creating a cascading parameter
      10. Creating a cascading multivalued parameter
      11. Sales details report in action!
      12. Summary
    10. 2. Making a Good Impression
      1. Report page setup
      2. Formatting expression
      3. Adding report objects
      4. Formatting literals in an expression
      5. Creating a row group
      6. Implementing Drilldown with row visibility
      7. Adding subtotals for each group
      8. Adding the grand total
      9. Adding a page header
      10. Adding an image in the header
      11. Adding a page footer
      12. Adding a page number
      13. Alternating row colors
      14. Creating a report template
      15. Using a custom report template
      16. Summary
    11. 3. Getting Some Actions
      1. Creating the main report
      2. Creating a detail report
      3. Adding a subreport
      4. Creating a drillthrough or linked report
      5. The ALL parameter
      6. Adding a hyperlink (go to URL)
      7. Adding a tool tip
      8. Interactive sorting
      9. Adding a Document Map
      10. Creating a bookmark
      11. Summary
    12. 4. Everything Looks Better with Charts
      1. Creating a simple chart
      2. Adding data to a chart
      3. Formatting the chart
      4. Adding a tool tip
      5. Embedding data bars in a tablix
      6. Showing a data label
      7. Setting the bar color conditionally
      8. Adding sparklines in the tablix
      9. Aligning axes in the sparkline
      10. Using gauge in a tablix
      11. Configuring the pointer of a gauge
      12. Adding a scale for the gauge
      13. Defining a range of the gauge
      14. Adding an Indicator
      15. Summary
    13. 5. Location, Location, Locations!
      1. Creating a map (polygon) visualization
      2. Options for spatial and data views
      3. Options for theme and data visualization
      4. Formatting the map
      5. Changing the color rules
      6. Adding center points
      7. Customizing distribution options
      8. Using a shapefile
      9. Removing empty center points
      10. Adding a random point layer
      11. Adding a line layer
      12. Adding a tile layer
      13. Additional Formatting
      14. Summary
    14. 6. Let's Get Analytical!
      1. Checking the TCP port of Analysis Services
      2. Creating a new inbound rule for Analysis Services
      3. Changing the deployment setting for Analysis Services
      4. Deploying the multidimensional model
      5. Creating the data source for the report
      6. Adding a dataset based on the multidimensional model
      7. Working with the query designer
      8. Building a dataset using the query designer
      9. Using the dataset on the report designer
      10. Adding a filter in the dataset
      11. Adding a parameter in the dataset
      12. Creating a calculated member
      13. Summary
    15. 7. Sir, We're Ready to Deploy!
      1. Deployment configurations
      2. Development to production migration
      3. User security
      4. Shared schedules
      5. Cached reports
      6. Snapshots
      7. Subscriptions – e-mail delivery / scheduled delivery
      8. Subscriptions – data-driven subscription
        1. Step 1 – specify the type of data-driven subscription
        2. Step 2 – select the location of the shared data source
        3. Step 3 – set up the SQL statement or stored procedure that will return the data-driven property data.
        4. Step 4 – set up the delivery properties
        5. Step 5 – set up the parameter values
        6. Step 6 – set up the schedule for the subscription
      9. Summary
    16. 8. Beyond the Horizon!
      1. Integrating SSRS with SharePoint
      2. Creating Reporting Service Application
      3. Provisioning subscriptions and alerts
      4. Creating a web application
      5. Creating a site collection
      6. Deploying SSRS projects to SharePoint
      7. Getting introduced to Power View
      8. Understanding PowerPivot
      9. Adding a data source to a model
      10. Creating a Power View report in SharePoint
      11. Summary
    17. A. SSRS Best Practices
      1. Location of SSRS database installation
      2. Utilizing the SSRS execution logs
      3. Report management
      4. Standardizing queries
      5. Report standards
      6. Testing reports
    18. B. Transactional Replication for Reporting Services
      1. Options for report delivery
      2. Transactional replication to the rescue
      3. Implementing transactional replication
      4. Setting up the distributor
      5. Configuring the publication
      6. Getting the subscription ready
      7. Summary
    19. Index

Product Information

  • Title: SQL Server 2012 Reporting Services Blueprints
  • Author(s): Marlon Ribunal, Mickey Stuewe
  • Release date: October 2013
  • Publisher(s): Packt Publishing
  • ISBN: 9781849685085