| Home » Categories » Solutions by Business Process » Profiler |
User-Defined Reports - Output to CSV |
|
Article Number: 320 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:43 PM
|
|
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. InstallationIf 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. |
Attachments
There are no attachments for this article.
|
Location of Files / Expand Settings
Viewed 1714 times since Thu, Jun 28, 2012
G2 – Extract Records between Database Files
Viewed 964 times since Thu, Jun 28, 2012
User-Defined Reports - Default Printer Settings
Viewed 1702 times since Mon, Jun 11, 2012
Launch Web Browser from User-Defined Report
Viewed 2829 times since Tue, Jun 12, 2012
Operational Overview - EDI Order Processing
Viewed 1638 times since Thu, Jul 5, 2012
L1 – Label Printing
Viewed 1100 times since Thu, Jun 28, 2012
Update Ledger from UDR (9903)
Viewed 1777 times since Fri, Jun 29, 2012
System Maintenance - EDI Order Processing
Viewed 1785 times since Thu, Jul 5, 2012
G6 Tidy Index Overflow Area
Viewed 1744 times since Thu, Jun 28, 2012
Forecast Dates - Additional Options
Viewed 3023 times since Fri, May 27, 2016
|

