SSRS Adding Code and also custom assemblies to reports

How to add Code to SSRS reports

1. Right click on report > Code > Type code as Visual Basic function
2. In expressions within a data region use Code.<functionname> e.g. =Code.OrdinalFunction(4)

Code for Ordinal Number readily avialable on web. Example use in SRS.ReportingServices.Functions and also in my invoice report

How to add custom assemblies to SSRS reports

1. Create a class library project in Visual Studio VB.Net or C#
2. Use a meaningful assembly name e.g. <initials>.ReportingServices.Functions
3. Add a class and methods to this class. Make the methods shared
4. Compile to create a dll
5. Copy the dll to the equivalent location of:
   C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies
   You may not need the (x86) and you may be on a lower or higher version than 9.0
6. In VS BIDS report right click > report properties > References > Add the reference
7. In expressions in a report use full Namespace.ClassName.FunctionName(variables)

Next deploying the assembly to the report server

1. Copy your DLL to the following location or equivalent:
   C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin

Good luck. Acknowledgments to:

http://www.devx.com/codemag/Article/33656/0/page/3