Creating Reports with SQL Server 2012 Reporting Services

Creating Reports with SQL Server 2012 Reporting Services

by
Released November 2013
Publisher(s): Packt Publishing
ISBN: 9781782177180

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to live online training experiences, plus books, videos, and digital content from O’Reilly and nearly 200 trusted publishing partners.

Start your free trial

Video description

Creating Reports with SQL Server 2012 Reporting Services [Video]

About This Video

  • Create reports with tables, matrices, pie charts, gauges, and other attention-grabbing visualizations

  • Add flexibility to your reports by implementing various parameters

  • Step-by-step instructions and practical examples for shorter report development times and to help you format reports to createa professional appearance

    • In Detail

    A key component of delivering business intelligence, SQL Server 2012 Reporting Services allows for the effective communication of critical information. SSRS enables users to quickly and easily generate reports from Microsoft SQL Server databases. This provides you with an extensive range of tools to create, manage, and customize reports for your organization.

    Creating Reports with SQL Server 2012 Reporting Services will show you how to develop practical reports that utilize tables and matrices, along with bold objects such as pie charts and gauges that quickly gain the attention of the viewer and deliver your message. With this course, you can acquire the essential skills you need to make an impression on your customers, your audience, or your boss.

    Starting with the queries needed to populate areport, you will learn how to build, layout, and format informative multifunctional reports.You will be able to deliver your organization's message clearly through high-impact visual objects. The viewers of your reports will be able to interact with the information by filtering, sorting, drilling down, or drilling through to find what is important to them.

    Creating Reports with SQL Server 2012 Reporting Services will give you all the knowledge you need to create reports that will impress your stakeholders.

    Publisher resources

    Download Example Code

    Table of contents

    1. Chapter 1 : The Report Wizard
      1. Data Sources
      2. Report Queries
      3. Tabular Report Types and Their Configuration
      4. Matrix Report Types and Their Configuration
      5. Deployment Location and Completing the Wizard
    2. Chapter 2 : Creating a Tabular Report
      1. Formatting Column Headers
      2. Interactive Sorting
      3. Adding Calculated Fields and Using Expressions
      4. Formatting Cells
      5. Viewing the Report on the Report Server
      6. Formatting the Report for Printing
    3. Chapter 3 : Formatting of Report Headers and Footers
      1. Adding the Header and Footer
      2. Using the Built-in Fields
      3. Adding Query-Defined Fields
      4. Adding Images to the Header
      5. The Importance of Displaying Report Metadata on the Report
    4. Chpater 4 : Creating a Drilldown Report
      1. Queries Specialized for Drilldown Report
      2. Creating the Drilldown Report
      3. Grouping in SSRS
      4. Toggling the Display
      5. Adding Summary Rows
    5. Chapter 5 : Using Parameters in a Report
      1. Parameter Types
      2. Available and Default Values
      3. Filtering by the Parameter Value
      4. Displaying Parameter Values within the Report
    6. Chapter 6 : Creating a Drillthrough Report
      1. Creating a Child Report
      2. Adding a Parameter to a Query
      3. Configuring the Drillthrough Reporting Action
      4. Deploying the Drillthrough Reports to the Report Server
    7. Chapter 7 : Creating Pie and Bar Charts
      1. Queries Optimized for Pie Charts and Bar Charts
      2. Creating the Pie Chart Report
      3. Creating the Bar Chart Report
      4. Formatting the Legends and Labels
      5. Placing two Subreports onto One Report
    8. Chapter 8 : Utilizing Gauges, Sparklines, and Indicators
      1. Queries Optimized for Gauges, Sparklines, and Indicators
      2. Creating a Report Containing a Gauge
      3. Creating a Report Containing a Sparkline
      4. Creating a Report Containing an Indicator
      5. Creating a Dashboard

    Product information

    • Title: Creating Reports with SQL Server 2012 Reporting Services
    • Author(s):
    • Release date: November 2013
    • Publisher(s): Packt Publishing
    • ISBN: 9781782177180