Besides the standard fields, the user-defined fields are also used in report layouts.
The "New" option of the Defined Fields list accessed by clicking the Defined Fields button is used to define new fields for the report. The name, type and usage type information of the field to be used in the report is entered in the Definition window.
The user defined fields may have the
- Text
- Number
- Date
- Time
- Currency
types.
The information recorded on the Defined Field window varies depending on the selected type.
The usage type of the information in the defined field within the report is specified in the Parameters, Format and Location tabs of the Field window accessed by selecting the New -> Data Field option located in the right mouse button menu of the New Report Design window. The options displayed here also depend on the field type and the selection made on the display section. The Type and
The Type and Name fields of the Defined Field window indicate the type and name of the defined field. Each field definition is saved with a different name. The currency information is saved in the Currency field for the fields of Number and Currency types.
Definition
The Type and Name fields of the Defined Field window indicate the type and name of the defined field. Each field definition is saved with a different name. The currency information is saved in the Currency field for the fields of Number and Currency types.
Formula Usage
The most important feature of the user defined field is that these fields can be used in formulas together with the standard fields defined in the application through functions and arithmetical operations, and that the results can be inserted in a field.
In this way, the information inserted from the records and the transactions performed on the application sections can be reported with the requested format and information. The relation to be established for the information to be inserted in the defined field is recorded in the Formula field.
The Formula window accessed by clicking the Formula field consists of three panes. The Formula pane displays the formula definition indicating how the information to be inserted in the report will be calculated. The middle pane displays the icons of the arithmetical operations that can be used in the formula, while the bottom pane lists the Standard Fields, User Defined Fields and Functions as columns.
The requested fields and functions are used together and associated with arithmetic operations and saved.
The additional info definitions and additional data fields can also be used in the formula definition along with the fields and functions. The database extensions and data fields are listed and a selection is made.
Function List | |
1 | MIN(number, number) |
2 | MAX(number, number) |
3 | MOD(number, divisor) |
4 | DIV(number, divisor) |
5 | ABS(number) |
6 | VAL(text) |
7 | DATE(day, month, year) |
8 | AFTER(days, year) |
9 | DAYS(firstdate, lastdate) |
10 | DAYOF(date) |
11 | MONTHOF(date) |
12 | YEAROF(date) |
13 | WDAYOF(date) |
14 | ROUND(number) |
15 | TRUNC(number) |
16 | ERATE(date, currency) |
17 | CREATE(date, base curr., base rate, dest. curr) |
18 | STRPOS(search string, string) |
19 | FLOOR(number) |
20 | CEIL(number) |
21 | FRAC(number) |
22 | EXP(number) |
23 | LN(number) |
24 | POWER(base, exponent) |
25 | SQR(number) |
26 | SQRT(number) |
27 | COS(number) |
28 | SIN(number) |
29 | TAN(number) |
30 | STRLEN(text) |
31 | WEEKNUM(year start, first week, date) |
32 | STR(number) |
33 | DATESTR(date, format) |
34 | MONTHSTR(month) |
35 | WDAYSTR(weekday) |
36 | NUMSTR(number, decimals, format) |
37 | TIMESTR(time, format) |
38 | RESXSTR(list resource, tag) |
39 | RESSTR(string resource) |
40 | CRESSTR(list id., tag) |
41 | SUBSTR(text, start, length) |
42 | UPCASE(text) |
43 | LOWCASE(text) |
44 | TRIMSPC(text, option) |
45 | JUSTIFY(text, direction, fill, length) |
46 | WRNUM(language, numer, part) |
47 | IF(expression, value1, value2) |
1 | MIN(number, number) | Takes the minimum number of the function. |
2 | MAX(number, number) | Takes the maximum number of the function. |
3 | MOD(number, divisor) | Divides the higher value into the lower value and takes the remainder. |
4 | DIV(number, divisor) | Divides the number to the second and writes the result. |
5 | ABS(number) | Gives the absolute value of a number. |
6 | VAL(text) | Converts the text into a numeric value. |
7 | DATE(day, month, year) | Converts date format according to day, month and year info. |
8 | AFTER(days, year) | Gives the attained date after given number of days. |
9 | DAYS(firstdate, lastdate) | Gives number of days between two dates. |
10 | DAYOF(date) | Gives date of the day. |
11 | MONTHOF(date) | Gives the current month. |
12 | YEAROF(date) | Gives the current year. |
13 | WDAYOF(date) | Gives the date that shows which day of the week is the given date. |
14 | ROUND(number) | Rounds the given number to nearest integer. |
15 | TRUNC(number) | Eliminates the decimal characters if the number within parenthesis is decimal. |
16 | ERATE(date, currency) | Brings the exchange rate of a currency for a specific date. |
17 | CREATE(date, base curr., base rate, dest. curr) | Brings cross exchange rate value of the f. currency. |
18 | STRPOS(search string, string) | Gives the sequence of a character in a text. |
19 | FLOOR(number) | Rounds the decimal number to downwards |
20 | CEIL(number) | Rounds the decimal number upwards. |
21 | FRAC(number) | Takes the decimal value of the number and rounds it to nearest value. |
22 | EXP(number) | The opposite of the logarithm (ln) function. |
23 | LN(number) | The logarithm function. According to "e" base it transforms logarithm function result to nearest integer. |
24 | POWER(base, exponent) | Gives specified power of a number. |
25 | SQR(number) | Gives the square of a number. |
26 | SQRT(number) | Gives the square root of a number. |
27 | COS(number) | Gives the cosine of a number (given as radiant). |
28 | SIN(number) | Gives sine of a number(given as radiant). |
29 | TAN(number) | Gives tangent of a number (given as radiant). |
30 | STRLEN(text) | Gives the total number of characters of selected text; its type is number. |
31 | WEEKNUM(year start, first week, date) | Gives the week number of the related year. First week parameter works as in MS Outlook. |
32 | STR(number) | Writes field defined as numbers in text format. |
33 | DATESTR(date, format) | Transforms the given date and writes it in demanded format. |
34 | MONTHSTR(month) | Writes the month of the given number as text. |
35 | WDAYSTR(weekday) | Writes the day of the given number as text. |
36 | NUMSTR(number, decimals, format) | Transforms the given number to text and writes in demanded form. |
37 | TIMESTR(time, format) | Transforms the given hour to text and writes in demanded form. |
38 | RESXSTR(list resource, tag) | Brings the list source and its tag of LRF extended files of resource folder. |
39 | RESSTR(string resource) | Brings the texts in LRF extended files of resource folder. |
40 | CRESSTR(list id., tag) | |
41 | SUBSTR(text, start, length) | Used to write the selected text in a definite length by starting from a definite character. |
42 | UPCASE(text) | Writes the text with capital letters. |
43 | LOWCASE(text) | Writes the text with lower cases. |
44 | TRIMSPC(text, option) | Deletes the spaces at the beginning and/or at the end of the selected text). |
45 | JUSTIFY(text, direction, fill, length) | Writes the selected text in demanded length. Fills the spaces with demanded characters in text. |
46 | WRNUM(language, numer, part) | Transforms a number's integer or decimal digits to writing form in specified language. |
47 | IF(expression, value1, value2) | Specifies values by defining conditions. When "If (p1>1000, 10,5)" is typed, if p1 is bigger than 1000 the value is used as 10; otherwise as 5. |
To update the Defined Fields list, the "Update" button is clicked while the definition line to be updated is selected. The changes made to the definition information are recorded by clicking the "Save" button.
To delete a field definition from the Defined Fields list, the "Delete" button is clicked while the definition line to be deleted is selected. The Del key can also be used for this operation.
The defined fields are inserted into the desired section of the report using the New -> Data Field option. The field type is specified as defined field in the type / content tab of the field window accessed by making the new selection. The defined fields are listed and the appropriate definition is selected and transferred into the report.
The font and style to be used in the field is specified on the Format tab of the Field window. The following properties are specified on the Format tab:
The information saved in the Display section varies depending on the field type (text, number, date, hour, currency, etc..)
The Font section is used to specify the font type to be used. The appropriate font is selected by clicking the arrow icon and the font size is specified on the Size field. The other font properties and defaults to be applied (compressed, underlined, color) are specified on the Fonts window accessed by clicking the "..." icon.
The Color section is used to specify the background color of the field. The color options are listed by clicking the arrow sign and the requested color is selected. In addition to selecting from defined colors, new colors can be defined and saved on the Color window accessed by clicking the palette window.
If the type of the defined field is Text, the Text field of the Format tab contains the Left Justified, Right Justified and Centered options. The Text type information of the report is displayed according to the selection made in this field. The font type, size and color are specified on the Font field, while the Color section is used to specify the color of the defined field.
The position of the field on the report is specified on the Location tab and the parametric properties are specified on the Parameters tab.
If the type of the defined field is Number, the display method of the numeric information is specified on the Format tab. The digit separations and the display method of fractional amounts and percentages are displayed and selected on the amount fields. The position of the Number type information within the field is specified in the Text field and the font type, size and color are specified on the Font field, while the Color section is used to specify the color of the defined field. The position of the field on the report is specified on the Location tab and the parametric properties are specified on the Parameters tab.
If the type of the defined field is Date, the display method of the date information is specified on the Format tab. The date can be displayed as day/month/year or month/day/year, or the name of the day can be displayed. The display method to be used is selected and transferred into the field. The position of the Date type information within the field is specified in the Textfield and the font type, size and color are specified on the Font field, while the Color section is used to specify the color of the defined field. The position of the field on the report is specified on the Location tab and the parametric properties are specified on the Parameters tab.
If the type of the defined field is Hour, the display method of the hour information is specified on the Format tab. The display method to be used is selected and transferred into the field. The position of the Hour type information within the field is specified in the Text field and the font type, size and color are specified on the Font field, while the Color section is used to specify the color of the defined field. The position of the field on the report is specified on the Location tab and the parametric properties are specified on the Parameters tab.
If the type of the defined field is Currency, the display method is specified on the Format tab. The display method to be used is selected and transferred into the field. The position of the Currency type information within the field is specified in the Text field and the font type, size and color are specified on the Font field, while the Color section is used to specify the color of the defined field. The position of the field on the report is specified on the Location tab and the parametric properties are specified on the Parameters tab.