Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Carriage Return Line Feed in data produces incorrect XLS output


The utility to produce an XLS output from a report does not properly handle carriage return (0x0D) and line feed (0x0A) in the data.  This condition should be automatically be accommodated by the utility. 


As a temporary workaround we can apply a function to convert 0x0D or 0x0A to a space (' ').  But that alters the original data and needs to be manually applied to any offending column when defining the selection criteria for the report. 


For my test case a customer has supplied data that must remain consistent from import to output.  The data has multiple consecutive CR and LF.  So when looking at a hex dump I see 0D0A0D0A.  The data was supplied as an XLSX file.  It is imported via an Assemble Package to a table.  The table values are joined to a Target Report that is published.  When viewing the results in My Reports the data is accessed and the file is downloaded.  Any data containing CRLFCRLF results in the row being split to a new row in the downloaded XLS file.

  • Guest
  • Jan 31 2017
  • Likely to Implement
  • May 12, 2017

    Admin response

    Is this for the Reports in dspMonitor only?

  • Attach files
  • +2