Reports

• Report code (field RPTCOD)

Code identifying the current record.

• Title (field ZRPTDES)

Destined notably to figure in the reports and the screens in which the record code can be entered or selected. This text is used to give a clear description to the record concerned.

• Active (field ENAFLG)

This check box is used to activate or deactivate the current record without losing its content.

A deactivated record cannot be used (by calling its code) in other records (documents, setups, etc.) or during mass processings.

The authorizations for a given function can prohibit the creation of an active record. In this case, the box is cleared by default and it can only be modified by an authorized user or via a signature circuit defined by Workflow.

• Activity code (field CODACT)

An activity code is used to:

• make optional an element in the dictionary if the value associated with the activity code is null.
• identify the specific/custom elements if they are marked with a code starting with X, Y or Z.
• size a maximum number of lines when the activity code marks elements from a grid.

In this way, if the activity code is disabled, the marked element will not be useable, and the associated code (if any) will neither be generated nor can be activated.

• Short title (field ZRPTSHO)

This title, which provides a description of the record, is used in some screens or records when there is not enough space to visualize the long title.

• Module (field MODULE)

Module using the report.

• Group (field GRP)

This is the print group associated with the report. Thanks to this information, it will be possible to launch the report from the print menu with the sub-menu RPTxx ( where xx is the number of the element in local menu 97 for the field "GROUP"). The update of this information does not require the protection of an activity code.

Group that have been given access rights in the user management.

• Multi-language (field MULLAN)

If this box is checked, it indicates that the report has been generated in all the languages managed in the folder, if not the report is unique in the language in which it was designed.

• Original language (field LAN)

This field is used to reserve the report for a language ; language in which the report was designed.

• Type (field PRTNAT)

On the launch of the print, the destination is determined :

• by the additional formula if it exists
• if not, by the destination
• or finally, if the first 2 elements are not entered, by the type.

The type serves to determine a destination in the case where the additional formula and the destination are not entered. On the launch of the print, the supervisor determines the destination by one of the four parameters associated with the type. Each value type corresponds to a parameter, in which a destination is entered :

• Normal :       parameter PRT1
• Fax :             parameter PRT2
• Laser : Parameter PRT3
• Color :      parameter PRT4

Note : The values in this local menu 22 are modifiable.

• ZPL printer (field GESZPL)

• Setup code (field CODZPL)

• Destination (field PRTDEF)

Indicate a destination record. This record contains the print characteristics.

• Mandatory (field PRTOBL)

If this box is checked, it is not possible to modify the destination of the launch of the print of the report.

• Linked prints (field IMPLIE)

• Add info formula (field PRTFRM)

Entered or not, this field is used in the search for a destination by user and by report. This destination, if it is found, will have priority with respect to that specified above.

This field will be compared with the addition defined in the printer allocation function by user in the allocation algorithm for the printer at the time of printing,. Example : If in report X, an addition has been defined with the value "PAR" corresponding to printer Y and that he formula in report X contains the expression "PARAM(site)", then at the time of printing the report, if the "site" parameter is equal to PAR, the printer will be initialized to Y.

• Standard script (field TRTINI)

Processes in which it will be possible to write the additional sub-programs for the printing of this report. They are executed by the print expression just before the execution of the Crystal Reports report. It is used to initialize the variables defined in the report parameterization or possibly to prepare the files before the printing or even to update the fields in the database.

One process is reserved for the standard Adonix development and the other for the specific/custom. The update of a specific/custom process does not require protection with an activity code.  Development help

• Specific script (field TRTSPE)

• Not executable (field EXEFLG)

This field is used to indicate that the report is not directly executable from the print menu. This is the case for reports that are directly linked to a function and where the values of the print parameters come from the function.

• Batch only (field EXEBAT)

The update of this information does not require the protection by an activity code.

• Hourly constraints (field HOR)

• Report name (field CRYCOD)

One to five reports are printed consecutively at the time of launching the print. The entry of the parameters for all the reports is grouped at the launch. A file is generated by report. They are named : file.ext, file_1.ext, file_2.ext, … file_n.ext. For each report the orientation (portrait/landscape) should be indicated. The initialization process is executed for each report.

• Orientation (field ORIENT)

Portrait or landscape format. This information must be coherent with that entered in the Crystal Report report. There is the possibility to have reports of different orientation. The update of this field does not require protection by activity code.

• Paper size (field FORETA)

• Status (field DEVSTA)

• User (field DEVUSR)

• Date (field DEVDAT)

• Authorization site (field AUZFCY)

Indicate if the access to this report can be controlled by site. If yes, it is necessary to indicate in relation to which function. It is possible to indicate a generic RPTxx function where xx represent the print group.

• Function (field FNC)

• Access code (field ACS)

This access code makes it possible to authorize or prohibit the execution of a report by a user.

