Error with expoting to Excel

I got the following error when exporting a report to Excel
Reporting Services Error
----
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
An unexpected error occurred in Report Processing. (rsInternalError) Get
Online Help
Object reference not set to an instance of an object
--
Amila IndikaI got the same error.
I have a table in report body and grouped by, say, ColA.
In the page footer, a textbox refererences ColA by
First(ReportItems!ColA.Value).
When I export the report in PDF format, it works fine, but I got the error
when exporting to EXCEL format.
Any solution? Thanks
"Amila Indika" wrote:
> I got the following error when exporting a report to Excel
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> An unexpected error occurred in Report Processing. (rsInternalError) Get
> Online Help
> Object reference not set to an instance of an object
> --
> Amila Indika
>

Error while exporting to Excel SP2

All of my reports work fine, while trying to export them to excel. But I'm
not able to render one Report to Excel. The Report contains some Lists and
the visibility depends on some(9) parameters. The rendering works fine with
all other Rendering-Formats. It seems that the Reporting Service (thread)
aborts and restart again. Is it possible that the Service quits because of
the Memory Limit (160 MB)? In the IIS I have created a seperate AppPool for
the Server and the Web-Service.
Because other services running on the Server, I put the memory limit for the
AppPool to 250 MB.
This is the Error while processing the Report via Report-Manager and/or
Web-Service:
Operation is not valid due to the current state of the object
rrRenderingError 400
Microsoft.ReportingServices.ReportRendering.ReportRenderingExceptionI had the same problem until I installed RS SP2 on my workstation
which is where I was actually receiving the error (Visual Studio 200
Report Designer, Layout view). Now it works great

Error While Exporting to Excel

Hi Group,
When i tried to export my report to excel it throws me this error
Error: Index was out of range.Must be non-negative and less than the size of
the collection.Parameter name:index.
My Report contains subreport in one column.I Placed my subreport in
rectangle tool
and placed the rectangle in the table cell.
can any only help me how to resolve this error.In excel renderer, subreport and data regions inside table / matrix cells
are not supported.
Anyway, you should be able to render the report with a nice error message in
place of subreport. Could you send us the report, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> Hi Group,
> When i tried to export my report to excel it throws me this error
> Error: Index was out of range.Must be non-negative and less than the size
of
> the collection.Parameter name:index.
> My Report contains subreport in one column.I Placed my subreport in
> rectangle tool
> and placed the rectangle in the table cell.
> can any only help me how to resolve this error.|||Hi Cristache,
In my Previous Discussion with CHRIS HAYS he Said
Subreports are not currently supported inside tables/matrixes in the Excel
renderer.
You could either convert your table to nested lists (this approach won't
work for matrix) or you could place the contents of your subreport into a
rectangle in the table/matrix cell. Note: This second approach involves
rewriting your query to join the main query data with the subreport query
data.
Now My Problem is I am not able to render the report to xls.But i have
another report with same concept and able to render to xls and values are
displaing in subreport column.But the other report what i was taking is
giving this error
Error: Index was out of range.Must be non-negative and less than the size of
the collection.Parameter name:index. And report is not rendering.
So how do i send the report to you.
"Nico Cristache [MSFT]" wrote:
> In excel renderer, subreport and data regions inside table / matrix cells
> are not supported.
> Anyway, you should be able to render the report with a nice error message in
> place of subreport. Could you send us the report, please?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
> message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> > Hi Group,
> >
> > When i tried to export my report to excel it throws me this error
> > Error: Index was out of range.Must be non-negative and less than the size
> of
> > the collection.Parameter name:index.
> >
> > My Report contains subreport in one column.I Placed my subreport in
> > rectangle tool
> > and placed the rectangle in the table cell.
> >
> > can any only help me how to resolve this error.
>
>|||I have the same error message
In my report I use 9 tables
all the rendering goes ok, but when I export it to excell I get the message
"Nico Cristache [MSFT]" wrote:
> In excel renderer, subreport and data regions inside table / matrix cells
> are not supported.
> Anyway, you should be able to render the report with a nice error message in
> place of subreport. Could you send us the report, please?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
> message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> > Hi Group,
> >
> > When i tried to export my report to excel it throws me this error
> > Error: Index was out of range.Must be non-negative and less than the size
> of
> > the collection.Parameter name:index.
> >
> > My Report contains subreport in one column.I Placed my subreport in
> > rectangle tool
> > and placed the rectangle in the table cell.
> >
> > can any only help me how to resolve this error.
>
>

Error While Exporting Data From a report which have SubReport. - D

Hi all,
i am facing a typical problem in SSRS.I have a report which have a
subreport.Everything working fine if i have data on my main report and my sub
report also,but if i don't have any data then report is giving a error when i
am trying to EXPORT it in some version(.xls or .xml etc).
Really i could not able to understand the reason behind this problem.
I am looking fwd for your quick reply rgd the same.
Thanks in advance.
DibakarOn Feb 26, 4:54 am, Dibakar <Diba...@.discussions.microsoft.com> wrote:
> Hi all,
> i am facing a typical problem in SSRS.I have a report which have a
> subreport.Everything working fine if i have data on my main report and my sub
> report also,but if i don't have any data then report is giving a error when i
> am trying to EXPORT it in some version(.xls or .xml etc).
> Really i could not able to understand the reason behind this problem.
> I am looking fwd for your quick reply rgd the same.
> Thanks in advance.
> Dibakar
I have come across this issue when I have not had data on my subreport
before. Have you tried returning an empty row to the main report (from
the subreport) yet?
Enrique Martinez
Sr. SQL Server Developer|||Yes, i am doing it.but still the same problem remains.
I don;t know how to solve it?Pls help
"EMartinez" wrote:
> On Feb 26, 4:54 am, Dibakar <Diba...@.discussions.microsoft.com> wrote:
> > Hi all,
> >
> > i am facing a typical problem in SSRS.I have a report which have a
> > subreport.Everything working fine if i have data on my main report and my sub
> > report also,but if i don't have any data then report is giving a error when i
> > am trying to EXPORT it in some version(.xls or .xml etc).
> >
> > Really i could not able to understand the reason behind this problem.
> >
> > I am looking fwd for your quick reply rgd the same.
> >
> > Thanks in advance.
> >
> > Dibakar
>
> I have come across this issue when I have not had data on my subreport
> before. Have you tried returning an empty row to the main report (from
> the subreport) yet?
> Enrique Martinez
> Sr. SQL Server Developer
>