Hard to say given the limited information. One thing would be to filter as much out of the dataset as early as possible (in the stored procedure, if possible). The other option is to run the report on a schedule (refresh every hour?) and then users can see that. depends how up to date you need the report to be.