Class actuate.xtabanalyzer.Options
Description
The Options class specifies options for the cross tab.
Constructor
Syntax
actuate.xtabanalyzer.Options(string measureDirection, string rowMirrorStartingLevel, string columnMirrorStartingLevel, string emptyCellValue, boolean enablePageBreak, integer rowPageBreakInterval, integer columnPageBreakInterval)
Creates an options object that contains options for how the cross tab displays data.
Parameters
measureDirection
String. The measure direction. Legal values for measure direction are:
*DIRECTION_HORIZONTAL
*DIRECTION_VERTICAL
rowMirrorStartingLevel
String. Row mirror starting level name.
columnMirrorStartingLevel
String. Column mirror starting level name.
emptyCellValue
String. Value to display for an empty cell.
enablePageBreak
Boolean. Enables page breaks when true.
rowPageBreakInterval
Integer. Row page break interval.
columnPageBreakInterval
Integer. Column page break interval.
grandTotalsDisplayOption
String. Grand totals display option. Legal values for total display options are:
*DIRECTION_HORIZONTAL
*DIRECTION_VERTICAL
subtotalsDisplayOption
String. Subtotals display option. Legal values for total display options are:
*DIRECTION_HORIZONTAL
*DIRECTION_VERTICAL
Function summary
Table 8‑15 lists actuate.xtabanalyzer.Options functions.
Table 8‑15 actuate.xtabanalyzer.Options functions
Function
Description
Returns the column mirror starting level full name
Returns the column page break interval
Returns the empty cell value
Returns the page break enabled or disabled status
Returns the measure direction
Returns the row mirror starting level full name
Returns the row page break interval
Sets the column mirror starting level full name
Sets the column page break interval
Sets the empty cell value
Sets the flag to enable page breaks
Sets the measure direction
Sets the row mirror starting level full name
Sets the row page break interval
getColumnMirrorStartingLevel
Syntax
string Options.getColumnMirrorStartingLevel( )
Returns the column mirror starting level name.
Returns
String. Column mirror starting level name.
Example
This example retrieves the column mirror starting level:
function getColumnMirrorStart(options){
if (options){
return options.getColumnMirrorStartinglevel( );
}
return null;
}
getColumnPageBreakInterval
Syntax
integer Options.getColumnPageBreakInterval( )
Returns the column page break interval.
Returns
Integer. The column page break interval.
Example
This example retrieves the column page break interval:
function getColumnPBInterval(options){
if (options){
return options.getColumnPageBreakInterval( );
}
return null;
}
getEmptyCellValue
Syntax
string Options.getEmptyCellValue( )
Returns the empty cell value.
Returns
String. Value to display for an empty cell.
Example
This example retrieves the empty cell:
function getEmptyCell(options){
if (options){
return options.getEmptyCellValue( );
}
return null;
}
getEnablePageBreak
Syntax
boolean Options.getEnablePageBreak( )
Returns the page break status.
Returns
Boolean. Page breaks are enabled when the value is true.
Example
This example retrieves the column page break interval when page breaks are enabled:
function getColumnPBEnabled(options){
if (options.getEnablePageBreak( )) {
return options.getColumnPageBreakInterval( );
} else {
alert ("Page breaks not enabled.");
return null;
}
}
getMeasureDirection
Syntax
string Options.getMeasureDirection( )
Returns the measure direction.
Returns
String. The measure direction. Legal values for measure direction are:
*DIRECTION_HORIZONTAL
*DIRECTION_VERTICAL
Example
This example retrieves the measure direction:
function getMeasureDirection(options){
if (options){
return options.getMeasureDirection( );
}
return null;
}
getRowMirrorStartingLevel
Syntax
string Options.getRowMirrorStartingLevel( )
Returns the row mirror starting level name.
Returns
String. Row mirror starting level name.
Example
This example retrieves the row mirror starting level:
function getRowMirrorStart(options){
if (options){
return options.getRowMirrorStartinglevel( );
}
return null;
}
getRowPageBreakInterval
Syntax
integer Options.getRowPageBreakInterval( )
Returns the row page break interval.
Returns
Integer. The row page break interval.
Example
This example retrieves the row page break interval:
function getRowPBInterval(options){
if (options){
return options.getRowPageBreakInterval( );
}
return null;
}
setColumnMirrorStartingLevel
Syntax
void Options.setColumnMirrorStartingLevel(string levelName)
Sets the column mirror starting level name.
Parameter
levelName
String. The column mirror starting level name.
Example
This example sets the column mirror starting level:
function setColumnMirrorLevel(options,level)(
if (options){
options.setColumnMirrorStartingLevel(level);
}
}
setColumnPageBreakInterval
Syntax
void Options.setColumnPageBreakInterval(integer columnPageBreakInterval)
Sets the column page break interval.
Parameter
columnPageBreakInterval
Integer. The column page break interval.
Example
This example sets the column page break interval:
function setColumnPBInterval(options,interval)(
if (options){
options.setColumnPageBreakInterval(interval);
}
}
setEmptyCellValue
Syntax
void Options.setEmptyCellValue(string emptyCellValue)
Sets the empty cell value.
Parameter
emptyCellValue
String. The empty cell value.
Example
This example sets the empty cell value:
function setEmptyCell(options, cellValue)(
if (options){
options.setEmptyCellValue(cellValue);
}
}
setEnablePageBreak
Syntax
void Options.setEnablePageBreak(boolean enablePageBreak)
Enables or disables page breaks.
Parameter
enablePageBreak
Boolean. Enables page breaks when true.
Example
This example enables page breaks and sets the row page break interval:
function enablesetRowPBInterval(options,interval)(
if (options){
options.setEnablePageBreak(true);
options.setRowPageBreakInterval(interval);
}
}
setMeasureDirection
Syntax
void Options.setMeasureDirection(string measureDirection)
Sets the measure direction.
Parameter
measureDirection
String. The measure direction. The measure direction. Legal values for measure direction are:
*DIRECTION_HORIZONTAL
*DIRECTION_VERTICAL
Example
This example sets the measure direction:
function setMeasureDirection(options,direction){
if (options){
options.setMeasureDirection(direction);
}
}
setRowMirrorStartingLevel
Syntax
void Options.setRowMirrorStartingLevel(string levelName)
Sets the row mirror starting level.
Parameter
levelName
String. Row mirror starting level name.
Example
This example sets the row mirror starting level:
function setRowMirrorLevel(options,level){
if (options){
options.setRowMirrorStartingLevel(level);
}
}
setRowPageBreakInterval
Syntax
void Options.setRowPageBreakInterval(integer rowPageBreakInterval)
Sets the row page break interval.
Parameter
rowPageBreakInterval
Integer. The row page break interval.
Example
This example sets the row page break interval:
function setRowPBInterval(options,interval)(
if (options){
options.setRowPageBreakInterval(interval);
}
}