Custom Code -please help | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Custom Code -please help

OK so I paste a VB.Net function in "report properties" > "code". As I understand it I can then reuse it as an "expression". My question is, I click on expression, but what "field" is my custom code under? In other words how do I access and use my code? thank you

The code is not in any field. It is within the rdl file itself. The VB code may contain one or more public (usable in report functions) or private (used by other functions/sub routines with in code block). You can invoke your user function using =Code.function name. The code cannot access any field values from the report itself. You must pass all the fields are parameters. You will not find your functions in any list. You manually enter the function name in the right-side panel.
Bhaskar Babu
]]>