0345 4506120

Creating Reports using SSRS Report Designer

This two-day instructor-led course provides delegates with the knowledge and skills to produce reports using Report Designer. The course focuses on teaching individuals how to use the product features and tools related to data retrieval, visualisations and deployment.

Please note - This course covers Report Designer as part of Visual Studio / SQL Server Data Tools - Business Intelligence(SSDT-BI).

There is no exam or certification related to this course.

Target Audience:

This course is intended for end users and IT staff who will produce reports for their organisation, department or group.

Learning Objectives

At the end of this course you will be able to:

  • Publish reports to a report server
  • Create data sources and data sets
  • Work with tablix reports
  • Work with report visualisations
  • Add interactivity to reports

Pre-Requisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality. (Use windows explorer / internet explorer (i.e. things like find web page, create a folder); Login (CTRL ALT DELETE); Use a mouse, start menu etc.)
  • Knowledge of Transact-SQL and MDX queries would be an advantage but not essential.

Course Content

Module 1 : Overview of Report Designer

Module 2 : Adding data sources and data sets

  • Use various data sources and data sets including TSQL and MDX
  • Set source connection and credentials
  • Shared data sources and datasets

Module 3 : Tabular Reports

  • Set page and report settings
  • Review the different tabular report data regions (table, matrix and list)
  • Set textbox properties such as number formatting
  • Set table sorting and interactive sorting
  • Add groups to columns and rows
  • Add a document map
  • Add interactivity with expand and collapse using hide and show

Module 4 : Visualisations

  • Review chart types available
  • Add visualisations to a report: Chart; Gauge; Subreport; Images
  • Add maps
  • New Visualisations: Sparklines; Data bars; Indicators
  • Shared data sets
  • Report parts

Module 5 : Interactivity

  • Add parameters
  • Linked parameters
  • Actions

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include