SAP Knowledge Base Article - Public

1219319 - Blank line appears at the end of an exported text file

Symptom

A blank line appears at the end of the text file when a report is exported to text format. This blank line can be disruptive to applications that are parsing the text file for data.

Cause

The issue has been identified and tracked under ID ADAPT00005184.

Resolution

Hot Fixes or Service Packs address this issue as indicated below. With the update(s), a registry subkey lets you add or remove blank lines that appear at the end of a text export. This subkey is called 'SuppressTrailingNewlines'. The default value of this subkey is 0 (default behavior). When the subkey is given a value of 1, blank lines won't appear at the end of a text export. The final character of data in a text file marks the end of the text file.

Note that Crystal Reports reads from the HKEY_CURRENT_USER registry tree; BusinessObjects Enterprise services, which run in the local system account, read from the HKEY_LOCAL_MACHINE registry tree.

Registry Entry Information

-------------------------------

Crystal Reports XI

------------------

Subkey: HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Export\Text\SuppressTrailingNewlines

Type: DWORD

Recognized Values: 0; 1

Default Value: 0

Creation Method: Hot Fix Installation

Crystal Reports 10

------------------

Subkey: HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\Export\Text\SuppressTrailingNewlines

Type: DWORD

Recognized Values: 0; 1

Default Value: 0

Creation Method: Hot Fix Installation

Crystal Reports 9

-----------------

Subkey: HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\Crystal Reports\Export\TextExport\SuppressTrailingNewlines

Type: DWORD

Recognized Values: 0;1

Default Value: 0

Creation Method: Hot Fix Installation

BusinessObjects Enterprise XI

-------------------------------

Subkey: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\Export\Text\SuppressTrailingNewlines

Type: DWORD

Recognized Values: 0; 1

Default Value: 0

Creation Method: Hot Fix Installation

Crystal Enterprise 10

-----------------------

Subkey: HKEY_LOCAL_MACHINE\Software\Crystal Decisions\10.0\Crystal Reports\Export\Text\SuppressTrailingNewlines

Type: DWORD

Recognized Values: 0; 1

Default Value: 0

Creation Method: Hot Fix Installation

Crystal Enterprise 9

---------------------

Subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\9.0\Crystal Reports\Export\TextExport\SuppressTrailingNewlines

Type: DWORD

Recognized Values: 0;1

Default Value: 0

Creation Method: Hot Fix Installation

Unless indicated otherwise, Critical Hot Fix updates from the FTP site have only been tested with English versions of our products.

====================

CAUTION:

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning.

====================

BusinessObjects Enterprise XI

-------------------------------

For BusinessObjects Enterprise XI, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • u2ftext.dll, version 11.0.0.1924, dated 11/7/2005 (commonXIwin_chf.zip)

 

Crystal Enterprise 10 for Windows

---------------------------------------

For Crystal Enterprise 10 for Windows, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • u2ftext.dll, version 10.0.5.603, dated 11/7/2005 (dbex10win_en.zip)
  • x3ftxen.dll, version 10.0.5.603, dated 11/7/2005 (dbex10win_en.zip)

 

Crystal Enterprise 9

-----------------------

For Crystal Enterprise 9, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • u2ftext.dll, version 9.2.1.575, dated 11/7/2005 (ce90dbexwin_en.zip)
  • u2ftext.dll, version 9.2.1.575, dated 11/7/2005 (cr90dbexwin_en.zip)

 

Crystal Reports XI

--------------------

For Crystal Reports XI, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • u2ftext.dll, version 11.0.0.1924, dated 11/7/2005 (commonXIwin_chf.zip)

 

Crystal Reports 10

--------------------

For Crystal Reports 10, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • u2ftext.dll, version 10.0.5.603, dated 11/7/2005 (dbex10win_en.zip)
  • x3ftxen.dll, version 10.0.5.603, dated 11/7/2005 (dbex10win_en.zip)

 

Crystal Reports 9

--------------------

For Crystal Reports 9, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • u2ftext.dll, version 9.2.1.575, dated 11/7/2005 (ce90dbexwin_en.zip)
  • u2ftext.dll, version 9.2.1.575, dated 11/7/2005 (cr90dbexwin_en.zip)

 

Monthly Hot Fixes and Service Packs

------------------------------------------

To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your product, search the readme file for the Track ID number (that is, ADAPTXXXXXXXX) in the latest Monthly Hot Fix or Service Pack.

Monthly Hot Fixes readmes and Service Pack readmes are available in the Downloads area of our web site.

====================

NOTE:

Issues addressed on one operating system platform at the Weekly Hot Fix level may be addressed later on multiple operating system platforms (if applicable) at the Monthly Hot Fix and Service Packs level. For example, an issue only resolved on the Windows platform in a Weekly Hot Fix may be resolved later on UNIX platforms such as IBM AIX and Sun Solaris in future Monthly Hot Fixes or Service Packs for these platforms.

To determine if these issues are resolved in a Monthly Hot Fix or Service Pack on another platform, search for the Track ID number in the readme at the locations indicated above.

See Also

For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.

For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CR CHF 5184 EXPORT TEXT TXT BLANK LINE Crystal Reports Exporting to Text Blank line , c2018532 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2