|
Style Intelligence v12.0 | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectinetsoft.report.lens.AbstractTableLens
inetsoft.report.lens.FormulaTableLens
public class FormulaTableLens
FormulaTableLens can be used to add more columns to a table. The new column is populated by running a formula on each row. The formula can access other columns on the same row. This allows simple calculation to be performed without creating a new Java class. A new column is created for each formula.
| Nested Class Summary | |
|---|---|
static class |
FormulaTableLens.HeaderInfo
Formula header info, include the formula header name, its original column header name, and the default created meta info for this formula header, and the really meta info for this formula header is this meta info merge with the original column's meta info. |
| Field Summary |
|---|
| Fields inherited from class inetsoft.report.lens.AbstractTableLens |
|---|
isLeftAlign |
| Fields inherited from interface inetsoft.report.TableLens |
|---|
BREAK_BORDER, NULL |
| Fields inherited from interface inetsoft.uql.XTable |
|---|
EOT |
| Constructor Summary | |
|---|---|
FormulaTableLens(TableLens table,
String[] headers,
String[] formulas,
ReportSheet report)
Construct a formula table. |
|
FormulaTableLens(TableLens table,
String[] headers,
String[] formulas,
inetsoft.util.script.ScriptEnv senv,
Object scope)
Construct a formulat table. |
|
FormulaTableLens(TableLens table,
String[] headers,
String[] formulas,
inetsoft.util.script.ScriptEnv senv,
Object scope,
Boolean[] mergeables)
Construct a formulat table. |
|
| Method Summary | |
|---|---|
void |
clearCache()
Clear all cached data. |
boolean |
containsAttribute(String attributeName)
Returns true if there is an formula header with that name |
void |
dispose()
Dispose the table to clear up temporary resources. |
int |
getAlignment(int r,
int c)
Return the per cell alignment. |
Color |
getBackground(int r,
int c)
Return the per cell background color. |
int |
getBaseColIndex(int col)
Get the base table column index corresponding to the filtered table. |
int |
getBaseRowIndex(int row)
Get the base table row index corresponding to the filtered table. |
boolean |
getBoolean(int r,
int c)
Get the boolean value in one row. |
byte |
getByte(int r,
int c)
Get the byte value in one row. |
int |
getColBorder(int r,
int c)
Return the style for right border of the specified row. |
Color |
getColBorderColor(int r,
int c)
Return the color for drawing the column border lines. |
int |
getColCount()
Return the number of columns in the table. |
String |
getColumnIdentifier(int col)
Get the column identifier of a column. |
int |
getColWidth(int col)
Get the current column width setting. |
TableDataDescriptor |
getDescriptor()
Get internal table data descriptor which contains table structural infos. |
double |
getDouble(int r,
int c)
Get the double value in one row. |
float |
getFloat(int r,
int c)
Get the float value in one row. |
Font |
getFont(int r,
int c)
Return the per cell font. |
Color |
getForeground(int r,
int c)
Return the per cell foreground color. |
int |
getHeaderColCount()
Return the number of columns on the left of the table to be treated as header columns. |
int |
getHeaderRowCount()
Return the number of rows on the top of the table to be treated as header rows. |
Insets |
getInsets(int r,
int c)
Return the cell gap space. |
int |
getInt(int r,
int c)
Get the int value in one row. |
long |
getLong(int r,
int c)
Get the long value in one row. |
Object |
getObject(int r,
int c)
Return the value at the specified cell. |
int |
getRowBorder(int r,
int c)
Return the style for bottom border of the specified cell. |
Color |
getRowBorderColor(int r,
int c)
Return the color for drawing the row border lines. |
int |
getRowCount()
Return the number of rows in the table. |
int |
getRowHeight(int row)
Get the current row heights setting. |
short |
getShort(int r,
int c)
Get the short value in one row. |
Dimension |
getSpan(int r,
int c)
Return the spanning setting for the cell. |
TableLens |
getTable()
Get the original table of this filter. |
int |
getTrailerColCount()
Return the number of columns on the right of the table to be treated as tail columns. |
int |
getTrailerRowCount()
Return the number of rows on the bottom of the table to be treated as tail rows. |
void |
invalidate()
Invalidate the table filter forcely, and the table filter will perform filtering calculation to validate itself. |
boolean |
isLineWrap(int r,
int c)
Return the per cell line wrap mode. |
boolean |
isNull(int r,
int c)
Check if the value at one cell is null. |
boolean |
isPrimitive(int col)
Check if is primitive. |
boolean |
isRestricted(int col)
Check if scripts should be restricted in access to system resources. |
boolean |
moreRows(int r)
Check if there are more rows. |
void |
setAlignTypes(Class[] aligntypes)
Set the alignment type. |
void |
setColType(int col,
Class type)
Set the column type. |
void |
setFormulaHeaderInfo(Vector hinfos)
Set formula field header info. |
void |
setObject(int r,
int c,
Object val)
Set a cell value. |
void |
setRestricted(int col,
boolean restricted)
Set if scripts should be restricted in access to system resources. |
void |
setTable(TableLens table)
Set the base table of this filter. |
void |
setTableName(String tname)
Set the table name. |
| Methods inherited from class inetsoft.report.lens.AbstractTableLens |
|---|
addChangeListener, clone, containsDrill, containsFormat, findColumnByIdentifier, fireChangeEvent, getColType, getDefaultFormat, getXDrillInfo, removeChangeListener, setColumnIdentifier, setLeftAlign, setLocal |
| Methods inherited from class java.lang.Object |
|---|
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Methods inherited from interface inetsoft.report.TableLens |
|---|
addChangeListener, containsDrill, containsFormat, getDefaultFormat, getXDrillInfo, removeChangeListener |
| Methods inherited from interface inetsoft.uql.XTable |
|---|
getColType, setColumnIdentifier |
| Constructor Detail |
|---|
public FormulaTableLens(TableLens table,
String[] headers,
String[] formulas,
ReportSheet report)
table - original table.headers - the column headers used for corresponding formula.formulas - formulas used to create new columns.
public FormulaTableLens(TableLens table,
String[] headers,
String[] formulas,
inetsoft.util.script.ScriptEnv senv,
Object scope)
table - original table.headers - the column headers used for corresponding formula.formulas - formulas used to create new columns.
public FormulaTableLens(TableLens table,
String[] headers,
String[] formulas,
inetsoft.util.script.ScriptEnv senv,
Object scope,
Boolean[] mergeables)
table - original table.headers - the column headers used for corresponding formula.formulas - formulas used to create new columns.mergeables - sql formulas can merge or not.| Method Detail |
|---|
public void setFormulaHeaderInfo(Vector hinfos)
public int getBaseRowIndex(int row)
getBaseRowIndex in interface TableFilterrow - row index in the filtered table.
public int getBaseColIndex(int col)
getBaseColIndex in interface TableFiltercol - column index in the filtered table.
public TableLens getTable()
getTable in interface TableFilterpublic void setTable(TableLens table)
setTable in interface TableFilterpublic void setTableName(String tname)
public boolean isRestricted(int col)
col - the column index
public void setRestricted(int col,
boolean restricted)
col - the column index to setrestricted - true to restrict, false otherwisepublic void clearCache()
clearCache in interface inetsoft.report.internal.table.CachedTableLenspublic void invalidate()
invalidate in interface TableFilterpublic boolean moreRows(int r)
moreRows in interface XTablemoreRows in class AbstractTableLensr - row number.
public int getRowCount()
getRowCount in interface XTablepublic int getColCount()
getColCount in interface XTable
public void setColType(int col,
Class type)
public void setAlignTypes(Class[] aligntypes)
public int getHeaderRowCount()
getHeaderRowCount in interface XTablegetHeaderRowCount in class AbstractTableLenspublic int getHeaderColCount()
getHeaderColCount in interface XTablegetHeaderColCount in class AbstractTableLenspublic int getTrailerRowCount()
getTrailerRowCount in interface XTablegetTrailerRowCount in class AbstractTableLenspublic int getTrailerColCount()
getTrailerColCount in interface XTablegetTrailerColCount in class AbstractTableLenspublic int getRowHeight(int row)
getRowHeight in interface TableLensgetRowHeight in class AbstractTableLenspublic int getColWidth(int col)
getColWidth in interface TableLensgetColWidth in class AbstractTableLens
public Color getRowBorderColor(int r,
int c)
getRowBorderColor in interface TableLensgetRowBorderColor in class AbstractTableLensr - row number.c - column number.
public Color getColBorderColor(int r,
int c)
getColBorderColor in interface TableLensgetColBorderColor in class AbstractTableLensr - row number.c - column number.
public int getRowBorder(int r,
int c)
getRowBorder in interface TableLensgetRowBorder in class AbstractTableLensr - row number.c - column number.
public int getColBorder(int r,
int c)
getColBorder in interface TableLensgetColBorder in class AbstractTableLensr - row number.c - column number.
public Insets getInsets(int r,
int c)
getInsets in interface TableLensgetInsets in class AbstractTableLensr - row number.c - column number.
public Dimension getSpan(int r,
int c)
getSpan in interface TableLensgetSpan in class AbstractTableLensr - row number.c - column number.
public int getAlignment(int r,
int c)
getAlignment in interface TableLensgetAlignment in class AbstractTableLensr - row number.c - column number.
public Font getFont(int r,
int c)
getFont in interface TableLensgetFont in class AbstractTableLensr - row number.c - column number.
public boolean isLineWrap(int r,
int c)
isLineWrap in interface TableLensisLineWrap in class AbstractTableLensr - row number.c - column number.
public Color getForeground(int r,
int c)
getForeground in interface TableLensgetForeground in class AbstractTableLensr - row number.c - column number.
public Color getBackground(int r,
int c)
getBackground in interface TableLensgetBackground in class AbstractTableLensr - row number.c - column number.
public final boolean isPrimitive(int col)
isPrimitive in interface XTableisPrimitive in class AbstractTableLens
public final boolean isNull(int r,
int c)
isNull in interface XTableisNull in class AbstractTableLensr - the specified row index.c - column number.
public Object getObject(int r,
int c)
getObject in interface XTabler - row number.c - column number.
public final double getDouble(int r,
int c)
getDouble in interface XTablegetDouble in class AbstractTableLensr - the specified row index.c - column number.
public final float getFloat(int r,
int c)
getFloat in interface XTablegetFloat in class AbstractTableLensr - the specified row index.c - column number.
public final long getLong(int r,
int c)
getLong in interface XTablegetLong in class AbstractTableLensr - the specified row index.c - column number.
public final int getInt(int r,
int c)
getInt in interface XTablegetInt in class AbstractTableLensr - the specified row index.c - column number.
public final short getShort(int r,
int c)
getShort in interface XTablegetShort in class AbstractTableLensr - the specified row index.c - column number.
public final byte getByte(int r,
int c)
getByte in interface XTablegetByte in class AbstractTableLensr - the specified row index.c - column number.
public final boolean getBoolean(int r,
int c)
getBoolean in interface XTablegetBoolean in class AbstractTableLensr - the specified row index.c - column number.
public void setObject(int r,
int c,
Object val)
setObject in interface XTablesetObject in class AbstractTableLensr - row index.c - column index.val - cell value.public TableDataDescriptor getDescriptor()
getDescriptor in interface TableLensgetDescriptor in interface XTablegetDescriptor in class AbstractTableLenspublic boolean containsAttribute(String attributeName)
attributeName - the name of the attributepublic void dispose()
dispose in interface XTabledispose in class AbstractTableLenspublic String getColumnIdentifier(int col)
getColumnIdentifier in interface XTablegetColumnIdentifier in class AbstractTableLenscol - the specified column index.
|
Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved. | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||