Summary


This article describes post-processing functions available for Excel format outputs.


Add a Post Processing Function

  • Select the green plus button to add a function

Auto Filter

This function adds an auto-filter menu to data block columns.
  • Function: Select Auto Filter
  • Apply to sheets: Select the sheet(s) to which to apply the auto filter function
  • Position Filter Row: Check this option to define the column header/filter row
    • Row: Enter a row number on which to apply the function
    • Header Range: Enter a cell range on which to apply the function
      • Use this option to target a single column instead of an entire row
      • Example: C2:C8 (where C2 is the column header and C3:C8 contain the data)

Sample worksheet where auto-filter is applied to entire row:

1074_003.png

1074_004.png


Auto Fit Columns


Auto-fit columns to cell contents


Freeze Panes


Freeze the display of select rows and/or columns.

  • Apply to sheets: Select the sheet(s) to which to apply the group function
  • Freeze Panes:

    • Select Rows Above and enter the row above which the freeze pane should apply

    • Select Columns to the left of and enter the row to the left of which the freeze pane should apply

    • Select Custom Pane Cell and enter a cell reference (example: B5) to freeze panes above and to the left of that cell


Group


This function creates groupings by row based on a select column.

  • Function: Select Group
  • Apply to sheets: Select the sheet(s) to which to apply the group function
  • First row is the header row: Specify whether the first row is a header row
  • Grouping column: Specify column on which to group values
  • Function requires the report table be positioned such that no space exists between the table and top and left edges page.

1074_006.png


Example of relative positioning in Web Intelligence:

1074_005.png


Print Title Rows

This function repeats the defined title row(s) on each printed page.
  • Title Rows: Row or range of rows representing title rows