1.3.2. Reports

Print Format

In Print Format window you edit print formats used when printing reports. The following fields are available:

• Name - corresponding to the table that contains the field.

• Description - optionally, you can add a description for the report

• Active checkbox - indicates if the print format is active in the system

• Table - the database table used for generating the report

• View Report - a type of view that is defined in the application dictionary:

  • makes the connection between view-based reports and printing format;

  • defined in the "Reports views" window and have one table as a base. The table supports SQL rules as WHERE and Order BY.

  • the view table must be the same as the one from the printing format;

  • starting with v17.04 the views can be defined only on the system - if you need to define new reports views please make a request.

• The Form checkbox - deselect to indicate that the print format is used for a List Report.

• Totals Only - select to include, in the print format, only columns that represent totals;

• Suppress Duplicate Group by - If selected, the values of the group by columns are only shown once for each unique combination. If not selected, the values are displayed on each record.

• Standard Header/Footer checkbox - select to to indicate that the standard Header and Footer is used. If you do not want to use the standard header, it must be explicitly defined. The standard Header/Footer may contain:

  • Client Name

  • Organization Name

  • Organization Tax ID

  • Org Address

• Print Paper - defines the size, orientation and margins of the document.

• Print Table Format - determines the Fonts and Colors used in the printed table.

• Printer Name - enter a specific printer for the print format. If none is entered, the default printer is used.

• Print Font - default font used f printing. The available options can be defined in the Print Font window;

• Print Color - default text color used. The available options can be defined in the Print Color window;

• Copy / Create button - allows you to use an existing Print Format or creating a new format based on a table.

Details regarding table formats, fonts and colors in Setup.

Display Order

Select the Display Order tab to add columns to the report and change their display order.

To add a column to the report, click on it in the Available Choices list and move it to the Sequence list by clicking the Right Arrow button. Changing the sequence is done by selecting the column and then clicking the up and down arrows. You can remove a column from the Sequence list by selecting it and clicking the Left arrow button.

Sort Order

Select the Sort Order tab to define sorting rules for the records in the report.

To add an item, click on the column in the Available Choices list and then move it to the Record Sort No field by clicking the Right arrow button. Changing the Record Sort No is done by selecting a column and clicking the Up and Down arrows. You can remove a column from the Record Sort No by selecting it and clicking the Left arrow button

Only insert columns which you can use for sorting, for example the Line No or the Quantity Count. Columns used here must be in the Sequence list in the Display Order tab.

Format Item

Select Format Item tab to edit the coulmns included in the report. The columns listed in the report are those included in the Sequence list, in the Display Order tab.

• Sequence - indicates order in which columns are displayed;

• Name - used to identify a report column

• Print Text - indicates the label that will be printed on top of the column.

• Suppress Null - select to prevent printing columns containing only zero's. If only one field has no value, that field will not be displayed or printed.

• Format Type - this indicates the type of item formatting. For list reports the recommended value is Field. The database Column will have to be specified.

• Barcode Type - select from the list of 20 available options. This will print a barcode representation of the selected field.

• Select ​​the Next Page checkbox if the column should be printed on a new page.

• Select a Line Alignment select the alignment for the text within a field. May be Center, Leading (left), Following(right) or None.

• Enter the Maximum Width in points (1/72nd part of an inch).If you set this value to zero (0), there will be no restriction on the width.

• Select the Fixed Width checkbox to indicate that the column has a fixed width, regardless its content.

• Enter the Maximum Height of the item, in points (1/72nd part of an inch).Zero (0) means there is no restriction on height.

• Select the One Line Only checkbox to indicate that only one line is to be printed. If the column has a width restriction and the text is wrapped over multiple lines only the first line will be printed.

• Print Color - indicates the color to be used when printing the value of the item.

• Print Font - indicates the font to be used when printing the value of the item.

• Field Group - indicates the logical group that this field belongs to (e.g. History, Amounts or Quantities)

• Next Line - if selected, this element will be printed on an additional line, underneath the column indicated by the value in "Below Column" (e.g. 1 - under the first column, 2 - under the second column);

Warning have the same functionality for reports as hilites for windows. Details in Other Actions. To define warnings within a report you may use the following fields:

• Warning Logic - enter an Sql condition for the warning. For example: @column name@=0 (means the field is equal to 0). A warning will appear on the row of the column for which the condition is true.

• Warning Line - if selected the warning will be extended on the entire row of the report. Otherwise it will only apply to the respective field..

• Warning Print Color, Warning Font, Warning Background Print Color - used to define the warning appearance;

Calculations Section - this is used to define totals for the column:

• Calculate Sum checkbox - indicates that the total amount will be calculated, provided that the field is numeric. In case of non-numeric fields this will calculate the total length of the field.

  • If the Calculate Sum checkbox is selected, the Running Total checkbox will be displayed. Select it to require a Running Total to be printed. Enter the Running Total Lines to specify the number of lines to be printed on the report before displaying a Running Total.

• Calculate Count checkbox - indicates that the total number of nonzero elements (up to the number of lines) should be calculated and printed.

• Calculate Minimum checkbox - indicates that the minimum value (string length for strings) should be determined and printed.

• Calculate Maximum checkbox - indicates that the maximum value (length string for strings) should be determined and printed.

• Calculate Mean checkbox - indicates the average value of the data should be calculated and printed (for numeric fields).If the data is non-numeric, the average length of the field (the string length for strings) will be calculated.

• Calculate Variance checkbox - indicates that the variance of numeric data should be calculated and printed. The variance is calculated as an average of the squared differences of rows of data and their mean value.

• Calculate Deviation checkbox - indicates that the deviation should be calculated for the numeric data in the field. Deviation is calculated as an average of the square root of the variance.

• Order by checkbox - indicates that the records have to be ordered by the value of this column.

• Ascending Sort Order - the records are ordered in Ascending Order of this column.

• Record Sort No - indicates the ascending sort sequence of the records. If the number is negative, the records are sorted descending.

• Group By - Grouping allows the printing of sub-totals. If a group changes, the totals are printed. Group by columns need to be included in the sort order.

Click on the Translation tab to enter a translation for your item/element. If you are printing Translated Documents you will want to translate any Text fields, Print Text and Print Label Suffixes.