Summary Tables Using Report Overlay

TableView supports overlaying reports for summary tables.

There are two methods you can use to overlay tables:
  • Appending rows or columns places the data sources next to each other. Appending also always create new pages.
  • Inserting rows or columns (interlacing/alternating rows or columns) displays interlaced columns, and expanded headers.

Overlay Mode

From the Overlay Mode drop-down menu, select from one of the following:
  • Append as Rows
  • Appends as Columns
  • Insert as Rows
  • Insert as Columns

When you select an area from the table to interlace columns, all cells above and below the selected area will be merged cells. In other words, they will be expanded horizontally to accommodate the new columns beneath/above them.



Figure 1. Generic example of initial session data in TableView and the appended columns after overlaying reports:


Figure 2. Summary Table for a twice-overlaid report using Append as Columns:


Figure 3. A generic example of your initial session data in TableView and the Interlaced columns after overlaying reports:


Figure 4. A Summary Table example for a twice-overlaid report using Insert as Columns (Interlaced columns) using real data:

Define the Overlay Area and Save as a Report Template.

After defining the overlay area, save it as a report template.

  1. Create or load a session file that contains your data.
    For example, the following session displays the internal and kinetic energy data in TableView (right side of image) for the curves shown on the left:


    Figure 5.
  2. From the TableView toolbar, select the Overlay Settings icon.
  3. From the Overlay Mode drop-down menu, select Append as Columns.
  4. Click Add Overlay Area.
    Overlay 1 is added to the Overlay Area Name column.
  5. Under the Cells column, click inside the empty cell.
    The selector icon is displayed.
  6. Click the selector icon, and with the left mouse button, drag and select the cells in TableView that contain the previously loaded data.


    Figure 6.


    Figure 7. The cells you marked are displayed in the panel below:
  7. From the File menu, select Save As > Report Template and enter a report template name and save location.

Overlay a Report Template

  1. Click File > New > Session to create a new session file. Click Yes to continue with the new session.
  2. From the Reports toolbar, click the Open Reports Panel icon, .
  3. Under Report Templates, the report template you previously saved is displayed.
  4. Under Mode, verify that Append is selected.
  5. Click Apply.


    Figure 8.
  6. Return to the Flexible Report Template panel and make the following changes:
    1. Select a new PLOT_FILE.
    2. Change the Color.
    3. Change the Prefix (for example, to Run 2).
  7. Under Mode, select Overlay.
  8. Click Apply.
    Run 2 data is appended next to the Run 1 data.


    Figure 9.

Interlacing Columns

If you choose to interlace data, or Insert as Columns instead of Append as Columns, the procedure varies slightly.

  1. For example, start with the same session data as when appending data.


    Figure 10.
  2. However, when you select Insert as Columns for the Overlay Mode, you will have two overlay areas defined, as shown below:


    Figure 11.
  3. After you define the overlay area, return to the Open Reports Panel and edit your report template as you did in Step 3 above:
    1. Select a new PLOT_FILE.
    2. Change the color.
    3. Change the prefix (for example, to Run 2).
  4. Under Mode, select Overlay.
  5. Click Apply.
    The image below shows the data for Run 1 and Run 2 side-by-side under each heading.


    Figure 12.
    Note: Existing cells (in the original table) will not be modified/affected when the overlay is performed.

    When more than one area in the table is selected for an overlay, the selected areas must align horizontally when overlaying by column and vertically when overlaying by row. In both cases, the selected areas must not overlap. When more than one area in the table is selected, if the second area overlaps or does not align properly with the first, a message similar to the one below is displayed as soon as the second area is selected and you will not be allowed to select that area:



    Figure 13.

Define the Rows or Columns for an Overlay

  1. From the Overlay Settings panel, , click Add Overlay Area to add a new overlay to the table.
  2. Define which rows or columns should be used for the overlay.
    1. Click in the empty cell under the Cells column and click the selector button, .
    2. Select an area in TableView by holding down the left-mouse button (LMB) and dragging in the table area.
    3. Release the LMB to select the area and record it in the panel's Overlay Area table.
  3. To delete an overlay area, select it from the panel and click Delete Overlay Area.