Note: Report definitions (the content and structure of your report) can be as simple or complex as you want, however, a basic understanding of things such as key-paths, derived fields and table linking is required to maximise the effectiveness of the report results.
Menu Bar and Toolbar:
| Menu bar | Toolbar | Action |
|---|---|---|
| File > Close |  |
Closes the report. |
| File > New |  |
Click Create report to create a new report definition. |
| File > Open |  |
Click Open report to open a new report. |
| File > Properties | — | Opens the Report Text form. |
| File > Last report accessed |  |
Displays the most recently accessed reports. |
| File > Save | |
Click Save report to save the report. |
| File > Delete | — | Completely removes the report. |
| File > Report Wizard |  |
Click Report Wizard to access the Report Wizard. | Edit > Copy |  |
A complete report, selected derived fields, or all derived fields. |
| Edit > Paste |  |
A complete report, selected derived fields, or all derived fields. |
| Tools > Check |  |
Click Check report to see if it will compile without error. |
| Tools > Run |  |
Click Test run report to test run the report. At this stage you is able to enter any relevant criteria, or add the report to a batch. |
| Window | — | title, tables, format, sequence, derived, prompt, selection, update (tabs) |
| Help > Help |  |
Displays this help topic in a web browser. |
| Help > About | — | Displays version and copyright information. |
Title tab: Use this tab to set up the title and basic output parameters of the report.
Tables tab: Use this tab to set up the prime table, and up to eight secondary tables which you can access during execution.
Format tab: Use this tab to set up the report format if the output is either Print, Display or Export. Users will specify how many fields will appear on the report and how they is formatted. Column headings and field sizes may all be precisely specified and you may decide whether numeric fields are shown together with totals.
Sequence tab: Use this tab to specify the sort sequence of the output. The report may be sorted using any of the fields in any of the selected tables, including derived fields. You may also specify where breaks and sub-totals will appear on the report, together with any page breaks which may be required.
Derived tab: Use this tab page to establish new derived fields. Derived fields will normally be calculated using existing fields as building blocks. Today's date minus document date, for example, would give the age of a document.
Prompt tab: You may set up prompts which are used at run time. When the report is initiated, you must answer up to ten prompts, which are stored in the prompt fields for use in other sections of the report such as the Selection form, the Derived form or the Sequence form.
Select tab: Use this tab to enter the selection criteria for the report. The selection rules will govern which records are going to be included in the report. Up to ten items of selection can be included and then joined together using a selection logic. You can then specify whether this selection and logic combination is used to include or exclude records.
Update tab: As this facility allows table updates to take place, this option is normally only available to AUTOLINE support users and will not be covered in this on-line help.
The report is written by using a combination of the above. Each of the options is fully explained in the following topics.
Note: Title, Tables, Format and Sequence are mandatory items and the report will not compile unless they have all been completed.
Properties: Click File on the Menu Bar to access Properties. This option has the following three tabs:
Description Tab: You can type in a description of a report. This tab also enables you to see who created, updated, and last ran the report.
Menu Tab: You can add a report to a specified single menu. Visibility can be restricted by company and/or by the priority level of the user.
Note: For this to work, there needs to be a certain (00GB.runrg) file in place, because this is where these reports are held. Please contact AUTOLINE SUPPORT if this operation does not work.
Version Tab: Tick the Track Changes check box. If set, then every time you save a report, and changes have been made, you is prompted for a short description of the changes. The message along with the date and User ID are saved in the report definition. You can also format this version number into the report banner.
Note: When creating a new report ID remember that the code must always contain three characters. These characters may be numbers or letters in the range 0-9, a-z or A-Z. Acceptable codes would be 122, 3DR, PB1, or DDA. Unacceptable codes would be %GE, *1* or 1,1. Although all these latter codes are made up with three characters, they are not ordinary numbers or letters.
Select the Define report option from the REPORT GENERATOR MAIN MENU and click OK.
A blank form with the options File and Help and with eight icons is displayed.
Select File> New or alternatively click the Create report icon (an icon showing a blank page).
A Report Generator (New report) form is displayed.
Define your report, select File > Save As.
A SAVE REPORT AS form is displayed.
Enter the three letter alpha-numeric code of your new report. If you enter a report ID which does not already exist within the presently selected module then the report is saved. If, however you enter a report ID that does already exist then a REPORT EXISTS form is displayed with two buttons on it, Overwrite and Quit.
Warning: Do not set up reports that start with the letter K. The standard reports written for AUTOLINE start with the letter K and have limited access. During updates, new AUTOLINE reports could overwrite any reports on your system with the same three-character report ID.
Click Overwrite to overwrite the previously created report or click Quit to return to your Report Generator form.
Select the Define report option from the REPORT GENERATOR MAIN MENU and click OK.
A blank form with the options File and Help and with eight icons is displayed.
Select File > Open or alternatively click the Open report icon.
A REPORT DEFINITIONS form is displayed.
Select the report that is applicable to your requirements and click OK.
The Report selected is displayed.
Select the Define report option from the REPORT GENERATOR MAIN MENU and click OK.
A blank form with the options File and Help and eight icons is displayed.
Select File > Open or alternatively click the Open report icon.
A REPORT DEFINITIONS form is displayed.
Select the report that you want to delete and click OK. Select File > Delete.
A DELETE DEFINITION form is displayed with the buttons Delete and Cancel.
Warning: As the Report is completely removed from the system, make certain that you want it to be deleted. If you delete the report by mistake, its re-creation may involve a great deal of work.
Click Delete.
You first need to create reports for your campaign requirements.
To use reports in Campaigns:
On the Title tab select E - Export as the Output type and enter an Export definition.
Tip: Click the ellipsis of the Export definition field to get a list of valid export definitions that are defined in the gb_expor file.
An export definition specifies what is done with data that is exported from Autoline. The Export definition you select should be the same as that defined in the Generic CRM parameters/General Campaign parameters. If you want to select a report within the Campaigns program you will get a list of reports that work with the export definition specified in the Generic CRM parameters program.
On the Format tab you have to specify:
Note: These are important criteria for your report if you want to use them in a campaign.
On the Derived tab check that your report contains the derived field DUMMY with an entry such as 0:CRM Report SetExportFilename (rg_export$, BYREF_rg_ud exfile$). This entry ensures that the export file containing the results of the report is found by the program at run-time.
Go to CRM - Reports & enquiries and start the Campaigns program.
You are ready to run a campaign.