SQL Server provides two tools SQL Server Data Tools Report Designer and Report Builder to create robust reports in Reporting Services. Using either of these tools, developers or administrators can create different types of reports and format them accordingly using different options. This course will demonstrate how to create different types of reports, including tablix and matrix. It will also demonstrate how to add different options to the reports, including images, charts, column and heading formatting, and how to add interactivity. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.
Learning Objectives
Report Formatting in Report Designer
- start the course
- create a basic table report
- create a basic matrix report
- format fields and column headers in a table and matrix report
- add images, maps, charts, and indicators to a report
- add lists, text boxes, and other visuals to a report, including headers and footers
- group data in a report and add line totals and grand totals
- implement group variables and report variables to a report
- define expressions to retrieve, calculate, display, sort, filter, and parameterize data
- use the Report Wizard to create a new report
Implement Interactivity in Reports
- add interactive sorting to a report
- implement filtering and parameter lists to control report data
- add a drillthrough action to a report
- add a DrillDown action to a report
- use the Show/Hide property for a report region, including creating an expression
- add a bookmark link and hyperlinks to a report
- add a document map to a report
- create a dynamic report using parameters
Format Reports in the Report Builder
- create a new report in the Report Builder by selecting the appropriate report layout and adding data sources and datasets
- filter, group, and sort data for a report in the Report Builder
- add images, maps, charts, and indicators to a report in the Report Builder
- add interactive features to a report in the Report Builder
- modify an existing report that was created in SQL Server Data Tools Report Designer
Practice: Interactive Reports for SSDT
- format reports, including adding interactivity in Report Designer and Report Builder