Header Expression based on Parameters values selected

  • Hi all,

    I am new to this blog and also new to SSRS and I am hoping this forum can help me. I have a report created with some parameters and based on the parameters, my report shows the end user what they selected.

    Example:

    Parameter 1 = Rptg_Level (user can select Customers, Groups, Regions, Areas or Branches)

    Parameter 2 = Rptg_Filter (user can select None, Group, Region, Area or Branch).

    Parameter 3 = ORG_SELECTED (This is a parameter where they can enter only one value based on Parameter 2). Option to be Null as well.

    An example would show Selected All Groups in Group C1 based on my expression :

    =”Selected All ” & Parameters!Rptg_Level.Label & " in " & Parameters!Rptg_Filter.Label & " " & Parameters!ORG_SELECTED.Value

    What I am trying to do is when user selects None from Parameter 2 and the 3rd one is Null, I do not want the Parameter 2 value to show as None, as this is what I am getting currently: Selected All Groups in None.

    Any help would be appreciated.

    Thank you.

     

     

     

     

     

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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