Post reply

Parameter Visual basic

  • April 14, 2011 at 1:20 pm

    #248871

    =JOIN(Parameters!salesPersonID.Label , ", ")

    This is the expression i use to join parameters in the report. But now when i "select all" in the parameter drop down list i want to see the word "ALL" instead of the label values. Someone please help me with the visual basic coding.

    So basically when i select "select all" in the parameters i want to see "ALL" instead of the parameter Label values.

  • April 14, 2011 at 4:05 pm

    #1311903

    It's possible, may be not in visual basic but

    =IIf(JOIN(Parameters!salesPersonID.Label , ", ") = JOIN(Parameters!All_ADUserList.Label , ", "), "ALL", JOIN(Parameters!salesPersonID.Label , ", "))

    I created another dataset All_ADUserList same SQL as salesPersonID and did "hide" it.

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

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