Adding Expand Columns

As you decide which columns of data to include, you might run out of space and force the user to use the scroll bars. You can minimize scrolling by grouping columns together logically and including them as expansion options for your report and ad hoc pages.

This procedure describes how to add expansion columns.

In Workbench, open the appropriate script. For example, data_report_page.divetab.
To add columns as an expansion of an existing column, add an open brace, {, to the end of the line.
Type in the expand tag with a name followed by an open brace. For example:
```
  expand "Cases" {
```

Add text and column tags as appropriate. For example:

  text column = "9 Liter Cases" 
  text column = "BATF Cases"

Add a closing brace, }.
On a new line, enter another expand tag. For example:
```
  expand "Sales" {
```

Add more text and column tags. For example:

  text column = "Net Sales" { 
    value-format "$#,###.00" 
  } 
  text column = "Discount" { 
    value-format "$#,###.00" 
  }

Add a closing brace, }.
Click Save.
Return to the client, and click Sync.

Here is the code block with the expands.

  data-area id = "data-area-2" { 
    title "Expand Example" 
    icon "/divetab/images/menu icons/22.png" 
    sections { 
      report-page { 
        title "Expand Example" 
        cplan "/cplans/basic_102.cplan" 
        
        dimension "Premise" 
        dimension "Corporate Product Group" 
        dimension "Corporate Supplier" 
        
        text column = "Cost" { 
          value-format "$#,###.00" 
          expand "Cases" { 
            text column = "9 Liter Cases" 
            text column = "BATF Cases" 
          }
          expand "Sales" { 
            text column = "Net Sales" { 
              value-format "$#,###.00" 
            } 
            text column = "Discount" { 
              value-format "$#,###.00" 
            } 
          } 
        } 
      } 
    } 
  }

Here is the result of the code in DiveTab before the column is expanded.

Here is context menu for the expand columns, located under the Cost summary.

Here are the expanded Cases columns.

Here are the expanded Sales columns.

This example shows two separate expansion groups for one summary column. The DiveTab user can only select one at a time.

Expansion groups can be added for multiple columns on a page.