SQL 2005 RS
I have 5 dropdown parameters, of which only one is required.
All 5 are populated by a dataset.
I have checked allow nulls and blanks for the 4 that are not required.
The SP that I wrote is written in dynamic sql, so it tests for null values for all params, and only includes that part of the where clause if the param isn't null.
My goal is that a user can select any of the dropdowns, or none of them, and still get the data they want. Selecting none of them would return all the data.
Is there a more elegant way to do this? I don't think Filters will work because the fields I am narrowing down with aren't a part of the final report.
Thanks for your help.
I have 5 dropdown parameters, of which only one is required.
All 5 are populated by a dataset.
I have checked allow nulls and blanks for the 4 that are not required.
The SP that I wrote is written in dynamic sql, so it tests for null values for all params, and only includes that part of the where clause if the param isn't null.
My goal is that a user can select any of the dropdowns, or none of them, and still get the data they want. Selecting none of them would return all the data.
Is there a more elegant way to do this? I don't think Filters will work because the fields I am narrowing down with aren't a part of the final report.
Thanks for your help.