Overview

Introduction

The Design a Report module provides you with the instruction and Server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  • Create Report Server Project
  • Add Report
  • Specify data source
  • Specify report parameter
  • Change report behaviour
  • Design a template
  • Use built-in features
  • Set template
  • Edit report in text editor
  • Add a table
  • Implement a matrix
  • Implementing a List
  • Implementing a Chart
  • Create a grouping structure
  • Use an expression
  • Create a drilldown report
  • Create a detailed report
  • Create drill through report

Exercise 1 - Create a Report

Reports are a presentation of data stored in databases, such as MYSQL database. Reports are XML files created using the Report Definition Language (RDL), and supporting the .rdl extension. Reports are a concise and efficient way of presenting input data or accessing output results relevant to various processes. You can edit reports directly by opening a report file in a text editor.

Reports use connection parameters to locate the data source. Moreover, reports support various parameters that can filter report data or define the report-objects behaviour. In this exercise, you will add a data source and then specify a parameter to modify the behaviour of the report objects.

Exercise 2 - Design Report Templates

Report templates are used when you need to create multiple number of reports with the same style, formatting, and even text. Such reports normally have same headers-footers, and some default text. In addition, reports created from templates allow you to include customised text in the reports. For example, consider a scenario where an organization is sending out regular reports to multiple clients. These reports display similar header and footer, and a common body text. However, a section of this report displays calculations customised as per the requirements of each client. Templates can help create these multiple reports efficiently.

Exercise 3 - Customize a Report

After creating a report, you can customise it. Customising the report might include editing the report, changing any of the defined elements, adding new data sources, and modifying the output. In this exercise, you will learn to customise a report.

Exercise 4 - Select Report Components

Reporting Services provides many powerful components to help you visualize data in an effective and manageable way. Examples of these components include tables, matrices, and lists. Collectively known as Tablix, these components present data in the form of cells. These cells are further arranged into rows or columns, based on the relationship among the cells. The cells can contain unformatted text, formatted text such as date, or even pictorial representation of data such as graphs. In this exercise, you will learn to add a table, a matrix, and a list into a report. You will also create chart in the report.

Exercise 5 - Design a Grouping Structure

Grouping structures help logically separate data. Grouping structures offer sophisticated data operations, such as specific types of sorting, page breaks settings, totals and subtotals hierarchy. You can use grouping structures on various report-components, such as Tablix - Table, List, Matrix, and even Charts.

In this exercise, you will add a grouping structure to the table to display the number of employees in each state of each country. To achieve this, group the data by state and then by county. Then, you add subtotal and total.

Exercise 6 - Use Expressions for Sophisticated Operations

Almost each report has some calculations that use the data in the database but are performed on more complex data structures.. SSRS implement expressions to perform such operations. Expressions are strings of code that specify the logic for various operations. By managing the code, you can use expressions to implement simple, complex, or even highly sophisticated operations.

In this exercise, you will create simple expression operating on a complex data field. This complex data field is itself derived from the simple data fields existing in the database.

Exercise 7 - Drilldown Reports

Drilldown action is used to hide unnecessary data in the grouping hierarchy of the tablix elements included in a report. Users can expand or collapse sections of these elements to show or hide the data. This feature used to make reports more concise to glance at while offering all the relevant details.

In this exercise, you will create a drilldown section to hide the details of the table.

Exercise 8 - Drillthrough Reports

A drillthrough report is a report that a user opens by clicking a link within another report. Drillthrough reports commonly contain details about an item that is contained in an original summary report.

In this exercise, you will create a drilldown report for the Report.rdl created in the earlier exercises.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.