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.

Hi,

This is a question. And also I am asking how to use ajax with the dotnetnuke. I want to refresh only the portion of the page, But the above coding is refreshing the whole page. May I know How to do it?

Reporting is the third party module. So I can't do any modification on that module.