Language:


Printing Information from Matrices

It is possible to print information from matrices in the report. A matrix is the grid that appears in many registers. For example, an Invoice contains a matrix listing the Invoice Items. We will now illustrate printing information from a matrix by listing Invoice Items in our Customer list report. Follow these steps:
  1. Return to the Report Definition record and go to the 'Data' card.

  2. Click on the line in the report display area marked "Register: Invoices..." to select the Invoice register.

  3. Click the [Matrix] button. Because you clicked on the Invoice register line in step 2, the 'Matrix Rows' dialogue box already contains the correct defaults when it opens:

    Register/Block
    Paste Special    Registers in HansaWorld Enterprise
    Specify the "mother" register here: the register to which the matrix belongs. In the example, the Invoice Items matrix belongs to the Invoice register, so that register is entered here.

    Mother Record
    Enter the name of the variable containing the current record (the record currently being printed) in the mother register.

    Variable Name
    Enter a name for the variable that will contain the current matrix record (in the example, the current Invoice Item).

    Level
    The matrix should be on a level one below that of the mother register.

    Condition
    If necessary, enter a condition that must be met for the matrix to be processed (i.e. for the report to loop through the records in the matrix). This condition could be based on the value of a variable, check box or radio button in the specification window or of a field in the mother record. If the condition is based on the value of a field in the mother record, you should enter the full field name including the register variable (e.g. vrInvoice.Invalid==0, not Invalid==0).

  4. Click [OK] to save the matrix. A "Register Matrix:" line is added to the report display area, indented to show that it's on the third level:

Please click the links below for more details about: