Information in a TextBox control appears as "#Error" after you upgrade from SQL Server 2000 Reporting Services to SQL Server 2005 Reporting Services (911844)

The information in this article 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:

Open the problematic report project in SQL Server Business Intelligence Development Studio.
In the Visual Studio Conversion Wizard, click Finish.
Click Close when Conversion Complete appears in the Visual Studio Conversion Wizard.
In the Preview tab of the report, determine whether the problem still exists. If the problem no longer exists, go to step 5.
On the Build menu, click Deploy Project Name.

Modification Type:	Major	Last Reviewed:	1/3/2006
Keywords:	kbprb kbtshoot KB911844 kbAudDeveloper kbAudITPRO