Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

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


By:   |   Last Updated: 2015-04-16   |   Comments (2)   |   Related Tips: > 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


Learn more about SQL Server tools