Exporting report to excel with subreports problem

Hello,

I got a error when exporting to excel one report that has a table and in a column it has a subreport.

Is this possible to do?

What is the work around?

The error that i got it is the following.

Server Error in '/Reports' Application.
--

For more information about this error navigate to the report server on the local server machine, or enable remote errors
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors]

[Exception: An error occurred during rendering of the report.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +959
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

--

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Thank you

It is my understanding that the sub reports do NOT export to excel. I re-wrote many reports when I had to provide that functionality.

I realize this dosn't directly answer your question but rather than spend hours addressing the problem, you could re-do the report and get the result you want.

Tim

|||Well not what i wanted to hear, but thanks anyway

Export to Excel and PDF

About Excel:
I found that the content of the subreports can't export to the Excel. It
said "Subreports within table/matrix cells are ignored." Is this mean that
it is not support or there are some way to do that. the subreports is very
important to me.
About PDF:
There are Chinese content in my report that I can see it in IE but when I
export to PDF, it is all become "' ' '". I check that it is not related
to the version of Acrobat reader. I guess it is something about the
reporting server. Any idea?
Thanks,
CharlesRS is known to be very buggy with exports to both Excel and PDF. Subreports
cause lots of problems as well. Maybe this will be fixed in future versions?
"Charles Lee" <CharlesLee@.discussions.microsoft.com> wrote in message
news:8134A9FE-BEEC-418F-AB29-6BD493617B95@.microsoft.com...
> About Excel:
> I found that the content of the subreports can't export to the Excel. It
> said "Subreports within table/matrix cells are ignored." Is this mean
that
> it is not support or there are some way to do that. the subreports is
very
> important to me.
> About PDF:
> There are Chinese content in my report that I can see it in IE but when I
> export to PDF, it is all become "' ' '". I check that it is not
related
> to the version of Acrobat reader. I guess it is something about the
> reporting server. Any idea?
> Thanks,
> Charles

Export to CSV - Multiple Subreports

A little background:
We have a container report that houses 12 subreports. Only 1 subreport is displayed when executed. The other subreports are hidden via an expression. The subreports are stacked on top of one another.

The Problem:
When exported to .csv, we will get the data of the "visible report" (this is what we want), however we get 11 "Error: Subreport cannot be shown" where the other subreports are "hidden". This would be very confusing to our endusers, and I am having a hard time resolving this.

Has anyone had a similar experience?

Thanks in advance.Yes, This is By Design and expected behaviour in CSV.