Tuesday, February 14, 2012

display filter info in Report Builder

hi all,

is it possible to display the value of filter on the report (Report Builder) instead of displaying

Filter: Productions with: All of (Month in (prompted))

which is not informative. ?

thanks !

This is not supported by the auto-generated filter descriptions. However, a workaround is described here:

http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx

|||

Hi Bob,

thanks a lot for the info. was looking high and low in help file and even online but couldn't get anything.

however, i have problem displaying the parameter value if it's in text format.

i've tried writing the following expressions

=String.format("Property: ", Parameters!Property.Value)

="Property: " & Parameters!Property.Value

but they won't work.

thanks..

|||

Hi Bob,

will this solution that you suggested work with parameters which have multiple selections?

Thanks!

|||I've never tried it. You might need to use the String.Join method to get the values into a single string.

No comments:

Post a Comment