SQL Server, SQL Server Reporting Services, SSRS

SQL Server Reporting Services – Index was Out of Range Error: Solved

A quick post today in the hopes that this will save someone some hassle at some point.

If you get the following error message from Visual Studio BIDS or SQL Server Data Tools:

Index was out of range. Must be non-negative and less that the size of the collection. Parameter name: index

SSRS Error

 

This sometimes occurs because the data cache file on your local disk is out of sync with your reporting definition. The solution is to delete your report’s corresponding *.rdl.data file.

Corrupt data cache file

Once that file goes you should hopefully find the error goes away

Hope that helps someone!

Advertisements

4 thoughts on “SQL Server Reporting Services – Index was Out of Range Error: Solved

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s