One of my report is taking very long time to load. So I am getting time out error from the firewall(not from IIS). 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.Reporting is the third party module. So I can't do any modification on that module.

I am using java script in my timer module ascx file. Now the client is calling the server every 2 minutes. It maintains the connection to the server. I have written the java script in my ascx file. The issue here is, once the report gets loaded, SSRS report is clearing the java script that I written in the ascx file. May I know Is there any way to keep the java script?

I hope the dotnetnuke menu bar is written in java script and It is working after the report gets loaded. I want to do the same. Can you please let me know how to do it?