I have a report that displays fine no matter the parameters that I put into it on my development machine. When I push it to production when I use a small date range it comes up fine. When I try to expand the date range it will display the attached image showing that it is fetching the records then it will just sit there in a non-selectable state for as long as you let it sit. Running SQL profiler, the query is executing in less than 8 seconds and is returning 15,500 rows so it is not a incredibly large amount of data.
I have a few other reports that are running fine it just a couple that seem to have this issue. Tried it on Chrome, IE, Safari and all seem to have the same problem.
Any ideas on where to go next?