Home » Categories » Solutions by Business Process » Profiler

User-Defined Reports - Output to CSV

Datafile Software

User-Defined Reports – Output to CSV

A common use for User-Defined Reports (UDR) is to create a formatted CSV file to output records from a database (say a BACS payment list from the purchase transaction file).

When creating a CSV from a UDR definition then each row on the report creates a row on the CSV file.When outputting large data items then the maximum width of 256 characters per row can be insufficient.

This new option allows for the insertion of a special character at the end of the row which, at run-time, is interpreted to suppress the new row creation and continue with the next row of report items on the save CSV record.

Installation

If the report is configured for CSV output within the ‘Report / W.P. Disk Tools’ parameters, and configured for the new font designer, then within the data item category ‘Report Constants’ is a new option for ‘Line Continuation Marker’.

This item should be added as the last item on any one line of the UDR.

Notes

If the report is printed then this character is ignored.

This option cannot be used over a control block – on change of control block (say $HEADER to $RECORD) a new row is always inserted on the CSV.

Custom Fields
  • Release ID: 5.8
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Update System Wide References
Viewed 1409 times since Fri, Jun 29, 2012
L1 – Label Printing
Viewed 1001 times since Thu, Jun 28, 2012
G8 - Organise Pointers
Viewed 1474 times since Thu, Jun 28, 2012
Profiler - Application Landing Pages
Viewed 864 times since Thu, Jun 18, 2020
Set Application Password, Clear Application Password
Viewed 1569 times since Fri, Jun 29, 2012
Data Interchange Omit First Row from Import
Viewed 2078 times since Fri, May 27, 2016
Application Files - EDI Order Processing
Viewed 1707 times since Thu, Jul 5, 2012
User-Defined Report - Multiple Email Output
Viewed 1686 times since Mon, Jun 11, 2012
Special Custom Features
Viewed 1527 times since Thu, Jun 28, 2012
User-Defined Reports - Multiple File Output
Viewed 1594 times since Mon, Jun 11, 2012