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

4. In the last column in the cell under Amount (€) , bring up the expression

builder and write the code, as shown, using the fields in the bottom panel:

5. Click on OK and run the report.

The last column should display the amount in Euros.

To learn more about writing custom code, follow
http://msdn.microsoft.com/en-us/library/ms156028.aspx .

Summary
A number of programs to manage and probe reporting services in both native and
SharePoint Integrated modes were described. URL access, displaying reports in
ASP.NET page, using Reporting Server Web Services in both native and SharePoint
Integrated implementations, PowerShell scripting to manage SharePoint and WMI
namespaces, programmatic access to Reporting services WMI objects, the Reporting
Services utility programs, and incorporating custom code into reports are all
described with a number of hands-on exercises.

In the next chapter, we will deviate somewhat to describe the Windows Azure SQL
Reporting Services-SQL Server Reporting Services hosted on the Windows Azure
Platform. We will describe, starting from scratch, how to create reports by using
the SQL Azure Database Service to create reports and host them in the Cloud.