Creating and Using Report Tables
Inserting and Editing a Table in the Printer Layout

• Enable Layout Mode on the Edit menu.

• Select Insert > Chromeleon Report Table on the Edit or context menu. The Insert Report Table dialog box appears.

• In the Report Tables field, mark the report table you want to insert. If necessary, click the + character beside the report table groups to display the tables underneath. The columns available for the selected table are displayed in the Columns field.

• Some columns are marked by default. Select the columns that should be included in the table and deselect all others. Press and hold the Ctrl key to select or deselect several columns simultaneously.

• Clicking OK inserts the table into the worksheet.

• To indicate that the table is a Chromeleon object all four corners of the table are marked by red triangles. The last row(s) are not marked by red triangles because they are no Chromeleon objects.

   Caution:

  If the worksheet already contains a report table, insert the new table above or below the existing one. It is not possible to insert several report tables next to each other.

   

   Tip:

  You cannot move or copy an entire table. When moving or copying a table, only the current content (= the values) is copied to the clipboard but not the underlying variables! (The red triangles are missing indicating that this table is no longer a Chromeleon object.) Besides, it is not possible to move single columns. Instead, insert a new column at the corresponding position and delete the 'old' column.

• Select a column header and then select Report Column Properties on the context menu. Determine the header, the dimension, and the format of the column or of the column values.

• To modify the appearance of a single cell, a table area, or the entire table (font size and style, frame, color, etc.), select the cell, the area or the entire table and then select the corresponding command on the Format menu.

• Select the column or the row you want to delete, and then select Delete Column(s) or Delete Row(s) on the Edit menu. To insert additional rows or columns in front of the selected area, select Insert Row(s) or Insert Column(s) on the Edit menu.

Inserting a "Total" Row

The new table does not comprise a Total row. Insert the Total row as follows:

• Copy any cell from another Total row; for example, from another Printer Layout table or from an integration report.

• Select the cells of the new table, which should indicate the sum of all cell values of the corresponding column.

• Select Paste.

 Tip: 

Proceed in the same way to update any existing entries in the rows Average and/or Rel.Std.Dev rows. These rows are not marked by red triangles, because they are no Chromeleon objects.

Creating the correct cell reference

The values in the Total row must receive the correct cell reference. This is especially important when the new table is longer than the table from which the cell was copied.

• Enable Layout Mode on the Edit menu. The edit line is displayed.

• Select the first value in the Total row. In the edit line, the corresponding formula appears; for example, =SUM(C10:C22).

• Select the cell range indicated in parentheses in the edit line with the mouse; for example, C10:C22.

• Then, select the actual cell range in the table with the mouse or type the cell range in the edit line via the keyboard.

• Press <Enter> to confirm your input.

The sum cell value is recalculated based on the new cell range. Then perform the individual steps for the remaining sum cell values.

For more information, see  Inserting a Column into an Existing Table.