Reporting Services and Programming - Learning SQL Server Reporting Services 2012 - page 450

Incorporating custom code into reports
Providing custom code support empowers reports to work with the following
• Custom constants
• Complex functions
• Functions that are used in more than one place of the report
Custom code can be new constants, variables, functions, and subroutines.
Report Designer (SSDT) is preferred for coding custom code and Report Builder
through valid expressions, or including references to custom assemblies on the
Report Server is chosen to include/embed code. Custom code assemblies support
keeping code in one place and sharing with multiple reports.
Using expressions is one way of incorporating aggregate functions. You can also
use the custom code to incorporate into reports. Here, you will learn to incorporate
custom code.
Hands-on 8.11 - inserting custom code into a
report
You will create a report by using the Northwind database on your SQL Server 2012
instance using Report Builder. The design and ields inserted into the report design
are as follows:
The last two columns are the total sales amount, one in US Dollars and the other
in Euros. The irst one is calculated by creating an expression using the expression
builder, as follows: