SQL Server Performance Forum – Threads Archive
Custom Code -please helpOK 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.