Generating new reports

  1. Start the Generated Reports (ttadv3548m000) session. An overview of the generated reports and sessions is displayed.
  2. Click New. The Select Current Activity (tlprj0140m000) session starts.
    Generating new reports is done through activity-based development. Therefore, an activity must be selected or created. These are the same activities as used by LN Studio and extensibility.
    You must have developer authorization for the extensibility package, ‘tx’.
    Note: Before you can select an activity, extensibility parameters must be present. See the Initialize Extensibility (ttext0200m000) session and the Infor LN Extensions Development Guide .
  3. Select an activity and click OK. The Report Designer is started with a different layout and the Report Configuration dialog box is displayed.
  4. In the Report Configuration dialog box, specify these properties:
    Report code
    The package and module code is “txgre”. This is read-only. Specify the rest of the report code. By default, the first free sequence number is displayed.
    Report description
    Specify the description of the report, in the current language of the user.
    Size
    The size specifies the default margins and number of columns for the report. These sizes are defined in the Default Sizes (ttadv3540m000) session.
    Session description
    Specify the description of the session, in the current language of the user.
    Main table
    Specify the first table to be selected by the generated session. The main table determines the overall structure and grouping on the report. After selecting a main table, you can select referred tables in both directions.
  5. Click OK.

    These panels are displayed:

    Tables
    The tree of references. The Refers-to folder contains tables with details of the selected table. The Referred-by folder contains tables that refer to the selected table.
    For example: Sales Orders (tdsls400) refers to Sales Offices (tdsls012), which is one detail of the sales order. Sales Orders (tdsls400) is referred by Sales Order Lines (tdsls401). The lines refer to the order.
    From refers-to tables you can browse further to other refers-to tables only. For referred-by tables, both directions are available.
    Next to the header of the panel, a breadcrumb from the main table to the selected table is displayed. Click a table in the breadcrumb, to select that table.
    Fields
    The list of fields of the currently selected table. Array fields are displayed multiple times, once for each element. The Selected column indicates whether a field is currently selected for the report.
    Selected Fields
    The overview of currently selected fields, with the same structure as the report has. The main table is always present as a group. Fields of that table and refers-to tables are displayed in the Fields list below the table.
    If fields of a referred-by table are selected, a new group is created for that table, and the fields are added to that group. In the same way, fields of refers-to tables of the sub-group are displayed in that list.
    For example, with Sales Orders as main table, all fields of the Sales Orders table and all fields of refers-to tables of sales orders are displayed in the main group. If a field of Sales Order Lines is selected, a new group is created. All fields of refers-to tables of sales order lines are displayed in that new group.
    Properties
    This panel shows the session and report description and code. The properties of the currently selected group are also displayed.

When you open an existing record in the Generated Reports (ttadv3548m000) session, this view is directly displayed, without showing the Report Configuration dialog box. In that case, you can open the Report Configuration dialog box by clicking Report Configuration on the main toolbar.