Microsoft SQL Server 2014: Report Formatting and Interactivity

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

Prerequisite
None

Expected Duration
154 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.