The Title tab is the first tab on the Report Generator form. You must complete all the fields in order to set up a report definition correctly. You can use the option again at a later stage in order to modify the definition.
Group boxes
Title: Title for the report. The title appears on the top line of a printed report, at the top of the screen on a display report, and on the search window when searching for reports.
Tip: Put the three-character report ID at the start of the title in order to aid report identification at a later stage.
Output type: Output method you require for this report. The following methods are available from the drop-down menu:
P: Print the results in hard copy. The printer device selected may include a spool printer if required. Print type reports can also be displayed or exported in HTML format.
D: Display the report electronically without printing it (but can also be printed or exported in HTML format). View the whole report by means of a scroll bar.
Note: Display output limits the report format to 106 columns.
C: Chart output, which may also be converted into a graph.
E: Exported to either a UNIX table, an NT text table, a DOS csv table, or directly to Excel for use by other software applications. You are asked which export facility is to be used. The Export Parameters field Ellipsis search button displays all the available export definitions. For Microsoft Excel select or type in the word excel in lower-case.
Note: The export facilities are set up in the System Utilities - Management menu - Export facilities menu option.
L: Directs the output to Format Stationery. Format stationery is a text only application, mainly used for formatted output such as invoices or statements.
W: Marketing Letter Writer. An export facility must be utilised to create a print table for the letter to work from.
R: RTF (Rich Text Format). Available within the Format Tab where simple page layouts can be designed in an editor similar to WORDPAD for letter or form style output. Information from selected tables can be merged in with the text, either individually or as columnar output.
Note: WORDPAD is found in Microsoft Windows 95 and above.
M: Electronic mail system. In this case it is up to the recipient to display or print the report. This function only works when the ADP electronic mail system has been correctly installed. You have to set up various fields in the Derived tab in order to allow the report to be sent to the correct destination.
Note: Electronic mail output is used for output of small amounts of data. It is not intended for large reports.
H: HTMLformat (Hyper-Text Mark-up language). This is the standard file format used when viewing information on any Internet browser. The Export Parameters field Ellipsis search button displays all the available export definitions.
Note: HTML has to be configured correctly in the Export facility. Please ask your ADP consultant for advice.
B: The Output type of B allows you to create a format with multiple labels across and down the page.
S: SMS (mobile phone text message). Only available if the UserEnv.txt file is suitably configured on your system. For the report to work correctly it is necessary for print manager to be installed and for the server to have a suitable modem attached with a SIM card installed. Please consult your Account manager or ADP consultant for full details.
Note: There is a 160-character limit on SMS text messages.
N: No output. Normally this option is not used. lt is designed for use by AUTOLINE software support staff to process table updates.
Spacing: Determines the line-spacing of the report. One of the following:
S: Single-line format. Prints or displays the report on each line of the page.
D: Double-line format. Prints or displays the report on every other line of the page.
M: Multi-line format. Allows each record to be printed in a multi-line format, rather than the conventional one line for record output. You can select the number of lines to use for the page heading line, the detail line, the sub-total heading, sub-total line and grand total line. After selecting multi-line format the parameter fields become available for editing.
Note: You can also export multi-line formats to Excel.
Totals only: Select this to print or display all sub-totals and totals, but show no lines of detail.
Suppress zeroes: Select this to prevent the printing of a line of data if all of the numeric fields on the line set to be totalled have a value of zero. This function works on single, double or multi-line format reports.
Detail selection: Select this for drill-down detail.
Note: Only available if the Output type is either Display or Chart. Enables you to click a cell on a chart or on a sub-total line, and drill into a second report. Up to five of these drill actions are allowed for each report.
Priority to use: Minimum priority level users need to gain access to this report, or to run it. It will default to zero on a new report. You may set any priority level up to and including your own priority level.
Kerridge product: Only accessible by ADP.
Update file: Only accessible by ADP.
Special overlay: Only accessible by ADP.
Export definition: Available only when you select the output type Export or HTML in the Format part of the tab.
Export headings: Available only when you select the output type Export in the Format part of the tab. If selected, the headings on the format tab are exported.
Tip: Use the
Ellipsis button to search for the export facility that you require, or if you know the name, type it in.
Note: The export facilities are set up in the System Utilities - Management menu - Export facilities menu option.