Header Expression based on Parameters values selected

• varshahrame

  SSC Rookie

  Points: 32

  More actions

  February 23, 2022 at 9:17 pm

  #3987678

  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.

   

   

   

   

   

   

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  February 24, 2022 at 10:10 pm

  #3988543

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

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