Hi,
I have read this in the previous post that it is not possible to export
subreport to excel using table/matrix format. Though one of the post says
that you can do it using list (for table format only). Can you pls also
highlight how to have one record in one report attached to one corresponding
row in subreport and so on. Does this work?Hi,
Sorry for answering my own question. I have the answer now. You can use list
and still use subreports.It works fine. But I am still surprised how such a
basic feature is not yet available!!!
"AR" wrote:
> Hi,
> I have read this in the previous post that it is not possible to export
> subreport to excel using table/matrix format. Though one of the post says
> that you can do it using list (for table format only). Can you pls also
> highlight how to have one record in one report attached to one corresponding
> row in subreport and so on. Does this work?|||How did You achieve this ? Kindly Share . i am facing same problem
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/3781
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=59ef90c3359246468db306009d928aee
*****************************************|||Hi,
THis is how you achieve this.
On your main report put a list (from toolbox). Then add data in your main
report. Add a subreport and link it to the main report. Once you have done
it, it would run fine. Only thing you need to remember is that you cannot use
matrix report in yuor sub report. Table formats would work fine. Let me know
if this helps.
Arvind Ranganath
"sa via SQLMonster.com" wrote:
> How did You achieve this ? Kindly Share . i am facing same problem
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/3781
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=59ef90c3359246468db306009d928aee
> *****************************************
>
Showing posts with label subreport. Show all posts
Showing posts with label subreport. Show all posts
Thursday, March 29, 2012
Error exporting report with subreport
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
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
Error exporting a subreport to Excel!?
Hi All,
I have a report sonsisting of two subreports. When I export it to Excel I get an Error!! I played around with it and I found out that if I use ReportItems in my page header it will cause this error! Does anyone have any idea why? Is this a bug or there is some work around it! Thanks.We have talked to our Microsoft rep and they have told us that it is a "feature" and that is how is was designed. It is true that a subreport within a table or matrix will not export to excel. The only workaround is to have the subreport outside of the table or matrix, have the report export to pdf instead, or export the first page of the report (if there are no subreports on the first page) and run the report through excel.
Our rep is seeing if she can get the development team to change it, but I think our chances are slim.|||Thanks for the reply. My case is different! I don't have a table or matrix with subreport in it! I just have a plain page with subreports. Exporting to Excel works only if there is NO reference to any item on the report from Page Header! When I have a "ReportItems!MyText.Value" any where in the Page Header, then exporting to Excel fails!|||
What version of RS are you using? Could you send us the report files, please?
Thank you,
Nico
|||I'm using RS 2000
Try this Main Report. You need "Company Sales" sample report as your sub-report.
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>2in</Width>
<Top>0.125in</Top>
<CanGrow>true</CanGrow>
<Value>=ReportItems!MyTextBox.Value</Value>
<Left>4.125in</Left>
</Textbox>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.375in</Height>
</PageHeader>
<RightMargin>0.5in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="MyTextBox">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Height>0.25in</Height>
<Width>2.625in</Width>
<Top>5.125in</Top>
<CanGrow>true</CanGrow>
<Value>=Fields!Name.Value</Value>
<Left>2in</Left>
</Textbox>
<Subreport Name="subreport1">
<Style />
<ReportName>Company Sales</ReportName>
<Height>4.5in</Height>
<Width>5.875in</Width>
<Top>0.125in</Top>
<Left>0.25in</Left>
</Subreport>
</ReportItems>
<Style />
<Height>6in</Height>
</Body>
<TopMargin>0.5in</TopMargin>
<DataSources>
<DataSource Name="AdventureWorks2000">
<rd:DataSourceID>75e82b3d-05fd-468b-920e-b793f54e666c</rd:DataSourceID>
<DataSourceReference>AdventureWorks2000</DataSourceReference>
</DataSource>
</DataSources>
<Code />
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="ProductCategoryID">
<DataField>ProductCategoryID</DataField>
<rd:TypeName>System.Byte</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorks2000</DataSourceName>
<CommandText>SELECT DISTINCT ProductCategoryID, Name
FROM ProductCategory
ORDER BY Name</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>0.5in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>55a44d5c-37c0-4b84-b326-e2e6aa50fb35</rd:ReportID>
<BottomMargin>0.5in</BottomMargin>
<Language>en-US</Language>
</Report>
Hi,
Did anybody from Microsoft found out about this bug? I'm still waiting for a solution! Please help! Thanks.
|||hi,
this has been cracked already....
hehe
microsoft did not bother to provide anything on this.
but we discovered a work around.
and it works awesome ...i guess this is what we do at www.snktheone. to provide solution to all the challenges faced in Reporting services development and Web development.
use the list control and then drop all the table in your subreport into this list control.
make sure List control uses the same dataregion as your subreports.
this made wonders for us..
hope i would have solved your query..
Regards,
www.snktheone.com
|||Didn't work!! I put my sub-report inside a List control and now my report is repeated multiple times! How do you make it to repeat it only once? I still get an error when exporting to Excel! Any other solutions? Thanks.|||hi mike,
i came across a situation in which i had a table and then i needed 3 subreports to be embedded inside the table. i used the subreports as not the control subreport, butinstead i used the table which i created for these sub reports and then dropped these tables in a single list control
also i made sure that all the 3 tables called the same stored procedure, which was called from the list control.
i hope it does make a diff for u.
regards
www.snktheone.com
|||In my situation there is no table! Just a simple sub-report. Anyhow, I ended up removing the header and any reference to the ReportItems from my report Footer to make it work! I believe this is the only solution to this MS bug! But, still love to see if someone come up with a solution for this glitch. Thanks.Error exporting a subreport to Excel!?
Hi All,
I have a report sonsisting of two subreports. When I export it to Excel I get an Error!! I played around with it and I found out that if I use ReportItems in my page header it will cause this error! Does anyone have any idea why? Is this a bug or there is some work around it! Thanks.We have talked to our Microsoft rep and they have told us that it is a "feature" and that is how is was designed. It is true that a subreport within a table or matrix will not export to excel. The only workaround is to have the subreport outside of the table or matrix, have the report export to pdf instead, or export the first page of the report (if there are no subreports on the first page) and run the report through excel.
Our rep is seeing if she can get the development team to change it, but I think our chances are slim.|||Thanks for the reply. My case is different! I don't have a table or matrix with subreport in it! I just have a plain page with subreports. Exporting to Excel works only if there is NO reference to any item on the report from Page Header! When I have a "ReportItems!MyText.Value" any where in the Page Header, then exporting to Excel fails!|||
What version of RS are you using? Could you send us the report files, please?
Thank you,
Nico
|||I'm using RS 2000
Try this Main Report. You need "Company Sales" sample report as your sub-report.
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>2in</Width>
<Top>0.125in</Top>
<CanGrow>true</CanGrow>
<Value>=ReportItems!MyTextBox.Value</Value>
<Left>4.125in</Left>
</Textbox>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.375in</Height>
</PageHeader>
<RightMargin>0.5in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="MyTextBox">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Height>0.25in</Height>
<Width>2.625in</Width>
<Top>5.125in</Top>
<CanGrow>true</CanGrow>
<Value>=Fields!Name.Value</Value>
<Left>2in</Left>
</Textbox>
<Subreport Name="subreport1">
<Style />
<ReportName>Company Sales</ReportName>
<Height>4.5in</Height>
<Width>5.875in</Width>
<Top>0.125in</Top>
<Left>0.25in</Left>
</Subreport>
</ReportItems>
<Style />
<Height>6in</Height>
</Body>
<TopMargin>0.5in</TopMargin>
<DataSources>
<DataSource Name="AdventureWorks2000">
<rd:DataSourceID>75e82b3d-05fd-468b-920e-b793f54e666c</rd:DataSourceID>
<DataSourceReference>AdventureWorks2000</DataSourceReference>
</DataSource>
</DataSources>
<Code />
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="ProductCategoryID">
<DataField>ProductCategoryID</DataField>
<rd:TypeName>System.Byte</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorks2000</DataSourceName>
<CommandText>SELECT DISTINCT ProductCategoryID, Name
FROM ProductCategory
ORDER BY Name</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>0.5in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>55a44d5c-37c0-4b84-b326-e2e6aa50fb35</rd:ReportID>
<BottomMargin>0.5in</BottomMargin>
<Language>en-US</Language>
</Report>
Hi,
Did anybody from Microsoft found out about this bug? I'm still waiting for a solution! Please help! Thanks.
|||hi,
this has been cracked already....
hehe
microsoft did not bother to provide anything on this.
but we discovered a work around.
and it works awesome ...i guess this is what we do at www.snktheone. to provide solution to all the challenges faced in Reporting services development and Web development.
use the list control and then drop all the table in your subreport into this list control.
make sure List control uses the same dataregion as your subreports.
this made wonders for us..
hope i would have solved your query..
Regards,
www.snktheone.com
|||Didn't work!! I put my sub-report inside a List control and now my report is repeated multiple times! How do you make it to repeat it only once? I still get an error when exporting to Excel! Any other solutions? Thanks.|||hi mike,
i came across a situation in which i had a table and then i needed 3 subreports to be embedded inside the table. i used the subreports as not the control subreport, butinstead i used the table which i created for these sub reports and then dropped these tables in a single list control
also i made sure that all the 3 tables called the same stored procedure, which was called from the list control.
i hope it does make a diff for u.
regards
www.snktheone.com
|||In my situation there is no table! Just a simple sub-report. Anyhow, I ended up removing the header and any reference to the ReportItems from my report Footer to make it work! I believe this is the only solution to this MS bug! But, still love to see if someone come up with a solution for this glitch. Thanks.Friday, February 17, 2012
Error at displaying Subreport
Hi,
i have a problem with a subreport: I created a main report and included a
subreport. The Subreport is linked with the main report over a String field.
The column in the main report has the type uniqueidentifier in the sql-server
database.
if the column in the main report has a value, the subreport works fine. but
if the value is empty, i get the error 'message: error: subreport could not
be shown' in the report and in the visual studio output window i get the
following message:
The expression for the subreport â'subreport1â' contains an error: Object
reference not set to an instance of an object.
Can someone help me how to avoid this error?Here's how I did it:
First, in the dataset of the main report, make sure that the String field
always returns a value, also when the uniqueidentifier column is empty.
Use coalesce(convert(varchar(36), column1), '0') in your query string in
stead of just column1 (supposing that the uniqueidentifier column is called
'column1', and that you are using SQL Server as data source. I dont' know
what other products support the coalesce function).
Next, use an Iif clause as query string for the subreport, like ...
= Iif(Parameters!myparam.value <> '0', "select col1, col2 from table1 where
convert(varchar(36), lookupcolumn) = '" + Parameters!myparam.value + "'",
"select 'unknown', 'unknown')
Lookupcolumn should be the name of the column that matches with the value in
your main report.
Hth,
Flip
"Bernd" wrote:
> Hi,
> i have a problem with a subreport: I created a main report and included a
> subreport. The Subreport is linked with the main report over a String field.
> The column in the main report has the type uniqueidentifier in the sql-server
> database.
> if the column in the main report has a value, the subreport works fine. but
> if the value is empty, i get the error 'message: error: subreport could not
> be shown' in the report and in the visual studio output window i get the
> following message:
> The expression for the subreport â'subreport1â' contains an error: Object
> reference not set to an instance of an object.
> Can someone help me how to avoid this error?
>
i have a problem with a subreport: I created a main report and included a
subreport. The Subreport is linked with the main report over a String field.
The column in the main report has the type uniqueidentifier in the sql-server
database.
if the column in the main report has a value, the subreport works fine. but
if the value is empty, i get the error 'message: error: subreport could not
be shown' in the report and in the visual studio output window i get the
following message:
The expression for the subreport â'subreport1â' contains an error: Object
reference not set to an instance of an object.
Can someone help me how to avoid this error?Here's how I did it:
First, in the dataset of the main report, make sure that the String field
always returns a value, also when the uniqueidentifier column is empty.
Use coalesce(convert(varchar(36), column1), '0') in your query string in
stead of just column1 (supposing that the uniqueidentifier column is called
'column1', and that you are using SQL Server as data source. I dont' know
what other products support the coalesce function).
Next, use an Iif clause as query string for the subreport, like ...
= Iif(Parameters!myparam.value <> '0', "select col1, col2 from table1 where
convert(varchar(36), lookupcolumn) = '" + Parameters!myparam.value + "'",
"select 'unknown', 'unknown')
Lookupcolumn should be the name of the column that matches with the value in
your main report.
Hth,
Flip
"Bernd" wrote:
> Hi,
> i have a problem with a subreport: I created a main report and included a
> subreport. The Subreport is linked with the main report over a String field.
> The column in the main report has the type uniqueidentifier in the sql-server
> database.
> if the column in the main report has a value, the subreport works fine. but
> if the value is empty, i get the error 'message: error: subreport could not
> be shown' in the report and in the visual studio output window i get the
> following message:
> The expression for the subreport â'subreport1â' contains an error: Object
> reference not set to an instance of an object.
> Can someone help me how to avoid this error?
>
Subscribe to:
Posts (Atom)