Urgent Sub Report Help Needed
I have an urgent need to solve this issue.
I have a report that has two sets of six sub reports. Here is what I have:
Main Report
Subreport1A
Subreport2A
Subreport3A
Subreport4A
Subreport5A
Subreport6A
Subreport1B
Subreport2B
Subreport3B
Subreport4B
Subreport5B
Subreport6B
I want to have a page break between the first set and the second set. The last subreport of the first set, Subreport6A, has a pagebreak at end = true, so it should break. The problem is that when I export to Excel I am getting one sheet for the 12 subreports.
[638 byte] By [
rs12345] at [2007-12-23]
I found the idea for the rectangle as well. It works. Here is what I have.
Main Report -- Gives region totals
Subreport1
Rectangle
Subreport2
Rectangle
Subreport3
Rectangle
Subreport4
Rectangle
Subreport5
Rectangle
Subreport6
Rectangle
Subreport7
Each Subreport is a series of other sub reports that give detail of each region. Each rectable has a pagebreak at end. It does not look really nice when viewing in the report manager -- However it does put each region on a separate Excel spreadsheet when the report is emailed and that was the desired result.
This report exports to Excel fine in VS.Net. I'm having issues exporting from the Report Manager. The error log is below. I'm at a dead end. I'm hoping someone has an idea to try.
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) +958 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.42
