Index was outside the bounds of the array ,LocalReport.Render

 

Finally i can export to excel, .. i found that reporting services has a limitation.. you can´t insert a table in another table or matrix.. only List can be nested.. i try to say.. if you need to show data nested like master detail, you must use only list in your report.

-----------------

An Unexpected Error Occurred During Local Report Processing

You might see the following error message when issues occur with the local data cache (.rdl.data) file: "An error occurred during local report processing. Index was outside the bounds of an array."

Determine to which dataset the out-of-bounds index refers. Close SQL Server Business Intelligence Development Studio and delete the appropriate .rdl.data file for the dataset. Open BI Development Studio and run the report again. This recreates the cached data with the appropriate index bounds.

-----------------

Well I determined that the problem is associated with the parameters.  Any report requiring no parms runs fine.  Deleting & reentering the parms has no effect.  At least, I know I've been chasing the wrong problem.

-----------------

 

-----------------

 

http://msdn.microsoft.com/en-us/library/ms157383(SQL.90).aspx

http://social.msdn.microsoft.com/Forums/en/tfswebaccess/thread/48583335-ad79-46e4-8772-603ada35ef75

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d43476f6-9b14-4a94-838b-04f7083eee41

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/379a29e6-0b42-4330-b202-2c850f42aa89/

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/32774081-f694-4a36-a72c-ac58ceadac93/