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" for Header in case of Multiple Parameter Expand / Collapse
Author
Message
Posted Tuesday, June 10, 2014 9:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 11:00 AM
Points: 243, Visits: 736
I am trying to display multiple parameter in the header when a person selects them from a list.
So, I use this in the text box expressions:

= "Gross Total For : " & Join(Parameters!TeamName.Value, ",")

How can I select the "Select All "Option and display "All" instead of displaying 50 names.
Post #1579284
Posted Tuesday, June 10, 2014 4:17 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, November 21, 2014 1:23 PM
Points: 1,951, Visits: 1,473
Here's a couple of ways to try assuming that you're filling your list from a query.

="Gross Total For : " & iif(Parameters!TeamName.Count = count(Fields!TeamName.Value,"DataSetName"),"All", Join(Parameters!TeamName.Value, ","))

="Gross Total For : " & IIF(COUNTROWS("DataSetName").Equals(Parameters!TeamName.Count),"All", Join(Parameters!TeamName.Value, ","))





Everything is awesome!
Post #1579436
Posted Wednesday, June 11, 2014 9:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 11:00 AM
Points: 243, Visits: 736
Will try. Thanks
Post #1579680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse