Present SQL data with Reporting Services - SQL Server Tutorial

Contents

• Introduction Introduction

  • Present SQL data with Reporting Services

    32s
  • (Locked)
    What you should know

    44s
• 1. Get Started with SSRS 1. Get Started with SSRS

  • What is SQL Server Reporting Services (SSRS)?

    2m 48s
  • (Locked)
    Installing SSRS

    2m 34s
  • (Locked)
    Install a SQL Server instance for the report server

    2m 30s
  • (Locked)
    Configure the report server

    7m 7s
  • (Locked)
    Set up the example database

    2m 7s
  • Access the web portal

    5m 3s
  • (Locked)
    Install Report Builder

    2m 28s
• 2. Build Your First Report 2. Build Your First Report

  • Components of a report

    2m 31s
  • (Locked)
    Create a report data source

    7m 41s
  • (Locked)
    Create a dataset

    6m 13s
  • Add a data table with the wizard

    5m 42s
  • (Locked)
    Joining data tables

    5m 56s
  • (Locked)
    Format a report

    6m 50s
  • (Locked)
    Reviewing report properties

    5m 33s
  • (Locked)
    View, print, and export a report

    2m 24s
• 3. Work with Data 3. Work with Data

  • Create a shared data source

    5m 38s
  • (Locked)
    Create a shared dataset

    3m 44s
  • (Locked)
    Filtering data

    6m 24s
  • (Locked)
    Grouping data in a report

    3m 52s
  • (Locked)
    Understand matrixes

    5m 18s
  • (Locked)
    Use aggregate functions

    8m 5s
• 4. Build Interactive Reports 4. Build Interactive Reports

  • (Locked)
    Convert filters into parameters

    5m 38s
  • (Locked)
    Report parameter properties

    7m 15s
  • (Locked)
    Make a dynamic report title

    1m 52s
  • (Locked)
    Add a parameter manually

    4m 47s
  • (Locked)
    Report actions

    5m 21s
  • (Locked)
    Sort records in a table

    6m 49s
• 5. Create Charts 5. Create Charts

  • (Locked)
    Introduction to charts

    2m 57s
  • (Locked)
    Create a chart

    3m 56s
  • (Locked)
    Add additional data series

    5m 33s
  • (Locked)
    Format charts

    7m 15s
• 6. Additional Data Visualizations 6. Additional Data Visualizations

  • (Locked)
    Gauges

    6m 49s
  • (Locked)
    Indicators

    4m 16s
  • (Locked)
    Data bars

    3m 23s
  • (Locked)
    Create a sparkline dataset

    5m 49s
  • (Locked)
    Display a sparkline

    3m 12s
  • (Locked)
    Maps

    6m 1s
• 7. Improve the Presentation 7. Improve the Presentation

  • Include header and footer details

    7m 12s
  • (Locked)
    Add graphics and logos

    2m 26s
  • (Locked)
    Align page elements

    1m 44s
  • (Locked)
    Insert page breaks

    5m 1s
• 8. Build a Web Portal Dashboard 8. Build a Web Portal Dashboard

  • (Locked)
    Add a key performance indicator (KPI)

    3m 58s
  • (Locked)
    Create a dynamic KPI

    3m 59s
  • (Locked)
    Organize the web portal with folders

    2m 25s
  • (Locked)
    Customize the web portal branding

    4m 13s
  • (Locked)
    Create an SSRS user account

    3m 7s
  • (Locked)
    Subscribe to a report

    3m 1s
  • (Locked)
    Save report snapshots with historical data

    1m 47s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 23s