Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Display All the parameter value in header of ssrs report Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 9:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
Hi,

How to display parameter value in report header.

Attached sample screen.

Thanks


  Post Attachments 
display all the parameter values in report header.docx (23 views, 32.73 KB)
Post #1486095
Posted Monday, August 19, 2013 10:34 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 7:40 PM
Points: 773, Visits: 4,970
Did you try using JOIN()?

=JOIN(Parameters!prmMultiValuedParam.Value,", ") & " " & Parameters!prmNonMultiValuedParam.Value

Use JOIN for the parameters that allow multiple values and then just

Parameters!ParamName

for the rest.
Post #1486098
Posted Thursday, June 26, 2014 12:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:10 PM
Points: 3, Visits: 150
Thanks!!
Post #1586228
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse