Well, that makes sense now now that you put it into perspective. It would be more efficient for SQL to do the front work in filtering the records first before passing it into the Report Server.
p.s.
Which is better
asking SQL Server to select a thousand rows from one million and pass a thousand rows to the Report Server
or
asking SQL Server to pass a million rows to the Report Server and asking the Report Server to filter for a thousand rows.