Microsoft KB Archive/911844

= Information in a TextBox control appears as &quot;#Error&quot; after you upgrade from SQL Server 2000 Reporting Services to SQL Server 2005 Reporting Services =

Article ID: 911844

Article Last Modified on 1/3/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Reporting Services

-



Bug #: 403829 (SQLBUDT)

Bug #: 405484 (SQLBUDT)

Bug #: 405158 (SQLBUDT)



SYMPTOMS
After you upgrade from Microsoft SQL Server 2000 Reporting Services to Microsoft SQL Server 2005 Reporting Services, you notice that the information in a TextBox control appears as #Error.



CAUSE
This issue occurs when you define a report parameter and then pass the Label property of the parameter to the Text property of a TextBox control.

In SQL Server 2000 Reporting Services, the Label property is compiled as a string. In SQL Server 2005 Reporting Services, the Label property is compiled as an object. SQL Server 2005 Reporting Services cannot recognize the string formatting of the Label property from SQL Server 2000 Reporting Services.



WORKAROUND
To work around this issue, republish the problematic report into the new environment. To do this, follow these steps:
 * 1) Open the problematic report project in SQL Server Business Intelligence Development Studio.
 * 2) In the Visual Studio Conversion Wizard, click Finish.
 * 3) Click Close when Conversion Complete appears in the Visual Studio Conversion Wizard.
 * 4) In the Preview tab of the report, determine whether the problem still exists. If the problem no longer exists, go to step 5.
 * 5) On the Build menu, click Deploy  .

Keywords: kbtshoot kbprb KB911844

-

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

© Microsoft Corporation. All rights reserved.