Microsoft SQL Server Reporting Services (SSRS)

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4 Hours | 562 MB

Genre: eLearning | Language: English

Building reports in SSRS: Designing reports, implementing a report layout, and implementing interactivity in a report

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:

readmore

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.