Hi!
I'm getting this error when trying to export (to anything pdf, excel,
tiff...) a report with a subreport included. It's a linked subreport (with
that I mean it takes two parameters from the main report as inparameters) The
subreport is really simple and I have even tested with an empty subreport
with the same result.
Error msg:
An unexpected error occurred in Report Processing. (rsUnexpectedError)
I have other reports with subreports included that goes just fine to export.
Anyone with similar problems and a possible solution?
Regards,
/MattiasHi again!
I found the answer of my own problem and it seems to be a bug in RS.
RS crashes when trying to export a report when the following conditions are
true:
1. You are using a table.
2. The HideDuplicates property is used on a detail cell in this table.
3. The table contains a subreport.
This occurs no matter what export format you choose.
Do you RS guys at MS know about this?
--
/Mattias
"MattiasT" wrote:
> Hi!
> I'm getting this error when trying to export (to anything pdf, excel,
> tiff...) a report with a subreport included. It's a linked subreport (with
> that I mean it takes two parameters from the main report as inparameters) The
> subreport is really simple and I have even tested with an empty subreport
> with the same result.
> Error msg:
> An unexpected error occurred in Report Processing. (rsUnexpectedError)
> I have other reports with subreports included that goes just fine to export.
> Anyone with similar problems and a possible solution?
> Regards,
> /Mattias|||Hi,
I'm having exactly the same behaviour :-(
Same conditions results in the following error:
w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
Kind regards,
Wesley
"MattiasT" wrote:
> Hi again!
> I found the answer of my own problem and it seems to be a bug in RS.
> RS crashes when trying to export a report when the following conditions are
> true:
> 1. You are using a table.
> 2. The HideDuplicates property is used on a detail cell in this table.
> 3. The table contains a subreport.
> This occurs no matter what export format you choose.
> Do you RS guys at MS know about this?
> --
> /Mattias
>
> "MattiasT" wrote:
> > Hi!
> >
> > I'm getting this error when trying to export (to anything pdf, excel,
> > tiff...) a report with a subreport included. It's a linked subreport (with
> > that I mean it takes two parameters from the main report as inparameters) The
> > subreport is really simple and I have even tested with an empty subreport
> > with the same result.
> >
> > Error msg:
> > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> >
> > I have other reports with subreports included that goes just fine to export.
> > Anyone with similar problems and a possible solution?
> >
> > Regards,
> > /Mattias|||I am experiencing the same issue. I have a couple of subreports imbedded in a
table and when exporting the report to PDF I get an unexpected error. Has
anyone heard of a fix for this?
"WesleyB" wrote:
> Hi,
> I'm having exactly the same behaviour :-(
> Same conditions results in the following error:
> w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
> Call stack:
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effecectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
>
> Kind regards,
> Wesley
> "MattiasT" wrote:
> > Hi again!
> >
> > I found the answer of my own problem and it seems to be a bug in RS.
> >
> > RS crashes when trying to export a report when the following conditions are
> > true:
> > 1. You are using a table.
> > 2. The HideDuplicates property is used on a detail cell in this table.
> > 3. The table contains a subreport.
> >
> > This occurs no matter what export format you choose.
> >
> > Do you RS guys at MS know about this?
> >
> > --
> > /Mattias
> >
> >
> > "MattiasT" wrote:
> >
> > > Hi!
> > >
> > > I'm getting this error when trying to export (to anything pdf, excel,
> > > tiff...) a report with a subreport included. It's a linked subreport (with
> > > that I mean it takes two parameters from the main report as inparameters) The
> > > subreport is really simple and I have even tested with an empty subreport
> > > with the same result.
> > >
> > > Error msg:
> > > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> > >
> > > I have other reports with subreports included that goes just fine to export.
> > > Anyone with similar problems and a possible solution?
> > >
> > > Regards,
> > > /Mattias|||Dave,
Unfortunately I haven't heard of a fix and SQL Server 2005 seems to have the
same issue.
I just asked here if I can submit a case to Premier Support.
I will be submitting the case any day now so I'll keep you posted if I hear
something.
Regards,
--
Wesley
http://dis4ea.blogspot.com
"Dave Sundell" schreef:
> I am experiencing the same issue. I have a couple of subreports imbedded in a
> table and when exporting the report to PDF I get an unexpected error. Has
> anyone heard of a fix for this?
> "WesleyB" wrote:
> > Hi,
> >
> > I'm having exactly the same behaviour :-(
> > Same conditions results in the following error:
> >
> > w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
> > Call stack:
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters)
> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effecectiveParameters, String[]&
> > secondaryStreamNames)
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
> > System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> > System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > completedSynchronously)
> > System.Web.HttpApplication.ResumeSteps(Exception error)
> > System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> > System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> > System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> > System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> >
> > w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > unexpected error occurred in Report Processing., ;
> > Info:
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > unexpected error occurred in Report Processing.
> > w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > unexpected error occurred in Report Processing.
> >
> >
> > Kind regards,
> > Wesley
> >
> > "MattiasT" wrote:
> >
> > > Hi again!
> > >
> > > I found the answer of my own problem and it seems to be a bug in RS.
> > >
> > > RS crashes when trying to export a report when the following conditions are
> > > true:
> > > 1. You are using a table.
> > > 2. The HideDuplicates property is used on a detail cell in this table.
> > > 3. The table contains a subreport.
> > >
> > > This occurs no matter what export format you choose.
> > >
> > > Do you RS guys at MS know about this?
> > >
> > > --
> > > /Mattias
> > >
> > >
> > > "MattiasT" wrote:
> > >
> > > > Hi!
> > > >
> > > > I'm getting this error when trying to export (to anything pdf, excel,
> > > > tiff...) a report with a subreport included. It's a linked subreport (with
> > > > that I mean it takes two parameters from the main report as inparameters) The
> > > > subreport is really simple and I have even tested with an empty subreport
> > > > with the same result.
> > > >
> > > > Error msg:
> > > > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> > > >
> > > > I have other reports with subreports included that goes just fine to export.
> > > > Anyone with similar problems and a possible solution?
> > > >
> > > > Regards,
> > > > /Mattias|||Ok.
So Microsoft has confirmed that it is a bug.
But they have no idea when it will be fixed, probably next service pack.
You can get the output if you render it through the SOAP webservice though.
--
Wesley
http://dis4ea.blogspot.com
"Wesley B" schreef:
> Dave,
> Unfortunately I haven't heard of a fix and SQL Server 2005 seems to have the
> same issue.
> I just asked here if I can submit a case to Premier Support.
> I will be submitting the case any day now so I'll keep you posted if I hear
> something.
> Regards,
> --
> Wesley
> http://dis4ea.blogspot.com
>
> "Dave Sundell" schreef:
> > I am experiencing the same issue. I have a couple of subreports imbedded in a
> > table and when exporting the report to PDF I get an unexpected error. Has
> > anyone heard of a fix for this?
> >
> > "WesleyB" wrote:
> >
> > > Hi,
> > >
> > > I'm having exactly the same behaviour :-(
> > > Same conditions results in the following error:
> > >
> > > w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
> > > Call stack:
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
> > > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effectiveParameters)
> > > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effecectiveParameters, String[]&
> > > secondaryStreamNames)
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
> > > System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> > > System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > > completedSynchronously)
> > > System.Web.HttpApplication.ResumeSteps(Exception error)
> > > System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> > > System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> > > System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> > > System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> > >
> > > w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > > unexpected error occurred in Report Processing., ;
> > > Info:
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > > unexpected error occurred in Report Processing.
> > > w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > > unexpected error occurred in Report Processing.
> > >
> > >
> > > Kind regards,
> > > Wesley
> > >
> > > "MattiasT" wrote:
> > >
> > > > Hi again!
> > > >
> > > > I found the answer of my own problem and it seems to be a bug in RS.
> > > >
> > > > RS crashes when trying to export a report when the following conditions are
> > > > true:
> > > > 1. You are using a table.
> > > > 2. The HideDuplicates property is used on a detail cell in this table.
> > > > 3. The table contains a subreport.
> > > >
> > > > This occurs no matter what export format you choose.
> > > >
> > > > Do you RS guys at MS know about this?
> > > >
> > > > --
> > > > /Mattias
> > > >
> > > >
> > > > "MattiasT" wrote:
> > > >
> > > > > Hi!
> > > > >
> > > > > I'm getting this error when trying to export (to anything pdf, excel,
> > > > > tiff...) a report with a subreport included. It's a linked subreport (with
> > > > > that I mean it takes two parameters from the main report as inparameters) The
> > > > > subreport is really simple and I have even tested with an empty subreport
> > > > > with the same result.
> > > > >
> > > > > Error msg:
> > > > > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> > > > >
> > > > > I have other reports with subreports included that goes just fine to export.
> > > > > Anyone with similar problems and a possible solution?
> > > > >
> > > > > Regards,
> > > > > /Mattias
Showing posts with label pdf. Show all posts
Showing posts with label pdf. Show all posts
Thursday, March 29, 2012
Error exporting report to PDF
I have a report with embedded subreports for different departments. When I render a department with short subreports the report exports to PDF fine, but when I have a department with longer subreports then I get an error when exporting. Here is the tail end of the error message in the log file:
inetinfo!library!334!03/01/2006-16:08:30:: i INFO: Call to RenderNext( '/Budgeting/Department_Spending_Report' )
inetinfo!chunks!334!03/01/2006-16:08:30:: i INFO: ### GetReportChunk('RenderingInfo_PDF', 2), chunk was not found! this=a34ae82e-c4b2-4343-be6b-3989db988405
inetinfo!reportrendering!334!03/01/2006-16:08:32:: 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.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemCollection.get_Item(Int32 index)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.CalculateItemMeasurement(Orientation orientation, Double childrenMaximumDistance, ReAdjustments itemReAdjustment, ItemContext savedContext)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render)
at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
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
inetinfo!webserver!334!03/01/2006-16:08:32:: 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.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
I'm running Reporting Services SP2. I've searched other postings and I can't seem to find anyone else with the same issue. I'm able to export to excel with no problem.
Any help would be appreciated.
Thank You.
I'm sorry I don't have a solution for you. But I'm having the same problem producing a pdf. I have a report that has a subreport that has a subreport (three levels of reporting). I have verified that when no third level subreport is larger than one page, the pdf is created successfully. However, when any third level subreport extends beyond one page, a pdf cannot successfully be generated. The hourglass never goes away when trying to generate the pdf.
I'm hoping that someone who reads this may have a solution for both of us.
I have been working on this problem for several days, and I'm desparate.
Bob
Error exporting report to PDF
I have a report with embedded subreports for different departments. When I render a department with short subreports the report exports to PDF fine, but when I have a department with longer subreports then I get an error when exporting. Here is the tail end of the error message in the log file:
inetinfo!library!334!03/01/2006-16:08:30:: i INFO: Call to RenderNext( '/Budgeting/Department_Spending_Report' )
inetinfo!chunks!334!03/01/2006-16:08:30:: i INFO: ### GetReportChunk('RenderingInfo_PDF', 2), chunk was not found! this=a34ae82e-c4b2-4343-be6b-3989db988405
inetinfo!reportrendering!334!03/01/2006-16:08:32:: 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.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemCollection.get_Item(Int32 index)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.CalculateItemMeasurement(Orientation orientation, Double childrenMaximumDistance, ReAdjustments itemReAdjustment, ItemContext savedContext)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation orientation, Boolean repeatableParent, Boolean canDelete, Double& minimumCoordinate, Double& distance)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render)
at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
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
inetinfo!webserver!334!03/01/2006-16:08:32:: 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.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
I'm running Reporting Services SP2. I've searched other postings and I can't seem to find anyone else with the same issue. I'm able to export to excel with no problem.
Any help would be appreciated.
Thank You.
I'm sorry I don't have a solution for you. But I'm having the same problem producing a pdf. I have a report that has a subreport that has a subreport (three levels of reporting). I have verified that when no third level subreport is larger than one page, the pdf is created successfully. However, when any third level subreport extends beyond one page, a pdf cannot successfully be generated. The hourglass never goes away when trying to generate the pdf.
I'm hoping that someone who reads this may have a solution for both of us.
I have been working on this problem for several days, and I'm desparate.
Bob
Error exporting in Excel !
I can export in PDF without problem.
But when I try to export in xls, I always have an error with the
dataset ?
Please I need help ... I have no idea what I must do to correct that.
Even with SP1 nothing changed.
I have the error message in french only, I hope you will understand (I
have delete the link for online support in the message)
Une erreur s'est produite lors du traitement du rapport.
(rsProcessingAborted)
Échec de l'exécution de la requête pour le dataset « DataSet1
».(rsErrorExecutingCommand)
ExecuteReader: CommandText property has not been initialized
If you need more info please tell me. I'm kind of lost ...Also .. The Query is dynamic ... it seems to be the problem ...
Any suggestion ...|||Rendering to Excel (or any other format) should have nothing to do with it.
Something in your query is evaluating to NULL or empty string. That it
happens when you render to Excel issue is probably coincidence.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407050635.54359192@.posting.google.com...
> Also .. The Query is dynamic ... it seems to be the problem ...
> Any suggestion ...|||I have 3 reports. The user can choose between PDF or Excel for output
format.
I have the same problem with the 3 reports. PDF is OK, Excel always
crashes. Big coincidence I guess. I can't find what is wrong with my
programming.
It's look like the connection with the dataset is made BEFORE the
obtention of the parameters when I try to output in excel format. So
we have some null values in the query after (I guess) ..
On another environment I have this error
This report requires a default or user-defined value for the report
parameter 'rqtDataSet1'. To run or subscribe to this report, you must
provide a parameter value. (rsReportParameterValueNotSet)
I have no default value for the parameter of the report, if I put a
default value (the query), the excel file open but is blank, no value,
no header, nothing.
This is the difference in my code for PDF or EXCEL (objHTTP =MSXML2.ServerXMLHTTP)
If dictParameters("ViewAs") = "2" Then
sParams = sParams & "rs:Format=PDF"
Else
sParams = sParams & "rs:Format=EXCEL"
End If
If dictParameters("ViewAs") = 2 Then
objHTTP.setRequestHeader "Content-Type",
"application/x-www-form-urlencoded"
Else
objHTTP.setRequestHeader "Content-Type",
"application/vnd.ms-excel"
End If
This is sParams at the end
rqtDataSet1=SELECT%20CAST(MF.IS_COMP%20AS%20VARCHAR(1))%20AS%20MACH_TYPE%2CCAST(DAY(MF.CRET_ON)%20AS%20VARCHAR)%20%2B%20%27%20%27%20%2B%20Case%20Month(MF.CRET_ON)%20when%201%20then%20%27Jan%27%20when%202%20then%20%27Feb%27%20when%203%20then%20%27Mar%27%20when%204%20then%20%27Apr%27%20when%205%20then%20%27May%27%20when%206%20then%20%27Jun%27%20when%207%20then%20%27Jul%27%20when%208%20then%20%27Aug%
7%20when%209%20then%20%27Sep%27%20when%2010%20then%20%27Oct%27%20when%2011%20then%20%27Nov%27%20when%2012%20then%20%27Dec%27%20END%20%2B%20%27%20%27%20%2B%20CAST(YEAR(MF.CRET_ON)%20AS%20NVARCHAR(4))%20AS%20FOUND_ON%2CO.NAME%20AS%20OPER_NAME%2CT.NAME%20AS%20TEAM_NAME%2C%20MF.RFID%2CCASE%20WHEN%20MF.PICT%20IS%20NULL%20THEN%20%270%27%20ELSE%20%271%27%20END%20AS%20PICTURE%20FROM%20BMB1_Market.DBO.MACH
NES_FOUND%20MF%20INNER%20JOIN%20BMB1_Market.DBO.TEAMS%20T%20ON%20MF.TEAM_ID=T.ID%20INNER%20JOIN%20BMB1_Market.DBO.OPERATORS%20O%20ON%20T.OPER_ID=O.ID%20WHERE%20MF.CRET_ON%20BETWEEN%20CAST(%272004-07-01%27%20As%20Datetime)
%20AND%20CAST(%272004-07-06%27%20As%20Datetime)%20ORDER%20BY%20MACH_TYPE%20DESC%2CFOUND_ON%2COPER_NAME%2CTEAM_NAME%20&ReportTitle=Machines%20Found&lblFoundOn=Found%20On&lblOpName=Operator%20Name&lblTeamName=Team%20Name&lblMachRFID=Machine%20RFID&lblWPict=With%20Picture&lblCompet=Competitor&lblNotCompet=Not%20Competitor&lblMachSubTot=Machine%20Subtotal&lblNo=No&lblYes=Yes&lblTotal=Grand%20Total&Fro
ToFrom=01%20Jul%202004&FromToTo=06%20Jul%202004&ToTo=&POCGeo=&POCDist=&lblCupSoldFormat=&CupSoldMoreThan=&CupSoldLessThan=&Operators=&OperatorStatus=All&OperatorType=All&Customers=&CustStatus=&POCResp=&POCRespStatus=&POCRespType=&POC=&POCStatus=&MachineStatus=&MachineOwnership=&MachineOwnershipStatus=&MachineVersion=&MachineConf=&MachineConfSel=&ProductRecipeStatus=&ServingRecipeStatus=&RestStatus
&UserID=&LastName=&POCSince=&MachineType=All&LocalizationGrp=&Duration=&StartCalc=&ResultFormat=False&ByUserID=francisco.deolarte@.nestle.com&PrintedOn=06%20Jul%202004&lblFrom=From&lblTo=To&lblCriterias=Report%20Criteria&l
blPOCGeo=POC%20Geographical%20Location&lblPOCDist=POC%20Distribution%20Channel&lblCustomers=Customer&lblOperators=Operator&lblPOCResp=POC%20Responsible&lblPOC=POC&lblMachineOwnership=Machine%20Ownership&lblMachine=Machine&lblMachineStatus=Machine%20Status&lblMachineClass=Machine%20Classification&lblMachineBrand=Machine%20Brand&lblMachineModel=Machine%20Model&lblMachineConf=Machine%20Configuration&
blMachineVersion=Machine%20Version&lblMachineConfSel=Machine%20Configuration%20Selection&lblProductType=Product%20Type&lblServingRecipe=Serving%20Recipe&lblStatus=Status&lblType=Type&lblProductRecipe=Product%20Recipe&lblKPIRespImp=KPI%20Response%20Impact&lblDuration=Duration&lblDays=Days&lblConsolidated=Consolidated%20results&lblBy=By&lblUserID=User%20ID&lblPage=Page&lblPrintedOn=Printed%20on&lblA
=At&lblRole=Role&lblLastName=Last%20Name&lblStartCalc=Start%20Calculation&lblCupSoldMoreThan=More%20than&lblCupSoldLessThan=Less%20than&lblRestStatus=Restriction%20Status&lblMachType=Machine%20Type&lblMachFunc=Machine%20F
unction&lblMachInPoc=Machine%20in%20POC%20since&lblPOCLocGrp=POC%20Localization%20Group&rs:Format=EXCEL|||Some additional info
sUrl = http://(ServerName)/ReportServer?/BMB-MS/MachineFound&rs:Command=Render
objHTTP.Open "POST", sURL, False
'At the end
objHTTP.send sParams 'CRASH THERE objHTTP.status returns 500
When it returns 200, the function returns -> GetReport = objHTTP.responseBody
Is there a special setting I must include in my .rdl ?|||Why are you using URL Access instead of the SOAP API? It looks like you
might be hitting a parameter limit problem. You can also use POST with URL
Access but the SOAP API would be much better.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407060357.31073bf7@.posting.google.com...
>I have 3 reports. The user can choose between PDF or Excel for output
> format.
> I have the same problem with the 3 reports. PDF is OK, Excel always
> crashes. Big coincidence I guess. I can't find what is wrong with my
> programming.
> It's look like the connection with the dataset is made BEFORE the
> obtention of the parameters when I try to output in excel format. So
> we have some null values in the query after (I guess) ..
> On another environment I have this error
> This report requires a default or user-defined value for the report
> parameter 'rqtDataSet1'. To run or subscribe to this report, you must
> provide a parameter value. (rsReportParameterValueNotSet)
> I have no default value for the parameter of the report, if I put a
> default value (the query), the excel file open but is blank, no value,
> no header, nothing.
>
> This is the difference in my code for PDF or EXCEL (objHTTP => MSXML2.ServerXMLHTTP)
> If dictParameters("ViewAs") = "2" Then
> sParams = sParams & "rs:Format=PDF"
> Else
> sParams = sParams & "rs:Format=EXCEL"
> End If
> If dictParameters("ViewAs") = 2 Then
> objHTTP.setRequestHeader "Content-Type",
> "application/x-www-form-urlencoded"
> Else
> objHTTP.setRequestHeader "Content-Type",
> "application/vnd.ms-excel"
> End If
> This is sParams at the end
> rqtDataSet1=SELECT%20CAST(MF.IS_COMP%20AS%20VARCHAR(1))%20AS%20MACH_TYPE%2CCAST(DAY(MF.CRET_ON)%20AS%20VARCHAR)%20%2B%20%27%20%27%20%2B%20Case%20Month(MF.CRET_ON)%20when%201%20then%20%27Jan%27%20when%202%20then%20%27Feb%27%20when%203%20then%20%27Mar%27%20when%204%20then%20%27Apr%27%20when%205%20then%20%27May%27%20when%206%20then%20%27Jun%27%20when%207%20then%20%27Jul%27%20when%208%20then%20%27Aug%
> 7%20when%209%20then%20%27Sep%27%20when%2010%20then%20%27Oct%27%20when%2011%20then%20%27Nov%27%20when%2012%20then%20%27Dec%27%20END%20%2B%20%27%20%27%20%2B%20CAST(YEAR(MF.CRET_ON)%20AS%20NVARCHAR(4))%20AS%20FOUND_ON%2CO.NAME%20AS%20OPER_NAME%2CT.NAME%20AS%20TEAM_NAME%2C%20MF.RFID%2CCASE%20WHEN%20MF.PICT%20IS%20NULL%20THEN%20%270%27%20ELSE%20%271%27%20END%20AS%20PICTURE%20FROM%20BMB1_Market.DBO.MACH
> NES_FOUND%20MF%20INNER%20JOIN%20BMB1_Market.DBO.TEAMS%20T%20ON%20MF.TEAM_ID=T.ID%20INNER%20JOIN%20BMB1_Market.DBO.OPERATORS%20O%20ON%20T.OPER_ID=O.ID%20WHERE%20MF.CRET_ON%20BETWEEN%20CAST(%272004-07-01%27%20As%20Datetime)
> %20AND%20CAST(%272004-07-06%27%20As%20Datetime)%20ORDER%20BY%20MACH_TYPE%20DESC%2CFOUND_ON%2COPER_NAME%2CTEAM_NAME%20&ReportTitle=Machines%20Found&lblFoundOn=Found%20On&lblOpName=Operator%20Name&lblTeamName=Team%20Name&lblMachRFID=Machine%20RFID&lblWPict=With%20Picture&lblCompet=Competitor&lblNotCompet=Not%20Competitor&lblMachSubTot=Machine%20Subtotal&lblNo=No&lblYes=Yes&lblTotal=Grand%20Total&Fro
> ToFrom=01%20Jul%202004&FromToTo=06%20Jul%202004&ToTo=&POCGeo=&POCDist=&lblCupSoldFormat=&CupSoldMoreThan=&CupSoldLessThan=&Operators=&OperatorStatus=All&OperatorType=All&Customers=&CustStatus=&POCResp=&POCRespStatus=&POCRespType=&POC=&POCStatus=&MachineStatus=&MachineOwnership=&MachineOwnershipStatus=&MachineVersion=&MachineConf=&MachineConfSel=&ProductRecipeStatus=&ServingRecipeStatus=&RestStatus
> &UserID=&LastName=&POCSince=&MachineType=All&LocalizationGrp=&Duration=&StartCalc=&ResultFormat=False&ByUserID=francisco.deolarte@.nestle.com&PrintedOn=06%20Jul%202004&lblFrom=From&lblTo=To&lblCriterias=Report%20Criteria&l
> blPOCGeo=POC%20Geographical%20Location&lblPOCDist=POC%20Distribution%20Channel&lblCustomers=Customer&lblOperators=Operator&lblPOCResp=POC%20Responsible&lblPOC=POC&lblMachineOwnership=Machine%20Ownership&lblMachine=Machine&lblMachineStatus=Machine%20Status&lblMachineClass=Machine%20Classification&lblMachineBrand=Machine%20Brand&lblMachineModel=Machine%20Model&lblMachineConf=Machine%20Configuration&
> blMachineVersion=Machine%20Version&lblMachineConfSel=Machine%20Configuration%20Selection&lblProductType=Product%20Type&lblServingRecipe=Serving%20Recipe&lblStatus=Status&lblType=Type&lblProductRecipe=Product%20Recipe&lblKPIRespImp=KPI%20Response%20Impact&lblDuration=Duration&lblDays=Days&lblConsolidated=Consolidated%20results&lblBy=By&lblUserID=User%20ID&lblPage=Page&lblPrintedOn=Printed%20on&lblA
> =At&lblRole=Role&lblLastName=Last%20Name&lblStartCalc=Start%20Calculation&lblCupSoldMoreThan=More%20than&lblCupSoldLessThan=Less%20than&lblRestStatus=Restriction%20Status&lblMachType=Machine%20Type&lblMachFunc=Machine%20F
> unction&lblMachInPoc=Machine%20in%20POC%20since&lblPOCLocGrp=POC%20Localization%20Group&rs:Format=EXCEL|||I'm not familiar with the SOAP API .. Cant someone give me some hints ?
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<uLi7Ud3YEHA.2480@.tk2msftngp13.phx.gbl>...
> Why are you using URL Access instead of the SOAP API? It looks like you
> might be hitting a parameter limit problem. You can also use POST with URL
> Access but the SOAP API would be much better.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.|||It is in the docs under "Web Services Programming".
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407080039.71101e49@.posting.google.com...
> I'm not familiar with the SOAP API .. Cant someone give me some hints ?
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:<uLi7Ud3YEHA.2480@.tk2msftngp13.phx.gbl>...
>> Why are you using URL Access instead of the SOAP API? It looks like you
>> might be hitting a parameter limit problem. You can also use POST with
>> URL
>> Access but the SOAP API would be much better.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
But when I try to export in xls, I always have an error with the
dataset ?
Please I need help ... I have no idea what I must do to correct that.
Even with SP1 nothing changed.
I have the error message in french only, I hope you will understand (I
have delete the link for online support in the message)
Une erreur s'est produite lors du traitement du rapport.
(rsProcessingAborted)
Échec de l'exécution de la requête pour le dataset « DataSet1
».(rsErrorExecutingCommand)
ExecuteReader: CommandText property has not been initialized
If you need more info please tell me. I'm kind of lost ...Also .. The Query is dynamic ... it seems to be the problem ...
Any suggestion ...|||Rendering to Excel (or any other format) should have nothing to do with it.
Something in your query is evaluating to NULL or empty string. That it
happens when you render to Excel issue is probably coincidence.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407050635.54359192@.posting.google.com...
> Also .. The Query is dynamic ... it seems to be the problem ...
> Any suggestion ...|||I have 3 reports. The user can choose between PDF or Excel for output
format.
I have the same problem with the 3 reports. PDF is OK, Excel always
crashes. Big coincidence I guess. I can't find what is wrong with my
programming.
It's look like the connection with the dataset is made BEFORE the
obtention of the parameters when I try to output in excel format. So
we have some null values in the query after (I guess) ..
On another environment I have this error
This report requires a default or user-defined value for the report
parameter 'rqtDataSet1'. To run or subscribe to this report, you must
provide a parameter value. (rsReportParameterValueNotSet)
I have no default value for the parameter of the report, if I put a
default value (the query), the excel file open but is blank, no value,
no header, nothing.
This is the difference in my code for PDF or EXCEL (objHTTP =MSXML2.ServerXMLHTTP)
If dictParameters("ViewAs") = "2" Then
sParams = sParams & "rs:Format=PDF"
Else
sParams = sParams & "rs:Format=EXCEL"
End If
If dictParameters("ViewAs") = 2 Then
objHTTP.setRequestHeader "Content-Type",
"application/x-www-form-urlencoded"
Else
objHTTP.setRequestHeader "Content-Type",
"application/vnd.ms-excel"
End If
This is sParams at the end
rqtDataSet1=SELECT%20CAST(MF.IS_COMP%20AS%20VARCHAR(1))%20AS%20MACH_TYPE%2CCAST(DAY(MF.CRET_ON)%20AS%20VARCHAR)%20%2B%20%27%20%27%20%2B%20Case%20Month(MF.CRET_ON)%20when%201%20then%20%27Jan%27%20when%202%20then%20%27Feb%27%20when%203%20then%20%27Mar%27%20when%204%20then%20%27Apr%27%20when%205%20then%20%27May%27%20when%206%20then%20%27Jun%27%20when%207%20then%20%27Jul%27%20when%208%20then%20%27Aug%
7%20when%209%20then%20%27Sep%27%20when%2010%20then%20%27Oct%27%20when%2011%20then%20%27Nov%27%20when%2012%20then%20%27Dec%27%20END%20%2B%20%27%20%27%20%2B%20CAST(YEAR(MF.CRET_ON)%20AS%20NVARCHAR(4))%20AS%20FOUND_ON%2CO.NAME%20AS%20OPER_NAME%2CT.NAME%20AS%20TEAM_NAME%2C%20MF.RFID%2CCASE%20WHEN%20MF.PICT%20IS%20NULL%20THEN%20%270%27%20ELSE%20%271%27%20END%20AS%20PICTURE%20FROM%20BMB1_Market.DBO.MACH
NES_FOUND%20MF%20INNER%20JOIN%20BMB1_Market.DBO.TEAMS%20T%20ON%20MF.TEAM_ID=T.ID%20INNER%20JOIN%20BMB1_Market.DBO.OPERATORS%20O%20ON%20T.OPER_ID=O.ID%20WHERE%20MF.CRET_ON%20BETWEEN%20CAST(%272004-07-01%27%20As%20Datetime)
%20AND%20CAST(%272004-07-06%27%20As%20Datetime)%20ORDER%20BY%20MACH_TYPE%20DESC%2CFOUND_ON%2COPER_NAME%2CTEAM_NAME%20&ReportTitle=Machines%20Found&lblFoundOn=Found%20On&lblOpName=Operator%20Name&lblTeamName=Team%20Name&lblMachRFID=Machine%20RFID&lblWPict=With%20Picture&lblCompet=Competitor&lblNotCompet=Not%20Competitor&lblMachSubTot=Machine%20Subtotal&lblNo=No&lblYes=Yes&lblTotal=Grand%20Total&Fro
ToFrom=01%20Jul%202004&FromToTo=06%20Jul%202004&ToTo=&POCGeo=&POCDist=&lblCupSoldFormat=&CupSoldMoreThan=&CupSoldLessThan=&Operators=&OperatorStatus=All&OperatorType=All&Customers=&CustStatus=&POCResp=&POCRespStatus=&POCRespType=&POC=&POCStatus=&MachineStatus=&MachineOwnership=&MachineOwnershipStatus=&MachineVersion=&MachineConf=&MachineConfSel=&ProductRecipeStatus=&ServingRecipeStatus=&RestStatus
&UserID=&LastName=&POCSince=&MachineType=All&LocalizationGrp=&Duration=&StartCalc=&ResultFormat=False&ByUserID=francisco.deolarte@.nestle.com&PrintedOn=06%20Jul%202004&lblFrom=From&lblTo=To&lblCriterias=Report%20Criteria&l
blPOCGeo=POC%20Geographical%20Location&lblPOCDist=POC%20Distribution%20Channel&lblCustomers=Customer&lblOperators=Operator&lblPOCResp=POC%20Responsible&lblPOC=POC&lblMachineOwnership=Machine%20Ownership&lblMachine=Machine&lblMachineStatus=Machine%20Status&lblMachineClass=Machine%20Classification&lblMachineBrand=Machine%20Brand&lblMachineModel=Machine%20Model&lblMachineConf=Machine%20Configuration&
blMachineVersion=Machine%20Version&lblMachineConfSel=Machine%20Configuration%20Selection&lblProductType=Product%20Type&lblServingRecipe=Serving%20Recipe&lblStatus=Status&lblType=Type&lblProductRecipe=Product%20Recipe&lblKPIRespImp=KPI%20Response%20Impact&lblDuration=Duration&lblDays=Days&lblConsolidated=Consolidated%20results&lblBy=By&lblUserID=User%20ID&lblPage=Page&lblPrintedOn=Printed%20on&lblA
=At&lblRole=Role&lblLastName=Last%20Name&lblStartCalc=Start%20Calculation&lblCupSoldMoreThan=More%20than&lblCupSoldLessThan=Less%20than&lblRestStatus=Restriction%20Status&lblMachType=Machine%20Type&lblMachFunc=Machine%20F
unction&lblMachInPoc=Machine%20in%20POC%20since&lblPOCLocGrp=POC%20Localization%20Group&rs:Format=EXCEL|||Some additional info
sUrl = http://(ServerName)/ReportServer?/BMB-MS/MachineFound&rs:Command=Render
objHTTP.Open "POST", sURL, False
'At the end
objHTTP.send sParams 'CRASH THERE objHTTP.status returns 500
When it returns 200, the function returns -> GetReport = objHTTP.responseBody
Is there a special setting I must include in my .rdl ?|||Why are you using URL Access instead of the SOAP API? It looks like you
might be hitting a parameter limit problem. You can also use POST with URL
Access but the SOAP API would be much better.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407060357.31073bf7@.posting.google.com...
>I have 3 reports. The user can choose between PDF or Excel for output
> format.
> I have the same problem with the 3 reports. PDF is OK, Excel always
> crashes. Big coincidence I guess. I can't find what is wrong with my
> programming.
> It's look like the connection with the dataset is made BEFORE the
> obtention of the parameters when I try to output in excel format. So
> we have some null values in the query after (I guess) ..
> On another environment I have this error
> This report requires a default or user-defined value for the report
> parameter 'rqtDataSet1'. To run or subscribe to this report, you must
> provide a parameter value. (rsReportParameterValueNotSet)
> I have no default value for the parameter of the report, if I put a
> default value (the query), the excel file open but is blank, no value,
> no header, nothing.
>
> This is the difference in my code for PDF or EXCEL (objHTTP => MSXML2.ServerXMLHTTP)
> If dictParameters("ViewAs") = "2" Then
> sParams = sParams & "rs:Format=PDF"
> Else
> sParams = sParams & "rs:Format=EXCEL"
> End If
> If dictParameters("ViewAs") = 2 Then
> objHTTP.setRequestHeader "Content-Type",
> "application/x-www-form-urlencoded"
> Else
> objHTTP.setRequestHeader "Content-Type",
> "application/vnd.ms-excel"
> End If
> This is sParams at the end
> rqtDataSet1=SELECT%20CAST(MF.IS_COMP%20AS%20VARCHAR(1))%20AS%20MACH_TYPE%2CCAST(DAY(MF.CRET_ON)%20AS%20VARCHAR)%20%2B%20%27%20%27%20%2B%20Case%20Month(MF.CRET_ON)%20when%201%20then%20%27Jan%27%20when%202%20then%20%27Feb%27%20when%203%20then%20%27Mar%27%20when%204%20then%20%27Apr%27%20when%205%20then%20%27May%27%20when%206%20then%20%27Jun%27%20when%207%20then%20%27Jul%27%20when%208%20then%20%27Aug%
> 7%20when%209%20then%20%27Sep%27%20when%2010%20then%20%27Oct%27%20when%2011%20then%20%27Nov%27%20when%2012%20then%20%27Dec%27%20END%20%2B%20%27%20%27%20%2B%20CAST(YEAR(MF.CRET_ON)%20AS%20NVARCHAR(4))%20AS%20FOUND_ON%2CO.NAME%20AS%20OPER_NAME%2CT.NAME%20AS%20TEAM_NAME%2C%20MF.RFID%2CCASE%20WHEN%20MF.PICT%20IS%20NULL%20THEN%20%270%27%20ELSE%20%271%27%20END%20AS%20PICTURE%20FROM%20BMB1_Market.DBO.MACH
> NES_FOUND%20MF%20INNER%20JOIN%20BMB1_Market.DBO.TEAMS%20T%20ON%20MF.TEAM_ID=T.ID%20INNER%20JOIN%20BMB1_Market.DBO.OPERATORS%20O%20ON%20T.OPER_ID=O.ID%20WHERE%20MF.CRET_ON%20BETWEEN%20CAST(%272004-07-01%27%20As%20Datetime)
> %20AND%20CAST(%272004-07-06%27%20As%20Datetime)%20ORDER%20BY%20MACH_TYPE%20DESC%2CFOUND_ON%2COPER_NAME%2CTEAM_NAME%20&ReportTitle=Machines%20Found&lblFoundOn=Found%20On&lblOpName=Operator%20Name&lblTeamName=Team%20Name&lblMachRFID=Machine%20RFID&lblWPict=With%20Picture&lblCompet=Competitor&lblNotCompet=Not%20Competitor&lblMachSubTot=Machine%20Subtotal&lblNo=No&lblYes=Yes&lblTotal=Grand%20Total&Fro
> ToFrom=01%20Jul%202004&FromToTo=06%20Jul%202004&ToTo=&POCGeo=&POCDist=&lblCupSoldFormat=&CupSoldMoreThan=&CupSoldLessThan=&Operators=&OperatorStatus=All&OperatorType=All&Customers=&CustStatus=&POCResp=&POCRespStatus=&POCRespType=&POC=&POCStatus=&MachineStatus=&MachineOwnership=&MachineOwnershipStatus=&MachineVersion=&MachineConf=&MachineConfSel=&ProductRecipeStatus=&ServingRecipeStatus=&RestStatus
> &UserID=&LastName=&POCSince=&MachineType=All&LocalizationGrp=&Duration=&StartCalc=&ResultFormat=False&ByUserID=francisco.deolarte@.nestle.com&PrintedOn=06%20Jul%202004&lblFrom=From&lblTo=To&lblCriterias=Report%20Criteria&l
> blPOCGeo=POC%20Geographical%20Location&lblPOCDist=POC%20Distribution%20Channel&lblCustomers=Customer&lblOperators=Operator&lblPOCResp=POC%20Responsible&lblPOC=POC&lblMachineOwnership=Machine%20Ownership&lblMachine=Machine&lblMachineStatus=Machine%20Status&lblMachineClass=Machine%20Classification&lblMachineBrand=Machine%20Brand&lblMachineModel=Machine%20Model&lblMachineConf=Machine%20Configuration&
> blMachineVersion=Machine%20Version&lblMachineConfSel=Machine%20Configuration%20Selection&lblProductType=Product%20Type&lblServingRecipe=Serving%20Recipe&lblStatus=Status&lblType=Type&lblProductRecipe=Product%20Recipe&lblKPIRespImp=KPI%20Response%20Impact&lblDuration=Duration&lblDays=Days&lblConsolidated=Consolidated%20results&lblBy=By&lblUserID=User%20ID&lblPage=Page&lblPrintedOn=Printed%20on&lblA
> =At&lblRole=Role&lblLastName=Last%20Name&lblStartCalc=Start%20Calculation&lblCupSoldMoreThan=More%20than&lblCupSoldLessThan=Less%20than&lblRestStatus=Restriction%20Status&lblMachType=Machine%20Type&lblMachFunc=Machine%20F
> unction&lblMachInPoc=Machine%20in%20POC%20since&lblPOCLocGrp=POC%20Localization%20Group&rs:Format=EXCEL|||I'm not familiar with the SOAP API .. Cant someone give me some hints ?
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<uLi7Ud3YEHA.2480@.tk2msftngp13.phx.gbl>...
> Why are you using URL Access instead of the SOAP API? It looks like you
> might be hitting a parameter limit problem. You can also use POST with URL
> Access but the SOAP API would be much better.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.|||It is in the docs under "Web Services Programming".
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407080039.71101e49@.posting.google.com...
> I'm not familiar with the SOAP API .. Cant someone give me some hints ?
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:<uLi7Ud3YEHA.2480@.tk2msftngp13.phx.gbl>...
>> Why are you using URL Access instead of the SOAP API? It looks like you
>> might be hitting a parameter limit problem. You can also use POST with
>> URL
>> Access but the SOAP API would be much better.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
Wednesday, February 15, 2012
Error accessing report
I am trying to use the render webmothod to render the report in PDF..I have
forms based authentication in place. The follwoing code is mainly to get rid
of open save dialog box when the report is running in a webbrowser.
The follwing is the code:
===================================================== 'specify the credentials
Dim s As RS.ReportingService = New RS.ReportingService
s.Credentials = System.Net.CredentialCache.DefaultCredentials
Try
' Render arguments
Dim result As Byte() = Nothing
' Please adapt report name and path
Dim reportPath As String = "/SKEL REPORTS/UserList"
Dim format As String = "PDF"
Dim historyID As String = Nothing
Dim devInfo As String = ""
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As RS.Warning() = Nothing
Dim reportHistoryParameters As RS.ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As RS.SessionHeader = New RS.SessionHeader
s.SessionHeaderValue = sh
'call the render method of webservice
result = s.Render(reportPath, format, historyID, devInfo, Nothing,
Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
warnings, streamIDs)
'send the PDF report to IE using Response object
Response.ClearContent()
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", "inline;
filename=report1.PDF")
Response.BinaryWrite(result)
Response.End()
'Response.Write ("done");
Catch ex As Exception
Response.Write(ex.ToString())
End Try
End Sub
===================================================== This is the error I get when I try to run a report:
===================================================== System.Net.WebException: The request failed with the error message: --
Object moved to here.
--. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at RS.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
References\RS\Reference.vb:line 549 at
EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
====================================================The "Object moved to here." is the Report Server trying to redirect you to
the login page. That means the forms auth cookie isn't getting transmitted
properly. Make sure your report server web service proxy is set up
correctly, and that you are calling the web site with the same servername
(FQDN recommended) as you have set up in the report server config files for
the report server. If they are different server names, the cookie won't be
recognized as coming from the same place.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"shahab" <shahab@.discussions.microsoft.com> wrote in message
news:90B97D80-FADB-4727-B71E-A9BF0D110530@.microsoft.com...
>I am trying to use the render webmothod to render the report in PDF..I have
> forms based authentication in place. The follwoing code is mainly to get
> rid
> of open save dialog box when the report is running in a webbrowser.
> The follwing is the code:
> =====================================================> 'specify the credentials
> Dim s As RS.ReportingService = New RS.ReportingService
> s.Credentials = System.Net.CredentialCache.DefaultCredentials
> Try
> ' Render arguments
> Dim result As Byte() = Nothing
> ' Please adapt report name and path
> Dim reportPath As String = "/SKEL REPORTS/UserList"
> Dim format As String = "PDF"
> Dim historyID As String = Nothing
> Dim devInfo As String = ""
> Dim showHideToggle As String = Nothing
> Dim encoding As String
> Dim mimeType As String
> Dim warnings As RS.Warning() = Nothing
> Dim reportHistoryParameters As RS.ParameterValue() = Nothing
> Dim streamIDs As String() = Nothing
> Dim sh As RS.SessionHeader = New RS.SessionHeader
> s.SessionHeaderValue = sh
> 'call the render method of webservice
> result = s.Render(reportPath, format, historyID, devInfo, Nothing,
> Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
> warnings, streamIDs)
> 'send the PDF report to IE using Response object
> Response.ClearContent()
> Response.ContentType = "application/pdf"
> Response.AddHeader("content-disposition", "inline;
> filename=report1.PDF")
> Response.BinaryWrite(result)
> Response.End()
>
> 'Response.Write ("done");
> Catch ex As Exception
> Response.Write(ex.ToString())
> End Try
> End Sub
> =====================================================> This is the error I get when I try to run a report:
> =====================================================> System.Net.WebException: The request failed with the error message: --
> Object moved to here.
> --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at RS.ReportingService.Render(String
> Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
> References\RS\Reference.vb:line 549 at
> EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
> c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
> ====================================================|||Thank you I got it working, the problem was I converted the code to VB.net
and authcookie got confused with the local variable, hence the cookie was
never being passed around.
"Jeff A. Stucker" wrote:
> The "Object moved to here." is the Report Server trying to redirect you to
> the login page. That means the forms auth cookie isn't getting transmitted
> properly. Make sure your report server web service proxy is set up
> correctly, and that you are calling the web site with the same servername
> (FQDN recommended) as you have set up in the report server config files for
> the report server. If they are different server names, the cookie won't be
> recognized as coming from the same place.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> news:90B97D80-FADB-4727-B71E-A9BF0D110530@.microsoft.com...
> >I am trying to use the render webmothod to render the report in PDF..I have
> > forms based authentication in place. The follwoing code is mainly to get
> > rid
> > of open save dialog box when the report is running in a webbrowser.
> > The follwing is the code:
> > =====================================================> > 'specify the credentials
> > Dim s As RS.ReportingService = New RS.ReportingService
> > s.Credentials = System.Net.CredentialCache.DefaultCredentials
> >
> > Try
> >
> > ' Render arguments
> > Dim result As Byte() = Nothing
> > ' Please adapt report name and path
> > Dim reportPath As String = "/SKEL REPORTS/UserList"
> > Dim format As String = "PDF"
> > Dim historyID As String = Nothing
> > Dim devInfo As String = ""
> >
> > Dim showHideToggle As String = Nothing
> > Dim encoding As String
> > Dim mimeType As String
> > Dim warnings As RS.Warning() = Nothing
> > Dim reportHistoryParameters As RS.ParameterValue() = Nothing
> > Dim streamIDs As String() = Nothing
> > Dim sh As RS.SessionHeader = New RS.SessionHeader
> > s.SessionHeaderValue = sh
> >
> > 'call the render method of webservice
> > result = s.Render(reportPath, format, historyID, devInfo, Nothing,
> > Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
> > warnings, streamIDs)
> >
> > 'send the PDF report to IE using Response object
> > Response.ClearContent()
> > Response.ContentType = "application/pdf"
> > Response.AddHeader("content-disposition", "inline;
> > filename=report1.PDF")
> > Response.BinaryWrite(result)
> > Response.End()
> >
> >
> > 'Response.Write ("done");
> > Catch ex As Exception
> > Response.Write(ex.ToString())
> > End Try
> >
> > End Sub
> > =====================================================> > This is the error I get when I try to run a report:
> > =====================================================> > System.Net.WebException: The request failed with the error message: --
> > Object moved to here.
> > --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at RS.ReportingService.Render(String
> > Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
> > References\RS\Reference.vb:line 549 at
> > EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
> > c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
> > ====================================================>
>
forms based authentication in place. The follwoing code is mainly to get rid
of open save dialog box when the report is running in a webbrowser.
The follwing is the code:
===================================================== 'specify the credentials
Dim s As RS.ReportingService = New RS.ReportingService
s.Credentials = System.Net.CredentialCache.DefaultCredentials
Try
' Render arguments
Dim result As Byte() = Nothing
' Please adapt report name and path
Dim reportPath As String = "/SKEL REPORTS/UserList"
Dim format As String = "PDF"
Dim historyID As String = Nothing
Dim devInfo As String = ""
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As RS.Warning() = Nothing
Dim reportHistoryParameters As RS.ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As RS.SessionHeader = New RS.SessionHeader
s.SessionHeaderValue = sh
'call the render method of webservice
result = s.Render(reportPath, format, historyID, devInfo, Nothing,
Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
warnings, streamIDs)
'send the PDF report to IE using Response object
Response.ClearContent()
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", "inline;
filename=report1.PDF")
Response.BinaryWrite(result)
Response.End()
'Response.Write ("done");
Catch ex As Exception
Response.Write(ex.ToString())
End Try
End Sub
===================================================== This is the error I get when I try to run a report:
===================================================== System.Net.WebException: The request failed with the error message: --
Object moved to here.
--. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at RS.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
References\RS\Reference.vb:line 549 at
EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
====================================================The "Object moved to here." is the Report Server trying to redirect you to
the login page. That means the forms auth cookie isn't getting transmitted
properly. Make sure your report server web service proxy is set up
correctly, and that you are calling the web site with the same servername
(FQDN recommended) as you have set up in the report server config files for
the report server. If they are different server names, the cookie won't be
recognized as coming from the same place.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"shahab" <shahab@.discussions.microsoft.com> wrote in message
news:90B97D80-FADB-4727-B71E-A9BF0D110530@.microsoft.com...
>I am trying to use the render webmothod to render the report in PDF..I have
> forms based authentication in place. The follwoing code is mainly to get
> rid
> of open save dialog box when the report is running in a webbrowser.
> The follwing is the code:
> =====================================================> 'specify the credentials
> Dim s As RS.ReportingService = New RS.ReportingService
> s.Credentials = System.Net.CredentialCache.DefaultCredentials
> Try
> ' Render arguments
> Dim result As Byte() = Nothing
> ' Please adapt report name and path
> Dim reportPath As String = "/SKEL REPORTS/UserList"
> Dim format As String = "PDF"
> Dim historyID As String = Nothing
> Dim devInfo As String = ""
> Dim showHideToggle As String = Nothing
> Dim encoding As String
> Dim mimeType As String
> Dim warnings As RS.Warning() = Nothing
> Dim reportHistoryParameters As RS.ParameterValue() = Nothing
> Dim streamIDs As String() = Nothing
> Dim sh As RS.SessionHeader = New RS.SessionHeader
> s.SessionHeaderValue = sh
> 'call the render method of webservice
> result = s.Render(reportPath, format, historyID, devInfo, Nothing,
> Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
> warnings, streamIDs)
> 'send the PDF report to IE using Response object
> Response.ClearContent()
> Response.ContentType = "application/pdf"
> Response.AddHeader("content-disposition", "inline;
> filename=report1.PDF")
> Response.BinaryWrite(result)
> Response.End()
>
> 'Response.Write ("done");
> Catch ex As Exception
> Response.Write(ex.ToString())
> End Try
> End Sub
> =====================================================> This is the error I get when I try to run a report:
> =====================================================> System.Net.WebException: The request failed with the error message: --
> Object moved to here.
> --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at RS.ReportingService.Render(String
> Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
> References\RS\Reference.vb:line 549 at
> EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
> c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
> ====================================================|||Thank you I got it working, the problem was I converted the code to VB.net
and authcookie got confused with the local variable, hence the cookie was
never being passed around.
"Jeff A. Stucker" wrote:
> The "Object moved to here." is the Report Server trying to redirect you to
> the login page. That means the forms auth cookie isn't getting transmitted
> properly. Make sure your report server web service proxy is set up
> correctly, and that you are calling the web site with the same servername
> (FQDN recommended) as you have set up in the report server config files for
> the report server. If they are different server names, the cookie won't be
> recognized as coming from the same place.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> news:90B97D80-FADB-4727-B71E-A9BF0D110530@.microsoft.com...
> >I am trying to use the render webmothod to render the report in PDF..I have
> > forms based authentication in place. The follwoing code is mainly to get
> > rid
> > of open save dialog box when the report is running in a webbrowser.
> > The follwing is the code:
> > =====================================================> > 'specify the credentials
> > Dim s As RS.ReportingService = New RS.ReportingService
> > s.Credentials = System.Net.CredentialCache.DefaultCredentials
> >
> > Try
> >
> > ' Render arguments
> > Dim result As Byte() = Nothing
> > ' Please adapt report name and path
> > Dim reportPath As String = "/SKEL REPORTS/UserList"
> > Dim format As String = "PDF"
> > Dim historyID As String = Nothing
> > Dim devInfo As String = ""
> >
> > Dim showHideToggle As String = Nothing
> > Dim encoding As String
> > Dim mimeType As String
> > Dim warnings As RS.Warning() = Nothing
> > Dim reportHistoryParameters As RS.ParameterValue() = Nothing
> > Dim streamIDs As String() = Nothing
> > Dim sh As RS.SessionHeader = New RS.SessionHeader
> > s.SessionHeaderValue = sh
> >
> > 'call the render method of webservice
> > result = s.Render(reportPath, format, historyID, devInfo, Nothing,
> > Nothing, showHideToggle, encoding, mimeType, reportHistoryParameters,
> > warnings, streamIDs)
> >
> > 'send the PDF report to IE using Response object
> > Response.ClearContent()
> > Response.ContentType = "application/pdf"
> > Response.AddHeader("content-disposition", "inline;
> > filename=report1.PDF")
> > Response.BinaryWrite(result)
> > Response.End()
> >
> >
> > 'Response.Write ("done");
> > Catch ex As Exception
> > Response.Write(ex.ToString())
> > End Try
> >
> > End Sub
> > =====================================================> > This is the error I get when I try to run a report:
> > =====================================================> > System.Net.WebException: The request failed with the error message: --
> > Object moved to here.
> > --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at RS.ReportingService.Render(String
> > Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) in c:\inetpub\wwwroot\skel\Web
> > References\RS\Reference.vb:line 549 at
> > EQ.SKEL.Web.WebForms.ReportViewer.RenderReport() in
> > c:\inetpub\wwwroot\skel\Reports\ReportViewer.aspx.vb:line 137
> > ====================================================>
>
Subscribe to:
Posts (Atom)