Input parameter based on text -- I don't want default values

  • Hi,

    I made my query in MDX, working fine. Moved it to SSRS report , not working completely.

    My question in short:

    I have 3 input parameters based on user text. If they type "shop" they get all the shop names that have "shop" in their name etc...

    -shopNAME

    -Postal code

    -Channel

    However, the query designer forced me to use a default value, but I don't want a default value. when I remove the default value option from the parameters, they are still showing int he query. Is there a way to define query parameter to be blank?

  • What version of SSRS are you using? You should have a radio option to not set a default value for the parameter. Also, run your query by substituting a null for that parameter, does it still return rows?

    ----------------------------------------------------

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

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