• Parameter (field PARCOD)

This code will be used by Crystal Reports.

A selection window is used to propose a group of parameters that already exist in the reports. For this reason it is advisable to reuse the same parameter names.

Automation and standard for the parameters expressed with a start and end range : Only enter the start range. Its code must end with the suffix "deb" or "str". The parameter for the end range is generated with the same root as the start range and the suffix "end" or "fin". It does not appear in the grid but is passed to Crystal.

Automation and standard for the parameters expressed with a start and end range : Only enter the start range. Its code must end with the suffix "deb" or "str". The parameter for the end range is generated with the same root as the start range and the suffix "end" or "fin". It does not appear in the grid but is passed to Crystal.

• Parameter title (field ZPARNAM)

Destined notably to figure in the reports and the screens in which the record code can be entered or selected. This text is used to give a clear description to the record concerned.

• Type (field PARTYP)

The field type is defined here. The principal types are :

A : Alphanumeric
C : Short integer
L : Long integer
DCB : Decimal
D : Date
M : Local menu

 Other types previously defined. They usually make reference to an annex table (currency, dimension...). The F12 key allows you to obtain the list.

• Length (field PARLNG)

Used to define the length of a field when this field uses a generic data type where the length is not fixed. This is notably the case for the types A and DCB.

• Menu (field PARNOLIB)

Defines the local menu number associated with the field defined on the line.

When a field is of the type local menu (from 1 to 255) corresponding to the rank of a title in a table named local menu, stored in the messages table APLSTD.

On entry or on display, the following are displayed according to the choices made in the user interface :

• either a title can be chosen in a scrolling list commonly called a combo box
• or a list of buttons.

The interest of this type of entry is that the list of choices is displayed in the user connection language.

Each local menu number characterises the list of available titles. For example, the local menu 1 corresponds to the choice No / Yes in this order. In this particular case, the user interface can also be a check box.

• Value type (field PARSTREND)

Indicates if it is necessary to enter a value interval.

Automation and standard for the parameters expressed with a start and end range : Only enter the start range. Its code must end with the suffix "deb" or "str". The parameter for the end range is generated with the same root as the start range and the suffix "end" or "fin". It does not appear in the grid but is passed to Crystal.

• Ent (field PARSAI)

Indicate here if the parameter is enterable or not at the launch of the report.

• First default (field PARDEF1)

It is possible to enter an expression that will be evaluated during the entry to initialize the parameter.

• Last default (field PARDEF2)

• Control (field PARCTL)

it is possible to enter a formula to control the entry of the parameter. The variable VALUE represents the entered parameter value.

• Control table (field PARCTLTAB)

It is possible to indicate here the code for a control table to verify the entry of a parameter.

• Object/dependency parameter (field PARPAR)

This is used to enter the first element of the key for an object, if this object has a key made up of two components. Example : table number for a miscellaneous table.

Peculiarity of a dependent miscellaneous table : this field is used to enter the master element for the "master" miscellaneous table; in this case the miscellaneous table number is to be entered in the "menu" column.

• Options (field PAROPT)

Can be entered if the data type is linked to an object. This field is used to define one or more filter options defined in the object. The supervisor controls the value entered in the parameter as a function of the filters set. Similarly, the selection window takes account of the filters.

• Access code (field PARACS)

This access codes is used to prevent the entry and display of the parameter.

In fact, if the field is entered, only the users having this access code with the modification right can modify the parameter.

• Segmentation parameter (field PARSEG)

Possibility to split the print over several print-outs as a function of the different values entered for the parameter declared in this field. It is necessary to define the major parameter for the report here.

This possibility for splitting the report is used to improve performances in very large reports.

• Title (field ZSRC)

If the report uses at least one table from another folder, there is an obligation to indicate the source of the data linked to each additional folder in the form "solution;folder". It is necessary that the folder is a folder linked in the folder management. The number of data sources is limited to 5. The folder entered is in fact, only a default value, because the source is modifiable at the launch of the print. If the solution is not indicated, the supervisor takes the current solution ; it is the same as for the folder. For the parent folder tables, the variable GDOSX3, available for all the product, can be used. For the X3 live folder tables, reached from another product (Geode GX, Abel X3, Paie), the variables GSOLCPT and GDOSCPT contain respectively the solution and the X3 folder.

• Default folder (field DOSSIER)

• Table (field TBL)

Tables associated with one of the sources given above to access to another folder. A limit of 10 tables is to be respected. The name of a table is limited to 200 characters.

• Title (field LIBTBL)

• Number (field NUM)

number identifying one of the sources of the data in the grid shown above.

• Data source (field LIBNUM)

Destined notably to figure in the reports and the screens in which the record code can be entered or selected. This text is used to give a clear description to the record concerned.