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 today’s 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.
The primary audience for this course are persons experienced with Report Designer and SSRS. The secondary audience for this course are experienced Report Builder (SSRS) report authors. Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals.
This module introduces report formatting techniques which create enhanced visualizations using shapes, rectangles, images, and data regions. To support customized and enhanced reporting visualizations, this course requires a review of specific properties which support the control of displayed items in a report.
Lab 1: Creating Enhanced Visualizations
This module introduces the Microsoft Visual Basic programming language. The goal of this module is to make the programming language and its use meaningful to non-programmers. This module uses the course handbook, group discussions, worksheets, and reviews to not only introduce Visual Basic programming, but to also understand what the code is doing.
Lab 1: Working with Visual Basic
Report writers can take advantage of the Visual Basic language in three different ways in the Report Designer application. Whether the Visual Basic programming language was incorporated by design or inherited through existing reports, report writers need to be aware of how the features can be applied to achieve the reporting goal. Visual Basic is the required language for Report Designer.
Lab 1: Using Visual Basic in Reports
Curs Updating Your Skills to SQL Server 2016 – Curs 10986
Curs 20762 Developing SQL Databases
Curs 20764 Administering a SQL Database Infrastructure
Curs 20765 Provisioning SQL Databases
Curs 20767 Implementing a SQL Data Warehouse
Curs 20768 Developing SQL Data Models
Curs 55170 Writing Reports with Report Designer and SSRS 2016 Level 2
Curs 55069 PowerShell for SQL Server Administrators