Post reply

Report Builder Multi-value parameter textbox expression

  • December 4, 2012 at 9:00 am

    #285721

    Hi,

    I have a distinct list of state-county parameter and a text box that displays this value if selected.

    How do I create an expression that is (Select all) is selected then display 'All' rather than every state-county name being displayed.

    =IIf(IsNothing(Parameters!pStateCounty.Value), "All", Parameters!pStateCounty.Value)

    this expression is not working since a multivalue parameter cannot be set to null and I get an (error)

    Thank you.

  • December 5, 2012 at 9:29 am

    #1565819

    The only thing I think you can do is compare the number of selected items to the total number of items.

    iif(Parameters!pStateCounty.Count = Count(Fields!StateCounty.Value, "MyStateCountyDataSetName"),"All", Join(Parameters!pStateCounty.Label, ",")

    Edit Spelling:cool:

  • December 5, 2012 at 8:47 pm

    #1565996

    Thank you for your response. I used your expression with 'countdistinct' and it worked great.

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

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