L6 - Analysis, Totals Only Report


Datafile Software

L6 – Analysis, Totals Only Report

This type of report is a cross between the summary totals report and the standard report listing allowing totals per analysis type and a percentage share also.

Screen 1 – General Report Parameters

Report Heading Title

Type in the heading for the printed report (it defaults to the menu title you gave the report). You may use up to forty characters including spaces.

ASCII Printer Control

This asks you to select one of the eight print styles configured via the CONFIG sign-on that the report is to print against. Typically you’d select ‘1’ for an 80-column report or ‘2’ for a 132-column report.

Lines Printed Per Page

Set the number of lines down the page available on the paper (typically 64 or 66 for A4) – the value entered here should match the number of lines down the page of the ASCII printer control above.

Maximum Width of Any Line

Set the number of characters allowed across the page (max 255). Again the value entered here should match the number of characters across the page as set within the ASCII printer control selected above.

Report on Continuous Stationery

Leaving blank instructs the printer to stop at the end of each page to allow the operator to insert another sheet. This option is usually set so that the report sheet feeds automatically and continues on the next page.

Omit Full Headings on Each Page

The report heading includes the title, report date, item names, etc. and can take several lines.Setting this option prints a smaller heading on second and subsequent pages allowing more room for report data to print.

Print Record Entries in Lines From / To

Usually set to be from ‘1’ to a couple of lines less than the page length you can amend these as required. You might change the starting position so that it doesn’t overlay headings on pre-printed stationery perhaps.

How Many Blank Lines Between Prints

This report will normally print totals on consecutive lines. Use this value to specify the number of blank lines between each report entry.

Analyse Item Number (Sort & Subtotal)

Select the data item which this report is going to analyse based upon – i.e. an analysis code, salesmen code etc.

Ascending / Descending Sequence

Set whether the analysis totals are reported in ascending or descending order.

Specify Search Criteria

Allow Changes

Save Changes

These options allow the entry of selection criteria that applies to the report, as well as setting whether the operator is allowed to make changes to the criteria at run-time, and whether any such changes are saved as the new default.

Screen 2 – Items to be Printed

DB

The system offers by default the primary database selected for this report (in the initial menu parameters). Confirm the database number required, <F4-Select> is available if needed.

Dataname

Enter the data item name/number required for printing; <F4-Select> is available to list the data items if required.

In addition to the items listed are three special items $RECNO (161), *CALC and *PERC. $RECNO allows print of the total number of records that match the analysis item value. *CALC allows you to create a report calculation based on the other report items, and *PERC allows you to report the percentage of the total value of a data item is down to a specific analysis value (i.e. if analysing turnover by salesperson then the percentage of turnover each salesperson is responsible for)

When you enter a ‘*CALC’ item you are asked for the report entry numbers to be included.

This calculation is based on the totals so you specify the calculation based on the line numbers you wish to be included. Note that you can only include report entries higher in the list – i.e. if this calculation is on entry 5 you can only add up entries 1-4. You also have the option to calculate an average across all records.

When you enter a ‘*PERC’ you are prompted for the data item you wish to report the percentage of.

Start Position

This always displays as ‘1’ – press <Enter> to start printing from the first character. If you wish to start printing from another character – perhaps for a date you wish to start printing from the month position – then specify accordingly. In the date example this would be starting at position 4. As another example an L-type field is 14 characters long – 9999999999.99-, if you know the value in this item is never going to exceed (say) 1000 then setting the start position as 7 will print matching the format 9999.99-.

Size

This defaults to the maximum size of the data item selected (less an adjustment for a size starting position other than 1). As per amending the start position you may not wish the full value to print so reducing the size cuts off characters from the right of the item on the print.Using the L-type field as an example reducing the size by 4 omits the decimal places (omitting the decimal point, the decimal values and the potential minus sign).

Line

For this report the line number must always be ‘1’.

Column

This relates to the column on the page where the printing of this data item will start. You should leave one space between data items – the system will, if not set for more than 1 line, default this value for you although you can amend if required. If printing over more than one line then this value must be entered manually. The column number entered cannot be greater than the width of the report set within the initial parameters.

Heading

The heading defaults to the name of the data item selected although you can overtype if required to improve reader understanding.

Col-Total?

Set if you require column totals for this item – numeric items only.

Once the report items are defined this completes the report entry. As usual you are prompted

Select ‘No’ to save the changes, ‘Yes’ to begin the definition process again, or press <ESC> to abandon the report without saving any changes.


Custom Fields

Article ID: 1222
Created On: Thu, Jun 28, 2012 at 4:36 PM
Last Updated On: Tue, Jun 20, 2023 at 5:28 PM

Online URL: https://kb.datafile.co.uk/article/l6-analysis-totals-only-report-1222.html