After you convert a report from SQL Server 2000 Reporting Services to SQL Server 2005 Reporting Services, you receive an error message, and you cannot preview the report in Visual Studio 2005 (915853)


The information in this article applies to:

  • Microsoft SQL Server 2005 Reporting Services

SYMPTOMS

In Microsoft Visual Studio 2005, after you convert a report from Microsoft SQL Server 2000 Reporting Services to Microsoft SQL Server 2005 Reporting Services, you experience the following symptoms:
  • You cannot preview the report.
  • The data source is not displayed correctly for a cube in Microsoft SQL Server 2005 Analysis Services.
Additionally, you receive the following error message:
An Error occurred during local Report Processing. The definition of the report <Report Name> is invalid.

CAUSE

This problem occurs because Visual Studio 2005 does not use the correct data provider when you convert a report.

RESOLUTION

To resolve this problem, follow these steps:
  1. Start SQL Server Business Intelligence Development Studio.
  2. On the File menu, click Open, and then click Project.
  3. Locate and then click the report that you converted.
  4. Click OK.
  5. In Solution Explorer, double-click the report name to open the report in the Visual Studio 2005 IDE.
  6. On the Report menu, click View, click Data, and then click the ellipsis button (...) to open the Dataset dialog box.
  7. In the Dataset dialog box, click the ellipsis button (...) next to the Data Source list, click OLE DB, and then click Edit.
  8. In the Connection Properties dialog box, click Microsoft OLE DB Provider for Analysis Services 9.0.
  9. In the Enter a server or file name box, type the server name.
  10. In the Log on to the server list, click an authentication type.
  11. In the Initial catalog box, type the database name.
  12. Click Test Connection.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:4/18/2006
Keywords:kbsql2005rs kbtshoot kbprb KB915853 kbAudITPRO kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.