mssqltips logo

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




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.





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

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

 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

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools