Microsoft SQL Server Reporting Services (SSRS)

Build reports in MS SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity.

Reviews:

What you’ll learn

  • Create reports in SQL Server Reporting Services (SSRS)..
  • We will develop your skills, bit by bit..
  • You can also download a free version of SQL Server which will allow you to practice creating reports on your own..
  • We will design a report, implementing report layouts and add interactivity into your reports..

Course Content

  • Introduction, and download SSRS –> 6 lectures • 10min.
  • Installing SQL Server and Visual Studio –> 7 lectures • 40min.
  • Preparing to create reports –> 5 lectures • 28min.
  • Creating our first report –> 10 lectures • 35min.
  • Formatting, sorting and grouping, visibility and table headers –> 7 lectures • 40min.
  • More advanced techniques –> 12 lectures • 50min.
  • Conditional Formatting, Indicators, Gauges, Totals, Interactive Sorting, Doc Map –> 7 lectures • 36min.
  • Graphical reports –> 6 lectures • 35min.
  • Object Properties –> 6 lectures • 41min.
  • Functions –> 6 lectures • 41min.
  • Conclusion –> 2 lectures • 5min.

Microsoft SQL Server Reporting Services (SSRS)

Requirements

  • You don’t need any prior knowledge prior to taking this course..
  • A couple of the bonus lectures will require some knowledge of T-SQL, but these lectures are optional..
  • You don’t need any form of SQL Server to already be installed on your computer; I will show you have to download it and install it – for free..
  • It is not necessary to have SharePoint on your computer..
  • If you want to know enough T-SQL to assist you with your SSRS work, please have a look at the first two sessions of my 70-461 courses..

Reviews:

Brilliant! This tutorial will definitely save you hours of figuring out things yourself.” — Koos ten Bras

Excellent course, well presented and clear examples.” – Peter Cawthorne

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.