Reply to thread

Message

<blockquote data-quote="lmttag" data-source="post: 2760191">Steven,Thank you for the information.&nbsp; It was very helpful.I was able to get the 3rd option (ASP.NET AJAX) pattern working for a simplesituation.&nbsp; However, my situation is a bit more complex and I'm not sure howto use the AJAX pattern and make it work.&nbsp; So, I was hoping that I couldgive you some more info. and check to see if you could assist me.As I mentioned in my original post, I have a page that opens another pageusing the JavaScript window.open function.&nbsp; In the second page, I have nocontrols, no buttons (no buttons to click to cause a postback), no div tags,etc.&nbsp; What I'm doing in the second page is generating a SQL Server 2005Reporting Services report, rendering it as PDF, and displaying the PDF inthe second page's browser.For some reports, this generating/rendering of the report can take maybe 20seconds.&nbsp; So, I need the page to display an animated gif with a message thatsays &quot;Please wait...&quot; while, in the background, the report is beinggenerated.&nbsp; Then when the report is done being generated/rendered, I needthe animated gif and wait message to go away and have the PDF reportdisplayed.I hope this makes sense.&nbsp; Would you be able to provide some suggestions/helpwith this situation?Here's some code snippets from my second page that is generating, rendering,and displaying the report.(Nothing in the markup for the page.)&lt;html xmlns=&quot;<a href="http://www.w3.org/1999/xhtml">http://www.w3.org/1999/xhtml</a>&quot; &gt;&lt;head runat=&quot;server&quot;&gt;&nbsp; &nbsp; &lt;title&gt;Generated Report&lt;/title&gt;&nbsp; &nbsp; &lt;link href=&quot;../CSS/ReportsStyleSheet.css&quot; rel=&quot;Stylesheet&quot;type=&quot;text/css&quot; /&gt;&lt;/head&gt;&lt;body&gt;&nbsp; &nbsp; &lt;form id=&quot;formRenderReport&quot; runat=&quot;server&quot;&gt;&nbsp; &nbsp; &lt;div&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/form&gt;&lt;/body&gt;&lt;/html&gt;(The code-behind...)public partial class Pages_RenderReport : System.Web.UI.Page{&nbsp; &nbsp; protected void Page_Load(object sender, EventArgs e)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; if (!IsPostBack)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AddOnPreRenderCompleteAsync(newBeginEventHandler(BeginAsyncOperation), newEndEventHandler(EndAsyncOperation));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; private System.IAsyncResult BeginAsyncOperation(object sender, EventArgse, AsyncCallback cb, object state)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Connect to Reporting Services&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ReportingExecution.ReportExecutionService rs = newReportingExecution.ReportExecutionService();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs.Credentials =System.Net.CredentialCache.DefaultCredentials;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Local Reporting Services variables&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; byte[] result = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string format = &quot;PDF&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string format = outputformat;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string historyID = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string devInfo = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string encoding;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string mimeType;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string extension;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ReportingExecution.Warning[] warnings = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string[] streamIDs = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Set all the Reporting Services variables andparameters and render the report&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ReportingExecution.ExecutionInfo execInfo = newReportingExecution.ExecutionInfo();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ReportingExecution.ExecutionHeader execHeader = newReportingExecution.ExecutionHeader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs.ExecutionHeaderValue = execHeader;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; execInfo = rs.LoadReport(reportPath1, historyID);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs.SetExecutionParameters(parameters, &quot;en-us&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.String SessionId =rs.ExecutionHeaderValue.ExecutionID;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; result = rs.Render(format, devInfo, out extension, outmimeType, out encoding, out warnings, out streamIDs);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; execInfo = rs.GetExecutionInfo();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Force the render out of the report to the browser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Clear();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.ClearContent();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.ClearHeaders();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.AppendHeader(&quot;content-length&quot;,result.Length.ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; switch (outputformat)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case &quot;EXCEL&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.ContentType =&quot;application/vnd.ms-excel&quot;;&nbsp; // Seems to work&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case &quot;MHTML&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.ContentType = &quot;message/rfc822&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case &quot;PDF&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.ContentType = &quot;application/pdf&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; default:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.ContentType = &quot;application/pdf&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.BinaryWrite(result);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Flush();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.End();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (System.Exception ex)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // An exception occurred while trying to generate andrender the report&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; // Just needed to get a IAsyncResult to return&nbsp; &nbsp; &nbsp; &nbsp; System.Net.WebRequest hwr =System.Net.WebRequest.Create(&quot;<a href="http://localhost/">http://localhost/</a>&quot;);&nbsp; &nbsp; &nbsp; &nbsp; return hwr.BeginGetResponse(cb, state);&nbsp; &nbsp; }&nbsp; &nbsp; private void EndAsyncOperation(System.IAsyncResult ar)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; //&nbsp; &nbsp; }</blockquote>

