55236 Writing Reports with Report Builder and SSRS Level 3
CLASS DATE(s):
5/22/2020
7/24/2020

COURSE LENGTH: 1 Day

COURSE COST: $495.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

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.

AUDIENCE AND PREREQUISITES

The primary audience for this course are persons experienced with Report Builder and SSRS. The secondary audience for this course are experienced Report Designer (SSRS) report authors. Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals. 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.

PREREQUISITE COURSESFOLLOW UP COURSES  

*Course Cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run class. Course may run as a virtual instructor led class if theminimum enrollment is not met. For more information, please contact learn@vtec.org or call 207-775-0244.

COURSE TOPICS:


At Course Completion
Use shapes to create enhanced custom report visualizations.
Understand the use of Visual Basic programming in SSRS reports.
Use and support Visual Basic code in the SSRS reporting effort.

Module 1: Creating Enhanced Visualizations, This module introduces report formatting techniques which create enhanced visualizations using shapes, rectangles,images, and data regions.
The Importance of Shapes in Reporting
Enhanced Visualizations Using the Rectangle
Control the Display of Report Items
Creating Tiles in a Tablix
Lab 1: Creating Enhanced Visualizations
Create Tiles in a Report with Rectangles
Create Tiles in a Tablix with Text Boxes
Create Enhanced Visualizations with Text Box Tiles, Tablix Tiles, and Tablixes

Module 2: Visual Basic - This module introduces the Microsoft Visual Basic programming language
The Visual Basic Programming Language
Visual Basic Language Components
Decision Structures and Procedures
Lab 1: Working with Visual Basic
Convert Expressions to Visual Basic Procedures
Work with Value Types in Reports
Work with Reference Types in Reports

Module 3: Using Visual Basic in SSRS Reporting - Report writers can take advantage of the Visual Basic language in three different ways in the Report Builder application.
Visual Basic in SSRS Reports
Calling Visual Basic code from the Report
Using External Visual Basic code in a Report
Lab 1: Using Visual Basic in Reports
Use Conditional Logic with Literals, Fields, and Report Items
Create a Report using Visual Basic
Update a Report to Use External Code
Troubleshoot Visual Basic Errors in a Report