I have a bunch of dropdowns on an SSRS report.
Each drop down is basically a distinct list of values.
Each drop down is a multi select drop down.
Here is the issue:
If a null or blank value is in the recordset...or the distinct list pulls nothing back in the dropdown...
I need the parameter passed to allow all rows to be sent....or perhaps I need an option to allow in the multiselect for the user to pick a blank or null value.
This way when the user selects the next set of dropdowns a value will be returned.
I dont have a way that I can athink of to make each dropdown based on the other.