An error message contains invalid DatasetName data when you generate a report in SQL Server 2008 Reporting Services

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:
Query execution failed for dataset DataSetName.
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.

This problem occurs when the following conditions are true:
  • Your report includes multiple data sources or datasets.
  • One of the dataset queries fails.
Note If all queries succeed, the report is produced correctly, and the error message is not displayed.
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:
SQL2008 RS "SQL Server 2008 Reporting Services" SQL2008RelNoteReportingServices

Article ID: 955508 - Last Review: 03/19/2009 22:26:38 - Revision: 2.0

Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Express with Advanced Services, Microsoft SQL Server 2008 Express

  • sql2008relnotereportingservices sql2008relnote kbquery kbreport kbexpertiseadvanced kberrmsg kbtshoot kbbug KB955508