I know this is closed, but it's better to pass the parameter to the stored procedure and filter there. Otherwise, you can send a lot of data to the SSRS server which then discards the data according to the filters you set. Sometimes that's not an option though.