One of my report is taking very long time to load. So I am getting time out error from the firewall. SQL query is just a inner join of 3 tables.And also I am selecting only the required columns. I am doing 2 Groupings in the report(SSRS), because I have to show the group level totals. query is returning huge number of records.report loading is taking more time because of grouping I am doing in the report. I hope I can't avoid it.
To solve the above issue,I am using 2 modules (reporting module) and timer module. I am having reporting module in the content pane and the timer module in the bottom pane. For the timer module I checked Enable partial rendering.By that I want to refresh only the timer control. So the client will maintain the connection to the server, I will not get the time out error. I am getting this time out error from the firewall. there is no communication between the client and server so the firewall is returning time out error.
In the timer module I just have text box and timer controls. I am assigning the current time from the timer event
But If I am doing the above, the whole page is refreshing. So I am getting "Specified argument was out of the range of valid values." error.