Writing Reports with Report Designer and SSRS Level 3

Session Detail:    Classroom 1 Day

In this 1-day course, students will continue their learning on report writing with Microsoft SQL Server Report Designer and SSRS. The focus of this course is enhancing custom report visualizations and the use of Visual Basic programming in SSRS reporting. Supporting Visual Basic programming in reports is a normal requirement in todays reporting landscape and this course presents the information you will need through the course content, group discussions, worksheets, practices, demonstrations, and lab activities. Report Designer is available for all supported versions of Microsoft SQL Server.

Prerequisites

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying, pasting, and formatting text.
  • Saving files.
  • Course 55170: Writing Reports with Report Designer and SSRS Level 2

Who Can Benefit

The primary audience for this course are persons experienced with Report Designer and SSRS. The secondary audience for this course is an experienced Report Builder (SSRS) report, authors. Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals.

Session Outline

Class Outline

Module 1: Creating Enhanced Visualizations

  • Lesson 1: The Importance of Shapes in Reporting
  • Lesson 2: Enhanced Visualizations Using the Rectangle
  • Lesson 3: Control the Display of Report Items
  • Lesson 4: Creating Tiles in a Tablix

After completing this module, students will be able to:

  • Describe the key features, uses, and approaches to using shapes in reporting
  • Have a more thorough understanding of the rectangle tool
  • Manipulate report item properties that have an impact on a report item display
  • Transform data regions by displaying tiles rather than text boxes

Module 2: Visual Basic

  • Lesson 1: The Visual Basic Programming Language
  • Lesson 2: Visual Basic Language Components
  • Lesson 3: Decision Structures and Procedures

After completing this module, students will be able to:

  • Describe the key features of Visual Basic
  • Describe the Visual Basic language elements
  • Recognize Visual Basic statements and their purpose
  • Use decision structure to apply workflow logic
  • Convert business logic into Visual Basic code

Module 3: Using Visual Basic in SSRS Reporting

  • Lesson 1: Visual Basic in SSRS Reports
  • Lesson 2: Calling Visual Basic code from the Report
  • Lesson 3: Using External Visual Basic code in a Report

After completing this module, students will be able to:

  • Describe the key features and uses of Visual Basic in SSRS reporting solutions
  • Recognize the three implementations of Visual Basic code available to a report
  • Create Visual Basic variables, constants, expressions, and procedures
  • Link and consume an external assembly with custom code in a report
  • Troubleshoot Visual Basic errors in a report

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Writing Reports with Report Designer and SSRS Level 3

1 Day
Classroom

$295.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now