Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Input parameter based on text -- I don't want default values Expand / Collapse
Posted Tuesday, July 22, 2014 1:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 30, 2014 9:01 AM
Points: 5, Visits: 48

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...
-Postal code

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?
Post #1595266
Posted Tuesday, August 12, 2014 3:33 PM



Group: General Forum Members
Last Login: Yesterday @ 5:13 PM
Points: 456, Visits: 1,060
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?
Post #1602503
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse