PDF Export Prompts for Authentication

I am having a weird problem with just one report in production. When
exporting to PDF format only, the browser prompts for user authentication.
No matter what you type in the window (even admin for server) it just keeps
popping up. When you click cancel you see the following error.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
The log file shows the following
w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query
execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
System.StackOverflowException exception:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker process
Other reports in production export to PDF without a problem, just this one
report is causing issues.
Any idea what might be causing this issue? The report exports to PDF fine
in development for this report. Has anyone else seen this issue before?Does this report render correctly in other formats like HTML? Can you help
me understand this error:
Query execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
If it isn't an obvious place in your report that's doing this and leading to
us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
can investigate?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>I am having a weird problem with just one report in production. When
> exporting to PDF format only, the browser prompts for user authentication.
> No matter what you type in the window (even admin for server) it just
> keeps
> popping up. When you click cancel you see the following error.
> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> credentials.
> Internet Information Services (IIS)
> The log file shows the following
>
> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> has
> occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> An
> error has occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Query
> execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> System.StackOverflowException exception:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> process
> Other reports in production export to PDF without a problem, just this one
> report is causing issues.
> Any idea what might be causing this issue? The report exports to PDF fine
> in development for this report. Has anyone else seen this issue before?
>|||It would be really creepy if this renders in HTML but not in PDF (makes no
sense)
I am looking forward getting the rdl ;-)
Jens Süßmeyer.
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> schrieb im
Newsbeitrag news:emN7AkRQFHA.3140@.tk2msftngp13.phx.gbl...
> Does this report render correctly in other formats like HTML? Can you
> help me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading
> to us blowing up, can you email me a copy of your .rdl and .rdl.data file
> so I can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>>I am having a weird problem with just one report in production. When
>> exporting to PDF format only, the browser prompts for user
>> authentication.
>> No matter what you type in the window (even admin for server) it just
>> keeps
>> popping up. When you click cancel you see the following error.
>> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> credentials.
>> Internet Information Services (IIS)
>> The log file shows the following
>>
>> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown., ;
>> Info:
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. -->
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. --> System.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> -- End of inner exception stack trace --
>> at
>> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> report, NameValueCollection reportServerParameters, NameValueCollection
>> deviceInfo, NameValueCollection clientCapabilities,
>> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> CreateAndRegisterStream createAndRegisterStream)
>> at
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> createChunkCallback, RenderingContext rc, GetResource
>> getResourceCallback)
>> -- End of inner exception stack trace --
>> w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> error
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. -->
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. --> System.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> error
>> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> has
>> occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> An
>> error has occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Query
>> execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> System.StackOverflowException exception:
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. -->
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. --> System.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> process
>> Other reports in production export to PDF without a problem, just this
>> one
>> report is causing issues.
>> Any idea what might be causing this issue? The report exports to PDF
>> fine
>> in development for this report. Has anyone else seen this issue before?
>|||We tested the report on another server and duplicated the problem. Once we
upgraded to SP1, the problem went away.
"Donovan Smith [MSFT]" wrote:
> Does this report render correctly in other formats like HTML? Can you help
> me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading to
> us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
> can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
> >I am having a weird problem with just one report in production. When
> > exporting to PDF format only, the browser prompts for user authentication.
> > No matter what you type in the window (even admin for server) it just
> > keeps
> > popping up. When you click cancel you see the following error.
> >
> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> > credentials.
> > Internet Information Services (IIS)
> >
> > The log file shows the following
> >
> >
> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown., ;
> > Info:
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > -- End of inner exception stack trace --
> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> > has
> > occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> > An
> > error has occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> > Query
> > execution failed for data set 'dsChangesInLargeLoss'. -->
> > System.Data.SqlClient.SqlException: The conversion of a char data type to
> > a
> > datetime data type resulted in an out-of-range datetime value.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> > System.StackOverflowException exception:
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> > process
> >
> > Other reports in production export to PDF without a problem, just this one
> > report is causing issues.
> >
> > Any idea what might be causing this issue? The report exports to PDF fine
> > in development for this report. Has anyone else seen this issue before?
> >
>
>|||Well, that was an easier answer than I expected. Good to know it's working.
:)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:6FFDE7FB-5525-469A-AEC4-4189555A94E8@.microsoft.com...
> We tested the report on another server and duplicated the problem. Once
> we
> upgraded to SP1, the problem went away.
> "Donovan Smith [MSFT]" wrote:
>> Does this report render correctly in other formats like HTML? Can you
>> help
>> me understand this error:
>> Query execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> If it isn't an obvious place in your report that's doing this and leading
>> to
>> us blowing up, can you email me a copy of your .rdl and .rdl.data file so
>> I
>> can investigate?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
>> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>> >I am having a weird problem with just one report in production. When
>> > exporting to PDF format only, the browser prompts for user
>> > authentication.
>> > No matter what you type in the window (even admin for server) it just
>> > keeps
>> > popping up. When you click cancel you see the following error.
>> >
>> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> > credentials.
>> > Internet Information Services (IIS)
>> >
>> > The log file shows the following
>> >
>> >
>> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown., ;
>> > Info:
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > -- End of inner exception stack trace --
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> > -- End of inner exception stack trace --
>> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> > error
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> > error
>> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> > has
>> > occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> > An
>> > error has occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> > Query
>> > execution failed for data set 'dsChangesInLargeLoss'. -->
>> > System.Data.SqlClient.SqlException: The conversion of a char data type
>> > to
>> > a
>> > datetime data type resulted in an out-of-range datetime value.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> > System.StackOverflowException exception:
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> > process
>> >
>> > Other reports in production export to PDF without a problem, just this
>> > one
>> > report is causing issues.
>> >
>> > Any idea what might be causing this issue? The report exports to PDF
>> > fine
>> > in development for this report. Has anyone else seen this issue
>> > before?
>> >
>>

PDF always prompts

I'm publishing reports in PDF, providing users with URLs like
http://<server>/reportserver?/<reportname>&rs:Format=PDF&rs:Command=Render
In some circumstances, I'd like the PDF to open directly in the browser
without a prompt, but these always ask if I want to Open or Save the file,
directly in Acrobat Reader 8. How can I make this happen?
Static PDF files on my server open directly in the browser as expected.I had some fun trying to track that down too. I eventually found this, which
worked for me. I'm no expert so I'm not sure just what the critical bit is.
I'm using the Render method to get the report as a byte[] from Reporting
Services. Good luck:
private void DoOutput(byte[] result)
{
Response.ContentType = "Application/pdf";
Response.Cache.SetCacheability(HttpCacheability.Public);
Response.BufferOutput = false;
int count = result.Length;
if (count > 0)
{
Response.OutputStream.Write(result, 0, count);
}
Response.End();
}
"Rocks" wrote:
> I'm publishing reports in PDF, providing users with URLs like
> http://<server>/reportserver?/<reportname>&rs:Format=PDF&rs:Command=Render
> In some circumstances, I'd like the PDF to open directly in the browser
> without a prompt, but these always ask if I want to Open or Save the file,
> directly in Acrobat Reader 8. How can I make this happen?
> Static PDF files on my server open directly in the browser as expected.|||So, I have to use ASP.NET? I'm still running classic ASP.
"jgwilliams" wrote:
> I had some fun trying to track that down too. I eventually found this, which
> worked for me. I'm no expert so I'm not sure just what the critical bit is.
> I'm using the Render method to get the report as a byte[] from Reporting
> Services. Good luck:
> private void DoOutput(byte[] result)
> {
> Response.ContentType = "Application/pdf";
> Response.Cache.SetCacheability(HttpCacheability.Public);
> Response.BufferOutput = false;
> int count = result.Length;
> if (count > 0)
> {
> Response.OutputStream.Write(result, 0, count);
> }
> Response.End();
> }
> "Rocks" wrote:
> > I'm publishing reports in PDF, providing users with URLs like
> > http://<server>/reportserver?/<reportname>&rs:Format=PDF&rs:Command=Render
> >
> > In some circumstances, I'd like the PDF to open directly in the browser
> > without a prompt, but these always ask if I want to Open or Save the file,
> > directly in Acrobat Reader 8. How can I make this happen?
> >
> > Static PDF files on my server open directly in the browser as expected.|||Aah, right. Sorry, I can't help you there - I never really used classic ASP
in earnest.
"Rocks" wrote:
> So, I have to use ASP.NET? I'm still running classic ASP.
> "jgwilliams" wrote:
> > I had some fun trying to track that down too. I eventually found this, which
> > worked for me. I'm no expert so I'm not sure just what the critical bit is.
> > I'm using the Render method to get the report as a byte[] from Reporting
> > Services. Good luck:
> >
> > private void DoOutput(byte[] result)
> > {
> > Response.ContentType = "Application/pdf";
> > Response.Cache.SetCacheability(HttpCacheability.Public);
> > Response.BufferOutput = false;
> > int count = result.Length;
> > if (count > 0)
> > {
> > Response.OutputStream.Write(result, 0, count);
> > }
> > Response.End();
> > }
> >
> > "Rocks" wrote:
> >
> > > I'm publishing reports in PDF, providing users with URLs like
> > > http://<server>/reportserver?/<reportname>&rs:Format=PDF&rs:Command=Render
> > >
> > > In some circumstances, I'd like the PDF to open directly in the browser
> > > without a prompt, but these always ask if I want to Open or Save the file,
> > > directly in Acrobat Reader 8. How can I make this happen?
> > >
> > > Static PDF files on my server open directly in the browser as expected.|||I found a solution that works for my situation, and even works in classic
ASP: just setup a server proxy:
Response.ContentType = "application/pdf"
reportSource = "reportserver?reportname&rs:Format=PDF"
set objReport = Server.CreateObject("MSXML2.ServerXMLHTTP")
objReport.open "GET", reportSource, false
objReport.send
Response.BinaryWrite(objReport.ResponseBody)
set objReport = nothing
"jgwilliams" wrote:
> Aah, right. Sorry, I can't help you there - I never really used classic ASP
> in earnest.
> "Rocks" wrote:
> > So, I have to use ASP.NET? I'm still running classic ASP.
> >
> > "jgwilliams" wrote:
> >
> > > I had some fun trying to track that down too. I eventually found this, which
> > > worked for me. I'm no expert so I'm not sure just what the critical bit is.
> > > I'm using the Render method to get the report as a byte[] from Reporting
> > > Services. Good luck:
> > >
> > > private void DoOutput(byte[] result)
> > > {
> > > Response.ContentType = "Application/pdf";
> > > Response.Cache.SetCacheability(HttpCacheability.Public);
> > > Response.BufferOutput = false;
> > > int count = result.Length;
> > > if (count > 0)
> > > {
> > > Response.OutputStream.Write(result, 0, count);
> > > }
> > > Response.End();
> > > }
> > >
> > > "Rocks" wrote:
> > >
> > > > I'm publishing reports in PDF, providing users with URLs like
> > > > http://<server>/reportserver?/<reportname>&rs:Format=PDF&rs:Command=Render
> > > >
> > > > In some circumstances, I'd like the PDF to open directly in the browser
> > > > without a prompt, but these always ask if I want to Open or Save the file,
> > > > directly in Acrobat Reader 8. How can I make this happen?
> > > >
> > > > Static PDF files on my server open directly in the browser as expected.|||I'm facing the same iissue, and would like to know how to use this method
"private void DoOutput(byte[] result)" the param result where i'm going to
fill it ?
thnx a lot
"jgwilliams" wrote:
> I had some fun trying to track that down too. I eventually found this, which
> worked for me. I'm no expert so I'm not sure just what the critical bit is.
> I'm using the Render method to get the report as a byte[] from Reporting
> Services. Good luck:
> private void DoOutput(byte[] result)
> {
> Response.ContentType = "Application/pdf";
> Response.Cache.SetCacheability(HttpCacheability.Public);
> Response.BufferOutput = false;
> int count = result.Length;
> if (count > 0)
> {
> Response.OutputStream.Write(result, 0, count);
> }
> Response.End();
> }
> "Rocks" wrote:
> > I'm publishing reports in PDF, providing users with URLs like
> > http://<server>/reportserver?/<reportname>&rs:Format=PDF&rs:Command=Render
> >
> > In some circumstances, I'd like the PDF to open directly in the browser
> > without a prompt, but these always ask if I want to Open or Save the file,
> > directly in Acrobat Reader 8. How can I make this happen?
> >
> > Static PDF files on my server open directly in the browser as expected.