Using Custom .Net Code with Reports

SQL Reporting Services offers the software developer a variety of options when it comes to customizing reports through the use of code. These options give the software developer the ability to write custom functions using .NET code that can interact with report fields, parameters and filters in much the same was as any of the functions that come “built in”. This gives the developer the ability to extend the capabilities of SRS far beyond those that are available out of the box.

This cover the following:

• Using code to customize your report
• Custom code for use within your report using code embedded in the report
• Custom code for use within your report using a custom assembly called by the report

There are two ways to add custom code to your reports, embedded code and code within custom assemblies. This code can then be used in the report through expressions. Generally you will add custom code to your report when you need to perform complex functions and you need the capabilities of a full programming language to accomplish them.

The Following links provide more informations:

• http://www.yukonxml.com/chapters/apress/reportingservices/dotnet/
• http://odetocode.com/Topic.aspx?topic=SQL+Reporting+Services