Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

MS SQL Server 2019 - Creating Reports with Report Builder

( Duration: 3 Days )

The SQL Server 2019 - Creating Reports with Report Builder training course is designed for business analysts and other power users who are already comfortable with Ribbon-based applications such as Microsoft Word and Microsoft Excel. This course provides skills to use the Report Builder tool to create, format, and customize SQL Server Reporting Services (SSRS) reports. You will learn to take full advantage of the user-based Business Intelligence features of SSRS.

By attending SQL Server 2019 - Creating Reports with Report Builder workshop, delegates will learn to:

  • Understand and use data sources and datasets
  • Create and format reports
  • Add images and document maps to reports
  • Work with groups to summarize data
  • Use parameters to add flexibility to reports
  • Create enhanced visual reports with charts, indicators, and maps
  • Incorporate custom expressions into reports

  • A general knowledge of database concepts including tables and fields is required.
  • Comfortable working in Microsoft Office.
  • Prior Excel experience would be helpful.

COURSE AGENDA

1

SSRS Overview

  • Reporting Services Features
  • Tools Available with SQL Server
  • Authoring with Report Builder
  • ClickOnce vs. Stand-alone (Optional)
  • The Getting Started Dialog Box
2

Data Sources and Datasets

  • What is a Data Source?
  • Shared verses Embedded Data Sources
  • What is a Dataset?
  • Creating Datasets
3

Creating New Reports

  • Using the Report Wizards
  • Starting from the Blank Report Template
  • What is Tablix?
  • Creating a Tabular Report
  • Creating a List Report
  • What is a Matrix?
4

Formatting Reports

  • Working with Text Boxes
  • Rich Text Formatting
  • Managing Text Boxes
  • Drawing Lines and Boxes
  • Images
  • Page Headers and Footers
  • Adding a document map
  • Rendering Reports
5

Summarizing and Sorting

  • Creating Groups
  • Adding Totals and Aggregations
  • Parent/Child vs. Adjacent Groupings
  • Tablix Properties and Grouping Data
6

Add Flexibility with Parameters

  • Adding Parameters to a Report
  • Report Parameters vs. Query Parameters
  • Working with Cascading Parameters
  • Manage Report Parameter Properties
  • Use Parameters with SQL Queries and Stored Procedures
  • Sort Based on a Parameter Setting
  • Filtered Reports
7

Enhanced Report Items

  • Charts
  • Gauges
  • Add a Map to a Report
  • Data Bar, Indicator, and Sparkline Report Items
  • Nesting Data Regions
  • Subreports and Drillthrough Reports
  • Working with Drillthrough Reports
8

Custom Expressions

  • Understanding Expressions
  • Defining Expressions
  • Working with Report Variables
  • Understanding Lookup, LookupSet, and Multilookup Functions
  • Expression Samples

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X