SSRS - Applying a filter to a data set for a parameter
Currently when you define the data set to use for a parameter its all or nothing. That really is annoying when you want to use the dataset more than once, for instance to populate a second parameter, or provide a reduced set of values for another parameter.
Well i’ve raised a connect item about it https://connect.microsoft.com/SQLServer/feedback/details/575901/reporting-services-allow-for-datasets-used-by-parameters-to-be-filtered If you think it would be useful then please vote.
Some prime examples are for getting time periods. you have a start and end date. You don’t want have to specify two queries to get the dates but you do want the To date to only show date after the from date. Currently thats not possible.