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

By:   |   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

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

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

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Wednesday, January 16, 2019 - 9:58:30 AM - Scott Murray Back To Top (78786)


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

Wednesday, January 16, 2019 - 2:57:27 AM - Amit Back To Top (78781)


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


get free sql tips
agree to terms