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 "Applies to" section. This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 1.
MORE INFORMATION
Steps to reproduce the behavior
- 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.
- Start Visual Studio .NET 2003.
- On the Tools menu, click Options.
- In the Options dialog box, click International Settings under the Environment folder.
- In the right pane, click a non-English language in the Language list, and then click OK.
- Create a new report project.
- Create a report that is based on a dataset that uses a parameter query with the parameter as the DateTime data type.
- On the Report menu, point to View, and then click Preview.
- In the report parameter field, type 15.02.2004 00:00:00.
- Click View Report.
You may notice that the report parameter disappears.
Keywords: kbbug kbfix kbdatetime kbconversion kbreport kbsqlserv2000rssp1fix KB842514
