Report Designer

This form is used to manage report designer data.

Application menu: General → Report Designer
Database table: report
Primary Key: id (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Name will receive focus first.
Sorting order: Records are sorted by Code.
List print template: Adjust the list print layout via General → Print Layout using Design Group = .

Additional Fields

The additional fields section contains several inputs that end users can populate:

Name
Description
Report Path
Filter
- Add Filter entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Filter.
SQL Code
The sql code input is required..
<-customfilter-> = combined filter from UI, <--filtername--> = SQL code from filter, <--filtername.operand--> = Operand filter, <--filtername.value--> = Filter value, <--filtername.value1--> = Filter value1, <--filtername.value2--> = Filter value2, <---fieldname---> = Field value from parent SQL, <--userid--> = Current User ID, <-customhaving-> = combined having from UI, <----havingname----> = SQL code from having filter, <----filtername.operand----> = Operand filter having, <----filtername.value----> = Having filter value, <----filtername.value1----> = Having filter value1, <----filtername.value2----> = Having filter value2
HTML Code
The html code input is required..
Allow Print
The allow print input can be used as a filter on the main list form..
Allow Export
The allow export input can be used as a filter on the main list form..
Active
The active input can be used as a filter on the main list form..
Default Page Setup
Type
The type input is required..
- Select one of the available options.
- Available options:
  - Official
  - Modification
Report Type
The report type input is required..
- Select one of the available options.
- Available options:
  - HTML
  - TEXT

This form is used to manage filter data.

Database table: reportfilter
Primary Key: id (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Field Name will receive focus first.
Sorting order: Records are sorted by Weight.
List print template: Adjust the list print layout via General → Print Layout using Design Group = .

The additional fields section contains several inputs that end users can populate:

Field Name
The field name input is required..
Filter Type
The filter type input is required..
- Select one of the available options.
- Available options:
  - Text
  - Decimal
  - Date Time
  - Date
  - Time
  - Toggle
  - Select
  - Auto Complete
Option
The option input is required..
Operand
The operand input can be used as a filter on the main list form..
- This field searches filteroperands. Enter a keyword after opening the dropdown, then choose one or more matching records.
Order
The order input is required..
Label
The label input is required..
Default Value
Lock Filter
Having Filter
The having filter input can be used as a filter on the main list form..
Mandatory
The mandatory input can be used as a filter on the main list form..
Sub Query (SQL filter from another SQL)