Article ID: 955508 - View products that this article applies to.
When you use Microsoft SQL Server 2008 Reporting Services, you may receive an error message that contains invalid DataSetName data. For example, you receive an error message that resembles the following error message:
In this error message, instead of displaying the DataSetName element for the dataset in which the error occurred, the message displays a different DataSetName element.
Query execution failed for dataset DataSetName.
This problem occurs when the following conditions are true:
SQL Server 2008 Reporting Services runs all datasets in parallel. However, if any query fails, Reporting Services stops processing other datasets, and it cancels any pending dataset queries. During this exit phase, there is a window in which the resulting error message may include the wrong DatasetName element.
To work around this issue, you must manually run each query in Report Designer or in Report Builder Query Editor. By doing this, you can find the invalid query. After you fix the query, the report will be displayed correctly.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about SQL Server 2008 Reporting Services, visit the following Microsoft Web site:
Article ID: 955508 - Last Review: March 19, 2009 - Revision: 2.0