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

Optional Parameter Expand / Collapse
Author
Message
Posted Thursday, August 29, 2013 10:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:50 AM
Points: 256, Visits: 611
I have a Vendor Id parameter that is populated with a seperate dataset query. Is it possible to set this up so the user can chose one of the Vendors or leave it blank and it will return all the records? I have googled and googled with no luck and since it is query driven the allow null option does not work. Any help will be appreciated.
Post #1489803
Posted Thursday, August 29, 2013 11:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:50 AM
Points: 256, Visits: 611
I figured this out. Changed up the dataset query and changed the parameter properties to allow blanks and multiple values. Thanks.
Post #1489810
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse