Section 13: Table Parameters

Global Table Parameters

Parameter Description Example
tableDataSource The path to this table’s Named DataSet. tableDataSource=SomeNamedDataSet.ndx
tableDataColumnFilter Lists the columns to be displayed. All columns are displayed if this parameter is not set. tableDataColumnFilter=0,2-5,10*
tableDataRowFilter Lists the rows to be displayed. All rows are displayed if this parameter is not set. tableDataRowFilter=5*
lineNumberingEnabled The row index will appear in the first column when true. lineNumberingEnabled=false
firstRowIsColumnNames If true, use data in the first row as column headings. firstRowIsColumnNames=false
tableStyleSheet The name of an available .css style sheet tableStyleSheet=/styles/defaultTableStyleRight
.css
tableResolveStyles If true, then instead of including a link to the stylesheet, styles will be resolved and included as style attributes to each element. tableResolvePaths=true
tableStyle Defined table style. tableStyle= color:#888899;border:1
tableClass The .css class to use for the table style. tableClass=smallTable
tableCaption Text to use as the table’s caption. tableCaption=Third Quarter Financial Results
tableCaptionStyle Caption display style. tableCaptionStyle=text-align:center;fontsize:
12px;font-family:Arial;font-weight:bold
tableCaptionClass The .css class to use for the table style. tableCaptionClass=smallCaption
tableName Added to the output table tag. Useful for referencing in JavaScript tableName=MyTableName
tableID Added to the output table tag. Useful for referencing in JavaScript tableID=MyTableID
tableScroll Enables or disables table scrolling (Only available in IE browsers). Values are BOTH (enabled) or NONE (disabled) tableScroll=BOTH
tableScrollWidth The pixel width of the scroll window tableScrollWidth=500
tableScrollHeight The pixel height of the scroll window tableScrollHeight=400
tableScrollLeftColumnWidth The width of the leftmost column. This column will scroll during vertical scrolling, but will remain fixed during horizontal scrolling tableScrollLeftColumnWidth=100
tableScrollTopRowHeight The height of the top title row. This row will scroll during horizontal scrolling but will remain fixed during vertical scrolling tableScrollTopRowHeight=16
tableScrollVScrollbarWidth Width of the space for the vertical scrollbar at the right tableScrollVScrollbarWidth=16
tableScrollHScrollbarHeight Height of the space for the horizontal scrollbar at the bottom. TableScrollHScrollbarHeight=16

Column Parameters

Parameter Description Example
columnNames A whitespace separated list of column names or column
indexes.		 columnNames=cost revenue
columnNames= COLUMN_3
COLUMN_LAST
columnNameLabel The label to use for this column. If firstRowIsColumnNames is set to true this attribute will be ignored. costLabel=Q2
columnNameFormatType Determines how the column content should be formatted. One of:

  • STRING – Formats as a string. This is the default format type.
  • INTEGER – Formats as integer. If “Format” defined, expect to be in C-language sprintf format.
  • CUSTOMDECIMAL – Formats as decimal. If “Format” defined, expect to be in Java-language DecimalFormat pattern. Default pattern: “#,##0.00;-#,##0.00”.
  • DATE – Formats as date. If “Format” defined, expect to be in Java-language java.text.SimpleDateFormat pattern.
  • FLOAT – Formats as decimal. If “Format” defined, expect to be in C-language sprintf format
  • CURRENCY – Formats as currency. If “Format” defined, expect to be in Java-language java.text.DecimalFormat pattern. Default pattern: “$#,##0.00;-$#,##0.00”.
  • ACCOUNTING – Formats as decimal. If “Format” defined, expect to be in Java-language java.text.DecimalFormat pattern. Default pattern: “#,##0.00;(#,##0.00)”.
  • ACCOUNTINGCURRENCY – Formats as decimal. If “Format” defined, expect to be in Java-language java.text.DecimalFormat pattern. Default pattern: “#,##0.00;(#,##0.00)”.
  • PASSTHRU – No formatting.
 costFormatType=CURRENCY
columnNameFormat The format pattern (as described above) to use for the column. costFormat=&euro’;’ #,##0;-
&euro’;’#,##0
columnNameNullFormat The format pattern (using C-language sprintf style) to apply to null values. costNullFormat=%s
columnNameNullValue The value to substitute if the cell value for this column is null. costNullValue=[No Value]
columnNameStyle Defined style for this column’s cells, not including the column header. costStyle= color:#000000;
columnNameClass The .css class to use for this column’s cells, not including the column header. costClass=numericColumnStyle
columnNameLabelStyle Defined style for this column’s header label. costLabelStyle= backgroundcolor:#
000000;color:#ffffff;
columnNameLabelClass The .css class to use for this column’s header label. costLabelClass=columnHeader
columnNameTargetURL URL to drilldown to or javascript method to call if a cell value in this column is selected. If the values DATA_VARIABLE, ROW_VARIABLE, COLUMN_VARIABLE, ROW_HEADER_VARIABLE, and/or COLUMN_HEADER_VARIABLE are used in the URL, they will be replaced at run time with the cell value, row number, column number, row header, and/or column header respectively. costTargetURL=detail.jsp?da
ta=DATA_VARIABLE&col=COLUMN
_VARIABLE&row=ROW_VARIABLE
columnNameLabelTarget
URL		 URL to drilldown to or javascript method to call if this column’s header label is selected. If the valuesDATA_VARIABLE, ROW_VARIABLE, COLUMN_VARIABLE, ROW_HEADER_VARIABLE, and /or COLUMN_HEADER_VARIABLE are used in the URL, they will be replaced at run time with the cell value, row number, column number, row header, and/or column header respectively. costLabelTargetURL=javascri
pt:showDetail(ROW_VARIABLE,
COLUMN_VARIABLE)
columnNameFormatStyle Name of .css class to be used for numeric or date formatting. Use instead of formatType, format parameters costFormatStyle=MyCurrency
columnNameDistinct If set to true, causes the column to span over rows that have duplicate adjacent values costDistinct=true

Row Parameters

Parameter Description Example
rowNames A whitespace separated list of row indexes. rowNames=FIRST ROW_3 ROW_5 LAST
rowIndexStyle Defined style for this row. FIRSTStyle=background-color:pink
rowIndexClass The .css class to use for this row. ROW_3Class=specialRow
rowIndexLineNumberEnabled If false, but lineNumberingEnabled is set to true, then this row will not be numbered. ROW_5LineNumberEnabled=false
rowIndexLineBreak If true, will insert a line break before this row. LASTLineBreak=true
rowIndexTargetURL URL to drilldown to or javascript method to call if a cell value in this row is selected. LASTTargetURL=javascript:showDetail(ROW_VARIABLE,
COLUMN_VARIABLE)
alternateRowStyle Defined style for every other row. alternateRowStyle=background-color:#cccccc;
alternateRowClass The .css class to use for every other row. alternateRowClass=alternateRow
rowIndexFormatStyle Name of .css class to be used for numeric or date formatting. Use instead of formatType, format parameters LASTFormatStyle=MyCurrency
rowIndexFormatType Determines how the column content should be formatted. One of:

  • STRING – Formats as a string. This is the default format type.
  • INTEGER – Formats as integer. If “Format” defined, expect to be in C-language sprintf format.
  • CUSTOMDECIMAL – Formats as decimal. If”Format” defined, expect to be in Java-language DecimalFormat pattern. Default pattern: “#,##0.00;- #,##0.00”.
  • DATE – Formats as date. If “Format” defined, expect to be in Java-language java.text.SimpleDateFormat pattern.
  • FLOAT – Formats as decimal. If “Format” defined, expect to be in C-language sprintf format
  • CURRENCY – Formats as currency. If “Format” defined, expect to be in Javalanguage java.text.DecimalFormat
    pattern. Default pattern:”$#,##0.00;-$#,##0.00″.
  • ACCOUNTING – Formats as decimal. If “Format” defined, expect to be in Javalanguage java.text.DecimalFormat pattern. Default pattern: “#,##0.00;(#,##0.00)”.
  • ACCOUNTINGCURRENCY – Formats as decimal. If “Format” defined, expect to be in Java-language java.text.DecimalFormat pattern. Default pattern: “#,##0.00;(#,##0.00)”.
  • PASSTHRU – No formatting.
 LASTFormatType=CURRENCY
rowIndexFormat The format pattern (as described above) to use for the row. LASTFormat=&euro’;’ #,##0;-&euro’;’#,##0

Cell Parameters

Parameter Description Example
cellNames A whitespace separated list of cell indexes. cellNames=CELL_4_12 CELL_5_12
cellIndexStyle Defined style for this cell. CELL_4_12Style=background-color:pink
cellIndexClass The .css class to use for this cell. CELL_4_12Class=specialCell
cellIndexTargetURL URL to drilldown to or javascript method to call if this cell is selected. CELL_4_12TargetURL = javascript:showDetail(ROW_VARIABLE,
COLUMN_VARIABLE)
cellIndexFormatType Determines how the cell content should be formatted. One of:

  • STRING – Formats as a string. This is the default format type.
  • INTEGER – Formats as integer. If “Format” defined,expect to be in C-language sprintf format.
  • CUSTOMDECIMAL – Formats as decimal. If “Format” defined, expect to be in Java-language DecimalFormat pattern. Default pattern: “#,##0.00;- #,##0.00”.
  • DATE – Formats as date. If “Format” defined, expect to be in Java-language java.text.SimpleDateFormat pattern.
  • FLOAT – Formats as decimal. If “Format” defined, expect to be in Clanguage sprintf format
  • CURRENCY – Formats as currency. If “Format” defined, expect to be in Java-language java.text.DecimalFormat pattern. Default pattern: “$#,##0.00;-$#,##0.00”.
  • ACCOUNTING – Formats as decimal. If “Format” defined, expect to be in Java-language java.text.DecimalFormat pattern. Default pattern: “#,##0.00;(#,##0.00)”.
  • ACCOUNTINGCURRENCY – Formats as decimal. If “Format” defined, expect to be in Java-language java.text.DecimalFormat pattern. Default pattern: “#,##0.00;(#,##0.00)”.
  • PASSTHRU – No formatting.
 CELL_4_12FormatType=CURRENCY
cellIndexFormat The format pattern (as described above) to use for the cell. CELL_4_12Format=&euro’;’ #,##0;-&euro’;’#,##0

Table Pagination Parameters

Parameter Description Example
tablePagination Enables or disables table paging. Set to true to enable table paging. tablePagination=true
tablePaginationAlign Sets the placement of the table pagination control relative to the table. Values are TOP, BOTTOM, or TOPANDBOTTOM. Default is BOTTOM (table pagination control appears below the table rows). tablePaginationAlign=BOTTOM
tablePaginationPagesNum Limit for the number of pages displayed. Default is 10. tablePaginationPagesNum=8
tablePaginationPageSize The number of rows per page. Default is 10. tablePaginationPageSize=20
tablePaginationStyle Style for the table pagination control. tablePaginationStyle = border-style: solid; border-width: 1px
tablePaginationClass The .css class to use for the the table pagination control. tablePaginationClass = specialPageControl
tablePaginationIndexStyle Style for the page numbers. tablePaginationIndexStyle = color:blue
tablePaginationIndexClass The .css class to use for the page numbers. tablePaginationIndexClass = specialPageNumbers
tablePaginationSelectedIndexStyle Style for the selected page. tablePaginationSelectedIndexStyle = color:blue
tablePaginationSelectedIndexClass The .css class to use for the selected page. tablePaginationSelectedIndexClass = selected Page
tablePaginationFirstStyle Style for the first page link (<<). tablePaginationFirstStyle = color:blue
tablePaginationFirstClass The .css class to use for the first page link. tablePaginationFirstClass = specialFirstLink
tablePaginationNextStyle Style for the next page link (>). tablePaginationNextStyle = color:blue
tablePaginationNextClass The .css class to use for the next page link. tablePaginationNextClass = specialNextLink
tablePaginationPreviousStyle Style for the previous page link (<). tablePaginationPreviousStyle = color:blue
tablePaginationPreviousClass The .css class to use for the previous page link. tablePaginationPreviousClass = specialPreviousLink
tablePaginationLastStyle Style for the last page link (>>). tablePaginationLastStyle = color:blue
tablePaginationLastClass The .css class to use for the last page link. tablePaginationLastClass = specialLastLink