Home » Categories » Solutions by Business Process » Profiler |
User-Defined Reports - Multiple File Output |
Article Number: 154 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:46 PM
|
Datafile Software User-Defined Reports - Multiple File Output User-Defined Reports allow the option to create a text
file as the output rather than outputting a report to a printer. This facility is usually used to create a CSV
file to interface with other application or to create a BACS payment file to
upload to your bank. The output process
only allowed for the creation of one file from any one report – this new
feature allows you to create multiple files from the same report. To enable the creation of an output file from
a User-Defined Report you need to set the output filename within the Tools /
Report Options parameter screen. Specify the Full Pathname of the Disk File to be Created – here you set the filename of the text file to be created from the profiler user-defined report.Where the report is to create multiple files however you just specify a ‘holding’ filename here – the existence of a filename within this option enables additional options within the $SUBTOTAL report configuration. With the exception of the facility to allow the pathname to be confirmed, which is not applicable within multiple file creation, the remaining options for formatting of the text file on this parameter screen apply equally in single or multi-file creation mode. To create the multiple text files you need to set an
additional parameter to the $SUBTOTAL control block, the $SUBTOTAL block allows
you to specify a BREAK condition and a SAVEFILE setting. In general use the BREAK condition prints the
sub-total on change of a data item, in file creation mode it is used in
conjunction with the SAVEFILE setting to control where one text file ends and
the next begins. Notes This facility is only available for ‘new-style’ User-Defined Reports You can use !nnn within the pathname of the file to be created but the report will not create the folder if it does not already exist. |
Attachments
There are no attachments for this article.
|
S Screen Actions
Viewed 1258 times since Fri, Jun 29, 2012
Update Ledger from UDR (9903)
Viewed 1313 times since Fri, Jun 29, 2012
User-Defined Reports – Output as XML
Viewed 1187 times since Fri, Jul 21, 2017
Configuration - Application Settings
Viewed 1172 times since Fri, Jun 29, 2012
Database Utilities
Viewed 1270 times since Fri, Jun 29, 2012
User Defined Reports – Rotate Print Items
Viewed 851 times since Wed, Jun 13, 2012
User-Defined Report - Update Report Date to Constants
Viewed 1207 times since Mon, Nov 25, 2013
Screen Actions - Master/Detail Revision Counter
Viewed 1170 times since Mon, Nov 25, 2013
General Details
Viewed 1224 times since Thu, Jun 28, 2012
Revalidate Incoming Orders (incl prior) - EDI Order Processing
Viewed 1316 times since Thu, Jul 5, 2012
|