Hi,
I get the "Index out of range" error that a lot of people seem to be getting
when exporting to Excel. All other formats work fine. I have already read a
bunch of the previous posts, including Bryan Bullard's posts where he seems
to have resolved the problem.
In my case, I have tried re-installing SP1, and in all places in my report,
I am referencing items on the report like: "Fields!code.Value"
I have tried "(Fields!code.Value)" as well, but I still get the same error.
If anyone can either provide some help with fixing this, or confirm that
this is a known issue with SP1 (preferably with a link to a KB article or
something similar), I would greatly appreciate it.
Full exception:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError)
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Index was out of range. Must be non-negative and less than the size
of the collection. Parameter name: index
Thanks,
Jason RatkeHave you tied SP2? There were some fixes to the Excel renderer in SP2.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Ratke" <jayrat_not_quite_@.shaw.ca> wrote in message
news:O5WHO6CTFHA.616@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I get the "Index out of range" error that a lot of people seem to be
> getting when exporting to Excel. All other formats work fine. I have
> already read a bunch of the previous posts, including Bryan Bullard's
> posts where he seems to have resolved the problem.
> In my case, I have tried re-installing SP1, and in all places in my
> report, I am referencing items on the report like: "Fields!code.Value"
> I have tried "(Fields!code.Value)" as well, but I still get the same
> error. If anyone can either provide some help with fixing this, or confirm
> that this is a known issue with SP1 (preferably with a link to a KB
> article or something similar), I would greatly appreciate it.
> Full exception:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError)
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Index was out of range. Must be non-negative and less than the size
> of the collection. Parameter name: index
> Thanks,
> Jason Ratke
>sql
Showing posts with label exporting. Show all posts
Showing posts with label exporting. Show all posts
Wednesday, March 21, 2012
Index out of range error exporting to Excel
i've noticed that others have gotten this same error, when trying to
export to excel they get the following error, it seems it hasn't been
something dealt with, maybe because microsoft cannot reproduce it
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown.
Index was out of range. Must be non-negative and less than the size of
the collection. Parameter name: index
I am using SP2 and this error is happening both in the report designer
as well as in reporting services itself.
my situation.. i have a report.. with grouped data, inside the footer
of one of the groups i put a table, then in that nested table i have a
group, and in the group footer of that i have a line with the field i
am grouping on as well as a sum.. at first i thought maybe it had to do
with something that i hide the detail, and group header of the nested
table, but i showed that it it still failed..
one thing that made it work, was when i moved this nested table out of
the group footer of the parent table, and into the footer of the nested
table, when i did that the error no longer happened (however i need to
be able to have it in this group)..
if you need some examples maybe i can adapt my report (take out our
business specific info) and send it on to you.
Karl
the error only happens when exporting to excel..correction below:
one thing that made it work, was when i moved this nested table out of
the group footer IN THE PARENT TABLE of the parent table, and into the
footer of the PARENT
table, when i did that the error no longer happened (however i need to
be able to have it in this group)..
export to excel they get the following error, it seems it hasn't been
something dealt with, maybe because microsoft cannot reproduce it
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown.
Index was out of range. Must be non-negative and less than the size of
the collection. Parameter name: index
I am using SP2 and this error is happening both in the report designer
as well as in reporting services itself.
my situation.. i have a report.. with grouped data, inside the footer
of one of the groups i put a table, then in that nested table i have a
group, and in the group footer of that i have a line with the field i
am grouping on as well as a sum.. at first i thought maybe it had to do
with something that i hide the detail, and group header of the nested
table, but i showed that it it still failed..
one thing that made it work, was when i moved this nested table out of
the group footer of the parent table, and into the footer of the nested
table, when i did that the error no longer happened (however i need to
be able to have it in this group)..
if you need some examples maybe i can adapt my report (take out our
business specific info) and send it on to you.
Karl
the error only happens when exporting to excel..correction below:
one thing that made it work, was when i moved this nested table out of
the group footer IN THE PARENT TABLE of the parent table, and into the
footer of the PARENT
table, when i did that the error no longer happened (however i need to
be able to have it in this group)..
Subscribe to:
Posts (Atom)