Microsoft SQL Server 2014: Report Formatting and Interactivity


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
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.

Target Audience
Business intelligence developers who create reporting and analysis solutions and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
2.6

Lesson Objectives

Microsoft SQL Server 2014: Report Formatting and Interactivity

  • 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
  • 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
  • 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
  • format reports, including adding interactivity in Report Designer and Report Builder

    • Course Number:
    md_idmr_a10_it_enus

    Expertise Level
    Expert