Microsoft KB Archive/915853

= 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 =

Article ID: 915853

Article Last Modified on 4/18/2006

-

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  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 &quot;Applies to&quot; section.

Keywords: kbsql2005rs kbtshoot kbprb KB915853

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.