SSRS optional parameter issue

  • 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 1 month, 4 weeks ago by  pwalter83.
  • 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