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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 6:01 PM
Points: 356, Visits: 871
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