Report Builder Role

• sush2186

  Valued Member

  Points: 51

  More actions

  July 31, 2015 at 3:40 pm

  #398830

  Report Builder

  I have a parameter named Role whose values are coming from a query which are about 100.

  I would like to see the filtered in the report so I kept an expression like

  =Join(Parameters!Role.Label, ", ") which displays all the 100 looking akward.

  Wonder if there is any way to keep it as Unfiltered and If few roles are selected display those few.

• pietlinden

  SSC Guru

  Points: 63428

  More actions

  July 31, 2015 at 5:54 pm

  #1816590

  You can use something like this:

  Note: DummyMVParam is a multi-value parameter in my report.

  so this is what my test is doing:

  If there are less than 4 values selected from the multi-value parameter, show the values in a comma-separated list, otherwise show "lots o values".

  =IIF(Parameters!DummyMVParam.Count<4,JOIN(Parameters!DummyMVParam.Value,", "),"lots o values!")