Writing Reports with Report Builder 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 Builder 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 today’s reporting landscape and this course presents the information you will need through course content, group discussions, worksheets, practices, demonstrations, and lab activities. Report Builder 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 55128: Writing Reports with Report Builder and SSRS Level 2
  • Microsoft Office Access 2013: Level 1 or have equivalent experience with basic database concepts.

Who Can Benefit

The primary audience for this course are persons experienced with Report Builder and SSRS. The secondary audience for this course is experienced Report Designer (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 which have an impact on a report items 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 Builder 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