Export to excel error

Hi all,
i am not able export to excel, it is showing the below error:
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.
Index was out of range. Must be non-negative and less than the size of
the collection. Parameter name: index
----
Microsoft Reporting Services
anyone faced this porblem earlier, please let me know.
Thanks,
VinodI had the same problem with one of my reports. I found a tip on an MSDN
forum about this. I found that I had numerous formulas encased in outer
parenthesis in my report. Example:
= (ReportItems!<objectname>.Value)
= ((Fields!<objectname>.Value)/(Fields!<objectname>.Value))
Look through your report and remove any outer parenthesis. This should fix
the problem. I hope this helps.
"vinodsh_82@.hotmail.com" wrote:
> Hi all,
> i am not able export to excel, it is showing the below error:
>
> 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.
> Index was out of range. Must be non-negative and less than the size of
> the collection. Parameter name: index
> ----
> Microsoft Reporting Services
> anyone faced this porblem earlier, please let me know.
> Thanks,
> Vinod
>