55236 Writing Reports with Report Builder and SSRS Level 3
9:00am - 4:30pm
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.
PREREQUISITE COURSESFOLLOW UP COURSES
Creating and navigating folders.
Copying, pasting, and formatting text.
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.
*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 firstname.lastname@example.org or call 207-775-0244.
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 TablixesModule 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 ReportsModule 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