Microsoft KB Archive/842514

= FIX: The report parameters may not appear correctly when you preview a report in a non-English version of Report Designer =

Article ID: 842514

Article Last Modified on 7/7/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services

-



Bug #: 144826 (SQL Server 8.0)



SYMPTOMS
In Microsoft SQL Server 2000 Reporting Services, when you try to preview a report in Report Designer after you enter the input values for the report parameters, you may notice that the report parameters disappear or that the report parameters are unexpectedly converted to the English format, and the report may not render correctly.

This problem occurs when all the following conditions are true:
 * The report parameters are the Date/Time data type or the Float data type.
 * You create the report by using a non-English version of Report Designer like the German version of Microsoft Visual Studio .NET 2003.
 * The non-English version of Visual Studio .NET 2003 is installed on a computer that has an English version of Visual Studio .NET 2003 installed on it.

You may notice this behavior even after you set the Regional and Language Options on your computer that correspond to the non-English version of Visual Studio .NET 2003.



RESOLUTION
To resolve this problem, obtain the latest service pack for SQL Server 2000 Reporting Services. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section. This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 1.



Steps to reproduce the behavior

 * 1) Log on to a computer that has the English version of Visual Studio .NET 2003 and a non-English version of Microsoft Visual Studio .NET 2003 installed on it.
 * 2) Start Visual Studio .NET 2003.
 * 3) On the Tools menu, click Options.
 * 4) In the Options dialog box, click International Settings under the Environment folder.
 * 5) In the right pane, click a non-English language in the Language list, and then click OK.
 * 6) Create a new report project.
 * 7) Create a report that is based on a dataset that uses a parameter query with the parameter as the DateTime data type.
 * 8) On the Report menu, point to View, and then click Preview.
 * 9) In the report parameter field, type 15.02.2004 00:00:00.
 * 10) Click View Report.

You may notice that the report parameter disappears.

Keywords: kbbug kbfix kbdatetime kbconversion kbreport kbsqlserv2000rssp1fix KB842514

-

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

© Microsoft Corporation. All rights reserved.