Error accessing report: exporting

Showing posts with label exporting. Show all posts

Thursday, March 29, 2012

Error exporting to Excel with expression in footer

I can export to all other formats from the report viewer with no issues, but when I try to render to Excel, I get an exception:

[Exception: Object reference not set to an instance of an object.]

[Exception: An error occurred during rendering of the report.]

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

I've pinned it down to a footer cell that uses an expression to determine the TextAlign property. If I do something as simple as ="Right", I get the error. Of course, if I just use Right, there is no problem. So are expressions not supported in footer cell properties or is there possibly some fix for this?

Thanks.

The only solution would be to keep the textbox in the report body than the footer.

Shyam

|||

How can I get text to act like a page footer in the report body?

In case any MS folks are reading and want to reproduce this problem, here's a simple report that exhibits the behavior:

Code Snippet

<?xml version="1.0" encoding="utf-8"?>

<rd:DrawGrid>true</rd:DrawGrid>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

</Body>

<rd:ReportID>503a3ed2-a87d-4315-8de8-77c3ff0e807f</rd:ReportID>

<rd:DefaultName>textbox3</rd:DefaultName>

<Style>

<TextAlign>=IIf(Globals!PageNumber Mod 2 = 0, "Left", "Right")</TextAlign>

</Style>

</Textbox>

</ReportItems>

</PageFooter>

</Report>

|||

Try to handle in the value property of the textbox. For example:

IIf(Globals!PageNumber Mod 2 = 0, CStr(Globals!PageNumber) & Space(15), Space(15) & CStr(Globals!PageNumber))

Shyam

Error exporting to Excel with expression in footer

I can export to all other formats from the report viewer with no issues, but when I try to render to Excel, I get an exception:

[Exception: Object reference not set to an instance of an object.]

[Exception: An error occurred during rendering of the report.]

Thanks.

The only solution would be to keep the textbox in the report body than the footer.

Shyam

|||

How can I get text to act like a page footer in the report body?

In case any MS folks are reading and want to reproduce this problem, here's a simple report that exhibits the behavior:

Code Snippet

<?xml version="1.0" encoding="utf-8"?>

<rd:DrawGrid>true</rd:DrawGrid>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

</Body>

<rd:ReportID>503a3ed2-a87d-4315-8de8-77c3ff0e807f</rd:ReportID>

<rd:DefaultName>textbox3</rd:DefaultName>

<Style>

<TextAlign>=IIf(Globals!PageNumber Mod 2 = 0, "Left", "Right")</TextAlign>

</Style>

</Textbox>

</ReportItems>

</PageFooter>

</Report>

|||

Try to handle in the value property of the textbox. For example:

IIf(Globals!PageNumber Mod 2 = 0, CStr(Globals!PageNumber) & Space(15), Space(15) & CStr(Globals!PageNumber))

Shyam

Error exporting to Excel

SSRS 2005...report exports to all formats, but when I try to go to excel i get an error.

Unhandled exception was caught:

Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. (rrRenderingError)

Microsoft.Reporting.WebForms.ReportServerException: Stack empty

Excel has limitations that other rendering extensions do not have. Two of these limitations are from Excel - Max of 256 columns per sheet and ~65000 rows per sheet.|||

Actually that wasn't the issue...the report had about 10 columns and 3000 rows of data.

I solved it. The issue is that one of the formulas was trying to divide by zero in the denominator. The buggy behavior was that in HTML or PDF this simply renders as #Error in the textbox. But when you go to export to Excel, you don't even get that luxury. You get a nasty and ambiguous "Stack Empty" rendering error.

Actually if the resultset IS more than 65k rows it would be nice to provide an enduser with a message to that effect anyway...

sql

Error exporting subreport to excel

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
> *****************************************
>

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

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'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 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

Hello

I've developed an ASP.NET WebApplication (VS.NET 2002) with some Crystal Reports in it to report the data.

This reports are automatically exported into a pdf-File (using the Report.Export function)

To give the user the ability to change the language of the WebApp, all the texts are stored in a MS SQL 2000 Database.

I set the Text-Property of the TextObject in the Report with the following code:

Dim TextObjekt As CrystalDecisions.CrystalReports.Engine.TextObject
TextObjekt = Report.ReportDefinition.ReportObjects.Item("Text14")
TextObjekt.Text = Data.Tables(0).Rows(0).Item("TransText") & ":"

I thought this works fine, till I changed the Text in the database.

Examples:

1.) Text in the database = "Mobil 1"
--> The report works fine, the PDF is successfully created and the TextObject shows "Mobil 1:"

2.) Text in the database = "Hello Echo"
--> The Report works and the PDF is created, but the TextObject shows "Hello Ec"

3.) Text in the database = "PSA"
--> Report.Export crashes with the following error:
"Error #5 - Error in file C:\DOKUME~1\STEFAN\ASPNET\LOKALE~1\Temp\temp_c67a4fca-9bd3-4aa6-935b-0ad7a389f034.rpt:
Error found in Export-DLL : \n0\nCrystalDecisions.CrystalReports.Engine"

Has anyone an idea how I can solve this absolutly strange problem?

Thanks and best regards
GulliwahnDoes that PSA have any special charaters?
Do very Database on the Report and try againsql

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.

Error Exporting FoxPro 2.5 DOS table to SQL Server

Using the Import/Export Data Wizard, I'm trying to export a FoxPro 2.5 DOS (as dBase III) table of 15,000 records to SQL Server 2000. I keep getting this error message:
Insert Error, Column 32 ('PROG_START',DBTYPE_DBTIMESTAMP), Status 6: Data Overflow.
Invalid character value for cast specification.

I have SQL Server create the table each time I run the wizard. The new table allows NULLS in this column and I made sure to overwrite the empty date fields in the FoxPro table with blanks to make sure it would result in NULL. Originally SQL Server tried to put this as SMALL DATETIME, but when I got the message earlier, I changed it to DATETIME.

Any suggestions?hi

1) can you run a select in the fox tables, for example:
select min(col), max(col) from myTable

2) do you use any function to transform the fox date to sql date?

TIA
Abel.|||My first guess would be that you've got some data for 02/29/00, which Fox mis-interprets at 1900-02-29 (which it shouldn't accept, but it did).

If that isn't correct, the only thing I could offer would be that if you'll post the DBF (and any associated NDX, NTX, or CDX) files, I'd be willing to take a shot at converting them tonight.

-patP|||The problem is that it isn't always the same record that I'm getting the error. I'm getting this error with different tables I'm trying to convert and they all have numerous records with blank Date fields that are causing the problem.
Pat, thank you for your offer. I can try to come up with a sample data set to send to you or give you one of the smaller tables that give this error. Which would you prefer.

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,

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.

|||

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

hi mike,

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

Thursday, March 29, 2012

Error exporting to Excel with expression in footer

Error exporting to Excel with expression in footer

Error exporting to Excel

Error exporting subreport to excel

Error exporting report with subreport

Error exporting report to PDF

Error exporting report to PDF

Error exporting report

Error exporting in Excel !

Error Exporting FoxPro 2.5 DOS table to SQL Server

Error exporting a subreport to Excel!?

Error exporting a subreport to Excel!?

Error accessing report

Blog Archive

About Me