Microsoft SQL Server 2014: Report Formatting and Interactivity

This course is included in our On-demand training solution.

Overview

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

150 min.

Course Objectives

Course Introduction

Creating a Tablix Report

  • create a basic table report
  • Creating a Matrix Report

  • create a basic matrix report
  • Formatting Fields and Column Headers

  • format fields and column headers in a table and matrix report
  • Adding Images, Maps, Charts, and Indicators

  • add images, maps, charts, and indicators to a report
  • Adding Lists, Text Boxes, and Other Visuals

  • add lists, text boxes, and other visuals to a report, including headers and footers
  • Grouping Data and Adding Line Totals and Grand Totals

  • group data in a report and add line totals and grand totals
  • Implementing Group and Report Variables

  • implement group variables and report variables to a report
  • Defining Expressions

  • define expressions to retrieve, calculate, display, sort, filter, and parameterize data
  • Using the Report Wizard to Create a Report

  • use the Report Wizard to create a new report
  • Adding Interactive Sorting to a Report

  • add interactive sorting to a report
  • Implementing Filtering and Parameter Lists

  • implement filtering and parameter lists to control report data
  • Adding a Drillthrough Action to a Report

  • add a drillthrough action to a report
  • Adding a DrillDown Action to a Report

  • add a DrillDown action to a report
  • Implementing the Show/Hide Property

  • use the Show/Hide property for a report region, including creating an expression
  • Adding Bookmark Links, Hyperlinks, and Embedding HTML

  • add a bookmark link and hyperlinks to a report
  • Adding a Document Map to a Report

  • add a document map to a report
  • Creating a Dynamic Report Using Parameters

  • create a dynamic report using parameters
  • Creating a Report in the Report Builder

  • create a new report in the Report Builder by selecting the appropriate report layout and adding data sources and datasets
  • Filtering, Grouping, and Sorting Data in Report Builder

  • filter, group, and sort data for a report in the Report Builder
  • Adding Images, Charts, Gauges, and Indicators

  • add images, maps, charts, and indicators to a report in the Report Builder
  • Adding Interactive Features in the Report Builder

  • add interactive features to a report in the Report Builder
  • Modifying an Existing Report in the Report Builder

  • modify an existing report that was created in SQL Server Data Tools Report Designer
  • Exercise: Formatting Reports in SSDT and Report Builder

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?