Microsoft SQL Server Reporting Services (SSRS)

Phillip Burton

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
36 Videos (3h 35m)
    • Introduction

      2:18
    • Objectives

      3:08
    • Different Types of SSRS, including Report Builder's integration with SharePoint.

      11:16
    • Downloading and installing SSRS

      14:20
    • Opening SSRS

      4:03
    • Downloading and Installing AdventureWorks

      10:18
    • Exploring data source

      2:09
    • Creating shared dataset

      9:48
    • Creating a report using Report Wizard

      8:03
    • Recreating our report, not using the Report Wizard

      6:04
    • Properties pane

      8:40
    • Standard Number Formatting

      8:53
    • Custom Number Formatting

      4:44
    • Date Formatting

      10:02
    • Sort and Group

      4:24
    • Visibility and Table Headers

      5:47
    • Creating a Categorised report

      4:16
    • Creating hyperlinks

      2:10
    • Adding a parameter

      8:03
    • Adding a subreport

      2:49
    • Page Headers and Footers

      5:15
    • Adding drop-down list to parameters

      2:30
    • Allow multiple values to select in parameters

      2:23
    • Allowing NULLs in parameters

      4:07
    • Conditional Formatting

      5:54
    • Indicators

      8:04
    • Gauges

      6:54
    • Adding totals

      5:41
    • Interactive Sorting and Document Map

      5:39
    • Creating a pie chart

      4:25
    • Expanding the pie chart

      6:42
    • Creating a bar chart

      11:33
    • Expanding the chart

      2:55
    • Enter the Matrix

      2:34
    • Mapping data

      7:03
    • Recap

      1:36

About This Class

This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful.

We will download a version of SQL Server which includes SSRS - for free. We'll also download a database called AdventureWorks, which we will use in our reports.

We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:

  • Select report components (matrix, table, chart and other data visualisation component),
  • Identify the data source and parameters,
  • Design a grouping structure,
  • Create drilldown reports and drillthrough reports.

As part of implementing a report layout, we will:

  • Find out how to format, including formatting colours, dates and numbers;
  • Configure the page;
  • Implement headers and footers;
  • Implement matrices, tables, chart, images, indicators, maps and groupings in reports;
  • Create a range of reports using different data regions;
  • Define custom fields;
  • Implement global collections;
  • Define expressions; and
  • Implement data visualisation components.

As part of implementing interactivity in a report, we will:

  • Create drilldown reports;
  • Create drillthrough reports;
  • Add interactive sorting;
  • Investigate parameters, including multi-value parameters;
  • Create dynamic reports in SSRS using parameters;
  • Implement show/hide property;
  • Add actions (jump to report and URL);
  • Add Fixed headers and a document map.

By the end of this course, you should be confident in creating your own reports in SSRS.

45

Students

--

Projects

0

Reviews (0)

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part ...

See full profile