Hello all,
I have a web page that let's users choose from a list of reports and display the results on screen, basically what it does is:
1.- Presents a list of reports
2.- Lets the user choose the report to run
3.- Asks for appropiate parameters
4.- Changes the cursor to "wait cursor" and displays a
message "Please wait while your report is being
created."
5.- Goes through the process of loading the report and
exporting it to pdf format (Crystal Reports XI)
6.- Displays the results using:
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(ReportPath)
Response.Flush()
Response.Close()
Everything works perfectly, the user can see the report and print it if he wishes, then, he can press the "back" button on the browser and return to the report selection screen. When he goes back the user does not see the "wait message" or the "wait cursor" anymore. Again, this works perfect and no problem up to this point.
I added a check box to ask the user if he wanted to see the results in Excel and added the appropiate code and here it is where I'm a little stuck.... Since I'm opening an excel document the "control" passes to excel, meaning that my web page never changes and even though the user can see the report in excel the browser seems "frozen" with the "wait message" and "wait cursor". I've been surffing the net to try to find ideas on how to fix this but up until now I've come out empty handed. Has anyone here encountered a similar situation and could point me in the right direction to get this solved?
Thanks in advance
Luis Torres
I have a web page that let's users choose from a list of reports and display the results on screen, basically what it does is:
1.- Presents a list of reports
2.- Lets the user choose the report to run
3.- Asks for appropiate parameters
4.- Changes the cursor to "wait cursor" and displays a
message "Please wait while your report is being
created."
5.- Goes through the process of loading the report and
exporting it to pdf format (Crystal Reports XI)
6.- Displays the results using:
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(ReportPath)
Response.Flush()
Response.Close()
Everything works perfectly, the user can see the report and print it if he wishes, then, he can press the "back" button on the browser and return to the report selection screen. When he goes back the user does not see the "wait message" or the "wait cursor" anymore. Again, this works perfect and no problem up to this point.
I added a check box to ask the user if he wanted to see the results in Excel and added the appropiate code and here it is where I'm a little stuck.... Since I'm opening an excel document the "control" passes to excel, meaning that my web page never changes and even though the user can see the report in excel the browser seems "frozen" with the "wait message" and "wait cursor". I've been surffing the net to try to find ideas on how to fix this but up until now I've come out empty handed. Has anyone here encountered a similar situation and could point me in the right direction to get this solved?
Thanks in advance
Luis Torres