all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Error exporting report with subreport


Error exporting report with subreport MattiasT
6/3/2005 11:32:02 AM
sql server reporting services:
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,
RE: Error exporting report with subreport MattiasT
6/6/2005 12:58:03 AM
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


[quoted text, click to view]
RE: Error exporting report with subreport WesleyB
7/29/2005 2:38:03 AM
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

[quoted text, click to view]
RE: Error exporting report with subreport Dave Sundell
10/10/2005 8:57:17 AM
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?

[quoted text, click to view]
RE: Error exporting report with subreport Wesley B
11/3/2005 1:22:01 AM
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:

[quoted text, click to view]
RE: Error exporting report with subreport Wesley B
12/28/2005 2:29:02 AM
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:

[quoted text, click to view]
AddThis Social Bookmark Button