Microsoft SQL Server Reporting Services (SSRS)

79

LESSONS

ALL

SKILL LEVEL

6:07 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

OVERVIEW

This course is all about creating reports in SQL Server Reporting Services (SSRS). It will help you to select report components, identify the data source and parameters, format, create reports, sort, and add actions.

We will show you how to download a free version of SQL Server which includes SSRS, as well as a sample database for use in the course.

On completion, you will be confident in creating your own reports in SSRS.

.

WHO IS THE COURSE FOR?

This course is for anybody who would like to create reports in SSRS.

No prior knowledge is required. However, some knowledge of T-SQL is an advantage.

.

LEARNING PATH

DESIGNING A REPORT

  • Install SQL Server.
  • Create and drop tables.
  • Data types and data functions.
  • Select report components (matrix, table, chart and other visualisation components).
  • Identify the data source and parameters.
  • Design a grouping structure.

REPORT LAYOUT

  • Formatting, including colours, dates and numbers.
  • Configure the page.
  • Implement headers and footers.
  • Implement matrices, tables, charts, images, indicators, maps, and groupings in reports.
  • Create a range of reports using different data regions.
  • Define custom fields.
  • Implement global collections.
  • Define expressions.
  • Implement data visualisation components.

REPORT INTERACTIVITY

  • Create drilldown reports and drill-through 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 add URL).
  • Add fixed headers and a document map.

.

REVIEWS

“Phillip does a great job on explaining the basics of SSRS. I come from an Oracle database background and his class has enabled me to be productive immediately.” Patrick

“Excellent course, well presented and clear examples.” Peter

“Course content was very useful and relevant.” Arthar

.

READY TO START?