Advanced

1
Advanced CenterView Tables
Dana Stott Ken Boyer
2
Session Outline

• What are the advanced features
• JEval expressions
• Macro variables
• Demo

3
Advanced Features

• Pagination
• Defined at the group level
• Attributes
• Page Size
• Show Control in Header
• Show Control in Footer
• Class
• in-line style
• Corda Images
• Embed a Corda image into a table cell

4
Advanced Features (cont.)?

• col-span
• Defines a column span
• row-span
• Defines a column span
• Auto-span
• Defined in the data-view
• OLAP data
• Automatically combine adjacent cells with the
  same values

5
Advanced Features (cont.)?

• Separator
• Defined at group level
• Can insert an empty row or column
• Sorting
• Defined at header level
• Can define which columns to sort on
• Define default order (ascending/decending)
• Define format of date data in column
• Multiple Groups
• You can have multiple table-group tags under a
  table tag

6
Advanced Features (cont.)?

• Plug-ins
• Defined in the Header, Data or Footer views
• Allows you to customize your table
• Another session will cover this topic

7
JEval Expressions

• There are 60 JEval expressions available
• Math, String manipulation, Data grid and Date
• Used in apply conditions
• You can create complex expressions to evaluate
  the cell contents, its row/column position or
  evaluate the contents of another cell
• Example
• currencyToNumber(cellStringValue(_DSROW_,3)) -
  currencyToNumber(cellStringValue(_DSROW_, 2))
  lt 0
• Used to change cell content
• You can change the contents of a cell
• Example (converts cell value of May 01, 2008 to
  05/01/2008)
• dateFormat('MM/dd/yyyy', _TGCELL_VALUE_',
• 'MMM dd, yyyy')?

8
Macro Variables

• These variables are replaced with their value
  before JEval expressions are evaluated.
• cellStringValue(_DSROW_,_DSCOL_) -gt
  cellStringValue(3,8)
• _TGCELL_VALUE_ - Value of the HTML cell
• _DSCELL_VALUE_ - Value of the data cell
• _DSC_ - Value of the data cell from the
  current row where is the column number (ie.
  _DSC2_)?
• _DSR_ - Value of the data cell from the
  current column where is the row number (ie.
  _DSR15_)?
• _TGCOL_ - Current html column number (1
  based)?
• _TGROW_ - Current html row number (1 based)?
• _DSCOL_ - Current data column number (1
  based)?
• _DSROW_ - Current data row number (1 based)?
• _DSCOL_COUNT_ - Number of columns in the data
  grid
• _TGCOL_COUNT_ - Number of columns in the HTML
  table
• _DSROW_COUNT_ - Number of rows in the data
  grid
• _TGROW_COUNT_ - Number of rows in the HTML
  table
• _TGLOCALE_ - Current locale

9
Demo
Pagination Sorting Auto-span Corda
Images JEval Plugins
10
Additional Resources

• CD
• Corda Connection Visual Evolution 2008
• Go to portal.corda.com
• Login
• Resources
• Visual Evolution 2008
• Other VE Topics
• Meet me in the Lounge

11

• Q A

12
(No Transcript)