Monday, February 20, 2012

passing row to custom code

I wish to pass the current row to a custom function in reporting
services...does anyone have the syntax for this?
It would looking like: txtMybox.value = ParseInformation( current_row)
ThanksRoy.
Your value should be
=Code.ParseInformation(Fields!CurrentRow.Value)
Now, this is subject to what "current row" is refering to. If your
referencing just 1 field in the current row then the above is approriate;
however if you are trying to pass 2, or n number of fields, you need to
either
a) concatenate them together such as
Code.ParseInformation(FIelds!Field_1.Value+Fields!Field_2.Value+...Fields!Field_n.Value)
OR make in your custom code create a variable for each field to be passed,
and call the code like:
Code.ParseInformation(Fields!Field_1.Value,Fields!Field_2.Value,...,Fields!Field_n.Value)
Michael C
"roy@.mgk.com" wrote:
> I wish to pass the current row to a custom function in reporting
> services...does anyone have the syntax for this?
> It would looking like: txtMybox.value => ParseInformation( current_row)
>
> Thanks
>

No comments:

Post a Comment