The data set name is missing in the data region 'DataSetName'

reporting-services, sql-server-2005

Solution

The issue was that when the report had elements setup using the first data set I'd defined when the report was created. Adding an additional data set reset the DataSetName value to be blank. In this case for my Table but it could be for a List, etc.

To correct:

- Open the report in SQL Server Business Intelligence Development Studio (AKA Visual Studio)

- View the object details in the Properties Window (View > Properties Window or press F4)

- Check the DataSetName value (under the Data section)

- Update the value to point to the correct Data Set

Problem

Original source