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


By:   |   Updated: 2015-04-16   |   Comments (2)   |   Related: > Reporting Services Formatting




 






Enter your business email address to
get free SQL Server tips.

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: http://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



Last Updated: 2015-04-16


get scripts

next tip button



About the author
MSSQLTips author Scott Murray 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 Back To Top (78786)

Amit,

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)

 Hi

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



download





Recommended Reading

SQL Server Reporting Services Report and Group Variable References

SQL Server Reporting Services Controlling Report Page Breaks

Alternate Row Background Color in SQL Server Reporting Services Tablix and Matrix

Display a fixed number of rows per page for an SSRS report

Conditional Formatting for SQL Server Reporting Services Reports














get free sql tips
agree to terms