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.
The Title tab contains the following fields:
The report title, which can be up to thirty characters long
The output method of the report
The format spacing
The Totals only, Suppress zeroes and Detail selection check boxes
The minimum priority that a user must have to access the report
The Title tab is divided up into four sections:
Title: Title for the report. The title will appear 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. A useful technique is to 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 for this report. The following methods are available:
Tip: Select the
drop down , adjacent to the Output type field, in order to view and select from all the available output types.
P: The report is to be printed on the printer device selected when the report is executed. This may include a spool printer if required. Print type reports can also be displayed or exported in HTML format at run-time.
D: The report is to be displayed on the screen. You may view the report by means of a scroll bar. You should be aware that this will limit the report format to 106 columns. Display type reports can also be printed or exported in HTML format at run-time.
C: The report is to be displayed in the form of a chart output, which may also be converted into a graph.
E: The report will be exported. The output can be exported to either a UNIX table, an NT text table, a DOS csv table, or directly to Excel for use by other software applications such as spreadsheet or word processing. If this option is selected, then the Export facility box is invoked and you will be asked which export facility is to be used. In the Export Parameters part of the tab, type the name in or click the Ellipsis search button to display 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: This will direct the output to Format Stationery. Format stationery is a text only application, mainly used for formatted output such as invoices or statements.
W: The Marketing Letter writer. An export facility must be utilised to create a print table for the letter to work from.
R: The output will be available within the Format Tab where simple page layouts can be designed in an editor similar to WORDPAD for letter or form style output in RTF (Rich Text Format). 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: The output will be sent to the electronic mail system. In this case it will be up to the recipient to either just display it or print it. This function will only work when the ADP Electronic mail system has been correctly installed. You will 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: The output is to be displayed in HTML format (Hyper-Text Mark-up language). This is the standard file format used when viewing information on any Internet browser. If this option is selected, then the Export definition box is made available for you to choose which export facility is to be used (normally HTML). Type the name in or click the Ellipsis button to display all the available export facilities.
Note: This option will not work correctly unless html is configured correctly within the Export facility. Please ask your ADP consultant for advice.
B: The Output type of B will allow you to create a format with multiple labels across and down the page.
S: The output is to be sent to the mobile phone number(s) specified within the report. The output will be of the form of SMS text(s). This option is visible only if the UserEnv.txt file is suitably configured on your system. For the report to work correctly it is necessary for Kprint to be installed and for the Kprint 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 will be generated. You will not normally use this option. lt is designed for use by AUTOLINE software support staff only, normally when a report is performing a table update during processing.
Spacing: Determines the line-spacing of the report. One of the following:
S: Single-line format. This will print or display the report on each line of the page.
D: Double-line format. This will print or display the report on every other line of the page.
M: Multi-line format. This will allow each record to be printed in a multi-line format, rather than the conventional one line for record output. The multiple line output allows you to 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. When this option is selected, the multi-line format parameter fields become available for edit.
Note: You can also export multi-line formats to Excel.
Totals only: This check box, if selected, will print or display all sub-totals and totals, but show no lines of detail.
Suppress zeroes: This check box, if selected, will prevent the printing of a line of data if all of the numeric fields on the line which are set to be totalled, have a value of zero. This function will work on single, double or multi-line format reports.
Detail selection: If this check box is selected, the report will be set for drill-down selection.
Note: This option is only available if the Output type is either Display or Chart. It will enable you to click on a cell of 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.
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.
