SQL Server Reporting Services Video Embedding .NET Code for Report Formatting and Error Handling

By: Scott Murray | Comments (2) | Related: > Reporting Services Formatting

Problem / Solution

SSRS allows us to add embedded customized code to a report in order to perform functions that may not be available or easily implemented in SSRS. The code which is embedded must be Visual Basic and allows for code reuse which in turn may simplify report updates. Furthermore the code function can accept and return various variables / strings, however when passing a parameter collection it is read only.

Be sure to read my full MSSQLTips.com tip on Embedding Code in SSRS Reports at: https://www.mssqltips.com/sqlservertip/3199/sql-server-reporting-services-embedding-net-code-for-report-formatting-and-error-handling/

Key Learning Items

The video covers how to:

Using Code Reference in SSRS for Formatting
Using Code Reference in SSRS for Divide By Zero

Read Companion Tips

Click Here

About the author

Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

View all my tips

Comments For This Article

Wednesday, January 16, 2019 - 9:58:30 AM - Scott Murray

Amit,

sorry.. you will need to check other sources on executing SSRS reports via VB..

Wednesday, January 16, 2019 - 2:57:27 AM - Amit

Need help on as to how to print a single time a report and then the report closes automatically. For example, while buying a certificate/ticket, you pay to enable printing of that ticket. To print again, need to pay again. How is that feasible with SSRS using VB code?

Two, need to print pantograph using VB code in SSRS reports. Please help.

Thanks in advance

regards