Any expression, for example Globals!PageNumber will do.
In my original report I had a lot of expressions referencing Code and
Parameters, but not the datasource.
I removed everything, now there is only header and footer with some
textboxes left.
As soon as there is any expression other than a literal in one of the
textboxes, the rendering exception occurs.
It's strange, because in other reports there is no problem with expressions
like Globals!PageNumber and rendering to excel.
Robert
[quoted text, click to view] "Yoshi" wrote:
> What type of expression are you using in the Report Header or Footer?
>
> I can't be data from a datasource.
>
> Yosh
>
>
> "rweiss" <rweiss@discussions.microsoft.com> wrote in message
> news:80FD9EC9-F2DD-46A3-8396-A4787E005977@microsoft.com...
> > Rendering a report to Excel (using Viewer-Export or SOPA-API), I get the
> > following error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Onlinehilfe
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Object reference not set to an instance of an object.
> >
> > Rendering to any other format works fine.
> >
> > What I found out:
> > The error happens only, if in the report header or footer is a textbox
> > with
> > any expression e.g. Globals!PageNumber. If I remove all expressions,
> > rendering to excel works fine.
> >
> > But I need this expressions !
> >
> > Any solution or workaround available ?
> >
> > Robert Weiss
>
>
