Need to add an Expression to a footer from parameters in a PROC

Question

Need to add an Expression to a footer from parameters in a PROC

SQL_ME_RICH

SSChampion

Points: 11200
More actions
June 20, 2011 at 3:37 pm

#240235

Sorry for the long title, but it kinda tells all. I have a report done in VS2008 (BIDS), and I am needing to place an expression in the footer that essentially shows what query was used to create the report. I tried dragging the field expressions over from the data set, but it won't show everything (if multi-valued parameters are used, which in my case there are).
I've tried search on this, but have not been able to find a clean way to do it. I'm sure it's pretty simple, and I am just ignorant to how it is done, but any and all help would be appreciated. Here is both the Design layout and the selections on the preview page (for a better visual of what I am trying to do).
Design Layout
Preview
End Result
Thank you all in advance for your time and assistancce.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

For your multi value parameters you need to use a JOIN in your expression and not use the specific numeric identifier associated with a specific parameter.

=JOIN(Parameters!YourMultiSelectParameterNameHere.Value,", ")

Steven.Howes SSCertifiable Points: 6230 More actions · Answer 2

Try this, Make another parameter and Set a default of =Join(Parameters!District.Value,","). Then place the new parameter in a textbox in the footer.

SQL_ME_RICH SSChampion Points: 11200 More actions · Answer 3

Daniel Bowlin (6/21/2011)
For your multi value parameters you need to use a JOIN in your expression and not use the specific numeric identifier associated with a specific parameter.
=JOIN(Parameters!YourMultiSelectParameterNameHere.Value,", ")

That was the ticket! I was trying to bring over the field - DUH!

thanks to you both!

Rich