Writing custom code for reporting services

Question

I am interested in writing code for my new projects in the reporting services that I have just been involved with at work. Can anyone tell what language is required and what syntax? Let me know if there is some function reference libraries available for me to look at what I can use?

Answer 1

You can add custom code references embedded in a report or custom assemblies that you build and deploy to the report client and the report server.You can add custom code references embedded in a report or custom assemblies that you build and deploy to the report client and the report server. Use embedded code for custom constants, complex functions or functions which are used multiple times in a single report. Using assemblies of custom code to hold code in one place and to distribute it over multiple reports.

You can either consider to use a report or group variable for time-sensitive calculations which are evaluated once at run-time and which you want to remain the same value throughout report processing.

Custom code can include new individual constants, variables, functions, or subroutines. You can include read-only references to incorporated collections such as the collection of Parameters. However, you can't pass custom functions with sets of report data values; specifically, custom aggregates are not supported.

You can learn ssrs from Intellipaat