What does an SSRS filter do in terms of data processing?

Question

Trying to understand how filtering works in SSRS. My guess is that the dataset will return all rows and then the filters will be applied by SSRS. Is that correct, or are the filters passed through to the dataset at runtime, so that only rows matching the filters are returned.

Does it depend on the Query type in SSRS - store procedure, Text, Table?

Thanks

Answer 1

An SSRS dataset will fetch all rows the underlying query produces. Filters configured in SSRS are applied after the rows are retrieved. In the description of SSRS filters from Microsoft it states "To filter data before it is retrieved, changed the query for each dataset."