SAP Knowledge Base Article - Public

1409503 - How to export wide column to txt file without line breaks

Symptom

The business requirement is to export a stored procedure report into a .txt file without extra line breaks.

Actual stored procedure data is in subreport, because main report connection is used to get values for stored procedure dynamic parameters.

Each record of the report is a single string about 1600 charcters wide. 

Cause

Export to .txt adds pagination which are extra line breaks and this option is not acceptable by business.

Export to .csv and renaming to .txt is not acceptable because subreport data could not be exported to comma separated format.

Resolution

The only solution available is:

  1. export report into MS Word non-editable (.rtf)
  2. open .rtf file in MS Word
  3. save as Plain text (.txt) and keep all default options

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0