Using RDB formulas instead of multiple output cells

Instead of using multiple output cells, you can extend a hyperblock and enter separate RDB formulas in each of the cells you create.

RDB formulas cannot be used unless at least one hyperblock is linked to a relational list on the worksheet.

You can create RDB formulas in cells outside the hyperblock as well as inside. When created inside a hyperblock, the row index in the RDB formula is the cell reference of the key output cell of the hyperblock. This dynamically references the row index and inserts the corresponding data field for each data record.

When created outside a hyperblock, only one value results from the RDB formula. In this case, you must use a specific row number as the row index. For example: 
=RDB(HYPERBLOCK("Hyperblock3"),1,"column_name")

To use separate RDB formulas instead of multiple output cells:

  1. Extend the hyperblock that contains the relational selection. Click in the cell that is to contain the additional column of the relational table.
  2. Click the Edit OLAP Formula icon in the Objects toolbar and select Relational Values in the Formula type list.
  3. From the Column list in the Database section, select the next column of the table to display in the hyperblock. The data formula is displayed in the OLAP Formula section.
  4. Repeat these steps for each column of the table to be displayed in the hyperblock.
    Note: In Design mode, #VALUE is displayed in the cells. But, in Debug mode or View mode, the correct values are displayed.