The above function which was written in VB, the same function i am using in SSRS 2008 and where there is txtFeesDue.Text (which is a VB text box) there i need to reference Textbox from SSRS.
how it is possible?
How and where you are using this function?
From my experience you are not able to refer a TextBox or other report part in the function.
I suggest you to introduce a parameters to the function instead of trying to implement text box references. So remove the
Then in the call of the function you will pass the Expressions which represents particular TextBox values as parameter to that function.
answered Jun 23, 2011 at 11:09 AM
This is one fine example of how cumbersome sometimes it can be to reference the objects outside of the function's scope. What I mean is that if you have such a function written for one app and then you need to implement the same function for another app then it is easy to notice that the good old friend copy-paste does no longer work :(
If you modify the function to accept 4 string parameters (or 1 parameter of the string array type) then it would be a bit better, so instead of referencing the hardcoded text box names and hoping that these will never change, you can just use the values of the parameters instead:
This way, you can query the Text properties of whatever boxes are available to the calling code and pass them as parameters to this function which is no loger bound to the boxes' names.
answered Jun 23, 2011 at 11:16 AM