Right Panel - Parameters

The Parameters tab is certainly the most important set of parameters that you can use to affect the behavior of the Template.

Select Parameters from the right panel to access Parameters:

Enter a parameter into the search bar, or select each heading to display available parameters, as demonstrated below:

General Parameters

Sheet name (SHEETNAME)

Client name (CLIENT)

Enter Behavior (ENTER_BEHAVIOR)

Rows/Columns

Search column (SEARCHCOL)

Viewtags (VIEWTAG)

Worksheets

Addsheet Object (ADDSHEET)

Totalsheet name (ADDSHEET_TOTAL)

Place Totalsheet First (TOTALSHEET_FIRST)

Addsheet procedure (ADDSHEET_PROC)

Global Filters

Global Filters

Data Dimensions

Version (VERSION)

Form Tag (FORM_TAG)

Value Type (VALT)

Currency (CURR)

Scale Factor (SCALE)

Object Version (OBJVERSION)

Derive Object Version from Planning Version

Data Retrieve

Pre-generate Break Sheets (PRE_GENERATE_BREAK)

Data View Optimize (<DATAVIEW_OPTIMIZE>)

Query Options (QUERY_OPTIONS)

Group By (GROUPBY)

Data Update

Audit Trail (DELETE_METHOD)

Delete Where (DELETE_WHERE)

Data Table (DATA_TABLE)

Formatting

Entry - Background Color (ENTRY)

Entry - Font Color (ENTRY)

No Entry - Font Color (NOENTRY)

Ribbon Buttons

Hide Ribbon Buttons (HIDE_RIBBON_BUTTONS)

Disable

Disable Drill Through Option (DISABLE_AUTO_DRILL)

Exclude Columns in Drill Through (EXCLUDE_DRILL_COL)

Disable Authorization (DISABLE_AUTH)

Disable Authorization for Specific Object(s) (DISABLE_OBJECT_AUTH)

Subtotal

Summarize when only one row (SUBTOTAL)

Add an extra row before each subtotal row (SUBTOTAL)

Overwrite formulas in sum column (SUBTOTAL)

Group detail rows in an outline (SUBTOTAL)

Dynamic Columns

Data View (DYNCOL)

Select Columns (DYNCOL)

Order By Columns (ORDERBY)

Break Exclusive (DYNCOL)

Row Groups

Data View (ROWGROUP_PROC)

Select Columns (ROWGROUP_PROC)

Order By Columns (ORDERBY)

Currency Calculation

Report Currency (REPORTCURR)

Scanned Documents

Document Procedure (DOCUMENT_PROC)

The following parameters are not supported or yet implemented in v1 templates:

• View empty addsheets (VIEW_EMPTY_ADDSHEETS)

• Additional worksheet information (ADDINFOn)

• Disable Save button (DISABLE_SAVE)

• Trace SQL Queries (TRACE)

• Push sheets (PUSH_SHEETS)

• Enable SELECT FROM.. (INITIAL_SQL_ALL)

• Alternative source/table to fetch values from (BV_SOURCE)

  Caution: BV_SOURCE has been deprecated.