SSRS optional parameter issue

• pwalter83

  SSChampion

  Points: 14575

  More actions

  November 26, 2021 at 10:19 am

  #3957169

  Hi,

  In the report I am working on there are 2 parameters - the first is a drop down list showing countries and other one is a user entry textbox.

  The requirement is to show the matching data based on the country and the value entered in the textbox.

  however, if no value is selected from the drop down list then it is mandatory for the user to enter value in the textbox and then the data should be displayed on the report as per the user entered value.

  Also, if only the country is selected and no user value is entered, then all the data for the particular country should be displayed.

  I am not sure how to code this requirement within the where clause in SQL.

  I have tried something like below but it doesnt work.

  AND (OFFC_CODE IN (@office) and FOLDER_NUM IN (@fol_num)

  OR OFFC_CODE IN (@office) OR FOLDER_NUM IN (@fol_num))

  Can somebody please help on this ?

  Thanks.

   

   

   

   

   

  • This topic was modified 3 years ago by  pwalter83.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  November 27, 2021 at 11:10 am

  #3957427

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

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