Writing Reports with Report Builder and SSRS Level 3 Courseware (55236AC)

This one-day course covers enhanced visualizations in report formatting, the basics of the Microsoft Visual Basic programming language, and its application in SQL Server Reporting Services (SSRS) reporting.

In the first module, students learn about the importance of shapes in reporting, enhanced visualizations using the rectangle tool, controlling the display of report items, and creating tiles in a tablix. The course gives students a solid understanding of key features, uses, and approaches to using shapes in reporting. This includes a more thorough understanding of the rectangle tool, manipulating report item properties which impact a report item’s display, and transforming data regions by displaying tiles instead of text boxes.

The second module focuses on the Microsoft Visual Basic programming language. It introduces the key features of Visual Basic, its language elements, and the use of decision structures and procedures. The module is designed to make Visual Basic programming meaningful to non-programmers through a combination of the course handbook, group discussions, worksheets, and reviews. By the end of the module, students will be able to recognize Visual Basic statements and their purpose, use decision structures to apply workflow logic, and convert business logic into Visual Basic code.

The third module looks at using Visual Basic in SSRS reporting. It covers the key features and uses of Visual Basic in SSRS reporting solutions and the three implementations of Visual Basic code available to a report. It includes creating Visual Basic variables, constants, expressions, and procedures, linking and consuming an external assembly with custom code in a report, and troubleshooting Visual Basic errors in a report. By the end of this module, students should be comfortable with the use of Visual Basic in SSRS reporting and will be equipped to solve related challenges efficiently.