Article ID: 842518
Article Last Modified on 4/3/2007
APPLIES TO
- Microsoft SQL Server 2000 Reporting Services
Bug #: 100072 (SQL Server 8.0)
SYMPTOMS
When you render a report in XML by using an XSL Transformation (XSLT) file to transform the XML data to file formats other than XML in Microsoft SQL Server 2000 Reporting Services, the <?xml version="<1.0>" ?> XML tag may be included at the beginning of the destination file.
Note The version number in the XML tag may vary depending on the version of XML that is installed on the report server.
CAUSE
This problem may occur if the report is transformed from the XML format to file formats other than XML, such as plain text or HTML. The <?xml version="1.0" ?> XML tag must be included only when the report is rendered in XML. The XML tag must not be included when you transform XML data to file formats other than XML by using XSLT files.
RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft 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 problem 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.
REFERENCES
For more information about transforming XML output, visit the following Microsoft Web site:
Keywords: kbstyle kbsqlserv2000rssp1fix kbformat kbxml kbreport kbfix KB842518
