Expose Parameters Value selected

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Expose Parameters Value selected

Expose Parameters Value selected

Rate Topic

Display Mode

Topic Options

Author

Message

davdam8

Posted Wednesday, November 07, 2012 3:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 156, Visits: 567

Hi geniuses,

I want to show which parameters the user as chosen to run the report.
For a Non Multivalue parameter it works fine : ="Parameters " + Parameters!param.name.value,
but for a multivalue parameter it retrieves an error.

how do I workaround this?

Thansk
Regards!

Post #1381860

Daniel Bowlin

Posted Wednesday, November 07, 2012 8:55 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:10 PM
Points: 2,673, Visits: 2,418

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

Post #1382033

davdam8

Posted Thursday, November 08, 2012 2:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 156, Visits: 567

Thanks,
How do I do to write in the next line after ", " ?

Regards!

Post #1382341

davdam8

Posted Thursday, November 08, 2012 3:34 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 156, Visits: 567

vbcrlf!!
And for this example:

= "Selected: " + JOIN(Parameters!ParamName.Value, ";" + vbcrlf)

How do I do to make the text "Selected: " in bold?

Thanks
Regards

Post #1382371

atfalatitkb

Posted Friday, November 09, 2012 11:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:30 PM
Points: 163, Visits: 528

what i have typically done is put "Selected: " in it's own text box, make that text box bold, then put JOIN(Parameters!ParamName.Value, ";" + vbcrlf) in it's own text box, adjacent to the other one.

Post #1383160

« Prev Topic | Next Topic »

Permissions