[QUOTE="lmttag, post: 2760191"] Steven, Thank you for the information. It was very helpful. I was able to get the 3rd option (ASP.NET AJAX) pattern working for a simple situation. However, my situation is a bit more complex and I'm not sure how to use the AJAX pattern and make it work. So, I was hoping that I could give you some more info. and check to see if you could assist me. As I mentioned in my original post, I have a page that opens another page using the JavaScript window.open function. In the second page, I have no controls, no buttons (no buttons to click to cause a postback), no div tags, etc. What I'm doing in the second page is generating a SQL Server 2005 Reporting Services report, rendering it as PDF, and displaying the PDF in the second page's browser. For some reports, this generating/rendering of the report can take maybe 20 seconds. So, I need the page to display an animated gif with a message that says "Please wait..." while, in the background, the report is being generated. Then when the report is done being generated/rendered, I need the animated gif and wait message to go away and have the PDF report displayed. I hope this makes sense. Would you be able to provide some suggestions/help with this situation? Here's some code snippets from my second page that is generating, rendering, and displaying the report. (Nothing in the markup for the page.) <html xmlns="[URL]http://www.w3.org/1999/xhtml[/URL]" > <head runat="server"> <title>Generated Report</title> <link href="../CSS/ReportsStyleSheet.css" rel="Stylesheet" type="text/css" /> </head> <body> <form id="formRenderReport" runat="server"> <div> </div> </form> </body> </html> (The code-behind...) public partial class Pages_RenderReport : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { AddOnPreRenderCompleteAsync(new BeginEventHandler(BeginAsyncOperation), new EndEventHandler(EndAsyncOperation)); } } private System.IAsyncResult BeginAsyncOperation(object sender, EventArgs e, AsyncCallback cb, object state) { // ... // Connect to Reporting Services ReportingExecution.ReportExecutionService rs = new ReportingExecution.ReportExecutionService(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; // Local Reporting Services variables byte[] result = null; string format = "PDF"; string format = outputformat; string historyID = null; string devInfo = null; string encoding; string mimeType; string extension; ReportingExecution.Warning[] warnings = null; string[] streamIDs = null; // ... try { // Set all the Reporting Services variables and parameters and render the report ReportingExecution.ExecutionInfo execInfo = new ReportingExecution.ExecutionInfo(); ReportingExecution.ExecutionHeader execHeader = new ReportingExecution.ExecutionHeader(); rs.ExecutionHeaderValue = execHeader; execInfo = rs.LoadReport(reportPath1, historyID); rs.SetExecutionParameters(parameters, "en-us"); System.String SessionId = rs.ExecutionHeaderValue.ExecutionID; result = rs.Render(format, devInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs); execInfo = rs.GetExecutionInfo(); // Force the render out of the report to the browser Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.AppendHeader("content-length", result.Length.ToString()); switch (outputformat) { case "EXCEL": Response.ContentType = "application/vnd.ms-excel"; // Seems to work break; case "MHTML": Response.ContentType = "message/rfc822"; break; case "PDF": Response.ContentType = "application/pdf"; break; default: Response.ContentType = "application/pdf"; break; } Response.BinaryWrite(result); Response.Flush(); Response.Close(); Response.End(); } catch (System.Exception ex) { // An exception occurred while trying to generate and render the report } // Just needed to get a IAsyncResult to return System.Net.WebRequest hwr = System.Net.WebRequest.Create("[URL]http://localhost/[/URL]"); return hwr.BeginGetResponse(cb, state); } private void EndAsyncOperation(System.IAsyncResult ar) { // } [/QUOTE]

Verification