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.

6

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 of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.