I have a report which takes lot of time to render, rather the stored procedure returning the data to the report consumes good amount of time because of the number of records and conditions in the stored procedure, So what I need to implement is when the report is invoked I am displaying different rendering options, when the user selects CSV format, the download window should be displayed spontaneously, however this is not happening as the window is displayed when the stored procedure completes the processesing and gives the output to the report.
So my question is , is there anyway to invoke the download windows when the stored procedure is invoked instead of displaying it after the stored procedure is process(which is the default behaviour)
Any help would be highly appreciated.
Thanks
Prasad Bhogadi
www.inforaise.com