You create a report off a XML file which contains the attribute xml: space ="preserve" and the required white spaces are not preserved.
This issue happens when you use XML connection associated to the schema file and using the ADO.NET(XML) connection or XML connection.
Crystal Reports trims trailing white spaces. In an XML data field that only contains white space all the spaces are removed. For example, an Indent field in the XML is used as a tab space. All the spaces in this Indent field are removed by Crystal Reports.
This issue has been addressed by Fix Pack 3.5 and Service Pack 4 for Crystal Reports XI Release 2 and above.
A new string value called "TrimTrailingSpace" needs to be created under the DatabaseOptions registry key.
To edit the Registry, type regedt32 in the Run box of the Windows Start menu then:
- Open the following key 'HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions'.
- Create a new string value called TrimTrailingSpace.
- Right click on TrimTrailingSpace" and select "modify".
- Type "No" in the "Value data" field.
The above-mentioned resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall the Microsoft Windows operating system. Please back up the registry prior to making any changes.
XML, ADO.NET, white spaces, preserve, space, XSD , 7063345, ADAPT00916523, 00916523, 916523 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed