EspressReport 6.6

quadbase.reportdesigner.lang
Class NumericObject

java.lang.Object
  extended by quadbase.reportdesigner.lang.NumericObject
All Implemented Interfaces:
IObject, IFunctionConstants

public class NumericObject
extends java.lang.Object
implements IObject, IFunctionConstants

This class is used to implement formulas for columns contain numeric data


Field Summary
 
Fields inherited from interface quadbase.util.IFunctionConstants
ABS, ACOS, ADD, ADDTIME, AM_PM, AND, ASIN, ATAN, ATAN2, AVERAGE, B_COL, BOOL, BOOL_FUNC, BOOL_NAME, CALENDAR_CONST, CEIL, COL, COS, COUNT, CURRDATE, CURRDATETIME, CURRTIME, D_COL, DATE, DATE_FUNC, DATE_NAME, DATETIME, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_WEEK_IN_MONTH, DAY_OF_YEAR, DAYDIFF, DAYOFWEEK, DECL, DIVIDE, E, EQUALS, ERA, EXP, FACTORIAL, FALSE, FLOOR, GETAMPM, GETERA, GETMONTH, GREATER, GREATEREQUAL, HOUR, HOUR_OF_DAY, ID, IEEEREMAINDER, IFELSE_B, IFELSE_D, IFELSE_N, IFELSE_S, INDEXOF, INSERT, LASTINDEXOF, LESS, LESSEQUAL, LOG, MAX, MAXLENGTH, MEDIAN, MILLISECOND, MIN, MINUTE, MOD, MONTH, MULTIPLY, N_COL, NAND, NEW_DATE_NAME, NEW_NUM_NAME, NEW_STR_NAME, NOR, NOT, NUM, NUM_FUNC, NUM_NAME, OR, OTHER_FUNC_NAME, PAGE, PARAM, PI, POW, PRINTDATE, PRINTDATETIME, PRINTTIME, RANDOM, REPLACE, RINT, ROLLTIME, S_COL, SECOND, SIN, SQRT, STDDEV, STR, STR_FUNC, STR_NAME, STRCAT, STRLEN, SUBSTRING, SUBTRACT, SUMSQUARE, TAN, TD_FUNC_NAME, THIS, TODATE, TODEGREES, TOLOWERCASE, TONUMERIC, TORADIANS, TOSTRING, TOTALPAGES, TOTALSECTIONS, TOUPPERCASE, TRUE, VARIANCE, WEEK_OF_MONTH, WEEK_OF_YEAR, WITHIN, XNOR, XOR, YEAR
 
Constructor Summary
  NumericObject(byte val)
          Create a new NumericObject using specified byte
  NumericObject(double number)
          Create a new NumericObject using specified double
  NumericObject(float number)
          Create a new NumericObject using specified float
  NumericObject(int number)
          Create a new NumericObject using specified int
  NumericObject(long number)
          Create a new NumericObject using specified long
  NumericObject(short number)
          Create a new NumericObject using specified short
protected NumericObject(java.lang.String formula, int sqlType)
          Create a new NumericObject using specified formula and SQL type
 
Method Summary
static NumericObject abs(NumericObject a)
          Absolute of the NumericObject
static NumericObject acos(NumericObject a)
          Arc cosine of specified NumericObject
static NumericObject add(NumericObject[] f)
          Add every element of the NumericObject array
static NumericObject add(NumericObject f1, NumericObject f2)
          Add the two NumericObjects
static NumericObject asin(NumericObject a)
          Arc sine of specified NumericObject
static NumericObject atan(NumericObject a)
          Arc tan of specified NumericObject
static NumericObject atan2(NumericObject a, NumericObject b)
          Arc tan of specified NumericObjects.
static NumericObject average(NumericObject[] f)
          Average of the elements of the NumericObject array
static NumericObject ceil(NumericObject a)
          Ceiling of the NumericObject
static NumericObject cos(NumericObject a)
          Cosine of specified NumericObject
static NumericObject count(NumericObject[] f)
          Number of elements in the NumericObject array
static NumericObject divide(NumericObject numerator, NumericObject denominator)
          Divide numerator by denominator
static NumericObject e()
          Base of natural log
static NumericObject exp(NumericObject a)
          Exponential raised to the power of the NumericObject
static NumericObject factorial(NumericObject a)
          Factorial of the specified NumericObject
static NumericObject floor(NumericObject a)
          Floor of the NumericObject
static NumericObject getColumnValue(int colInfoIndex)
          Returns the column value of the specific column
static NumericObject getColumnValue(int colInfoIndex, int sqlType)
          Returns the column value of the specified column
static NumericObject getColumnValue(int colInfoIndex, short aggregation)
          Returns the Column value of specified column after doing the specified aggregation.
static NumericObject getColumnValue(int colInfoIndex, short aggregation, int sqlType)
          Returns the Column value of specified column after doing the specified aggregation.
static NumericObject getColumnValue(NumericObject colInfoIndex, int sqlType)
          Returns the column value of the specified column
static NumericObject getColumnValue(NumericObject colInfoIndex, short aggregation, int sqlType)
          Returns the Column value of specified column after doing the specified aggregation.
 java.lang.String getFormula()
          Returns the formula
 int getSQLType()
          Returns the SQL type
static NumericObject IEEERemainder(NumericObject dividend, NumericObject divisor)
          Computes the remainder operator on two arguments based on the IEEE754 standard
static NumericObject log(NumericObject a)
          Natural log of the NumericObject
static NumericObject max(NumericObject[] f)
          Returns maximum from the elements of the NumericObject array
static NumericObject max(NumericObject a, NumericObject b)
          Returns maximum from the two NumericObjects
static NumericObject min(NumericObject[] f)
          Returns manimum from the elements of the NumericObject array
static NumericObject min(NumericObject a, NumericObject b)
          Returns manimum from the two NumericObjects
static NumericObject mod(NumericObject numerator, NumericObject denominator)
          Returns the remainder after dividing denominator from numerator
static NumericObject multiply(NumericObject[] f)
          Multiply every element of the NumericObject array
static NumericObject multiply(NumericObject f1, NumericObject f2)
          Multiply the two NumericObjects
static NumericObject pi()
          Pi value
static NumericObject pow(NumericObject a, NumericObject b)
          Computers b raised to a
static NumericObject random()
          Random number generator
static NumericObject rint(NumericObject a)
          Double value closest to a and equal to a integer
static NumericObject sin(NumericObject a)
          Sine of specified NumericObject
static NumericObject sqrt(NumericObject a)
          Square root of the NumericObject
static NumericObject standardDeviation(NumericObject[] f)
          Standard Deviation of the elements of the NumericObject array
static NumericObject subtract(NumericObject[] f)
          Subtract the rest elements of NumbericObject array from the first element
static NumericObject subtract(NumericObject f1, NumericObject f2)
          Subtract NumericObject f2 from NumericObject f1
static NumericObject sumSquare(NumericObject[] f)
          Adds the squares of the elements of the NumericObject array
static NumericObject tan(NumericObject a)
          Tan of specified NumericObject
static NumericObject toDegrees(NumericObject angrad)
          Converts angle in radians to degrees
static NumericObject toRadians(NumericObject angdeg)
          Converts angle in degrees to radians
static StringObject toString(NumericObject a)
          Convert NumericObject to string
static StringObject toString(NumericObject a, NumericObject dp)
          Convert NumericObject to string with specified round up decimal point
static StringObject toString(NumericObject a, NumericObject dp, BooleanObject rup)
          Convert NumericObject to string with specified decimal point
static NumericObject variance(NumericObject[] f)
          Variance of the elements of the NumericObject array
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

NumericObject

public NumericObject(short number)
Create a new NumericObject using specified short


NumericObject

public NumericObject(int number)
Create a new NumericObject using specified int


NumericObject

public NumericObject(long number)
Create a new NumericObject using specified long


NumericObject

public NumericObject(float number)
Create a new NumericObject using specified float


NumericObject

public NumericObject(double number)
Create a new NumericObject using specified double


NumericObject

public NumericObject(byte val)
Create a new NumericObject using specified byte


NumericObject

protected NumericObject(java.lang.String formula,
                        int sqlType)
Create a new NumericObject using specified formula and SQL type

Method Detail

getFormula

public java.lang.String getFormula()
Returns the formula

Specified by:
getFormula in interface IObject

getSQLType

public int getSQLType()
Returns the SQL type

Specified by:
getSQLType in interface IObject

getColumnValue

public static NumericObject getColumnValue(int colInfoIndex)
Returns the column value of the specific column


getColumnValue

public static NumericObject getColumnValue(int colInfoIndex,
                                           int sqlType)
Returns the column value of the specified column


getColumnValue

public static NumericObject getColumnValue(NumericObject colInfoIndex,
                                           int sqlType)
Returns the column value of the specified column


getColumnValue

public static NumericObject getColumnValue(int colInfoIndex,
                                           short aggregation)
Returns the Column value of specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants


getColumnValue

public static NumericObject getColumnValue(int colInfoIndex,
                                           short aggregation,
                                           int sqlType)
Returns the Column value of specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants


getColumnValue

public static NumericObject getColumnValue(NumericObject colInfoIndex,
                                           short aggregation,
                                           int sqlType)
Returns the Column value of specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants


add

public static NumericObject add(NumericObject f1,
                                NumericObject f2)
Add the two NumericObjects


add

public static NumericObject add(NumericObject[] f)
Add every element of the NumericObject array


subtract

public static NumericObject subtract(NumericObject f1,
                                     NumericObject f2)
Subtract NumericObject f2 from NumericObject f1


subtract

public static NumericObject subtract(NumericObject[] f)
Subtract the rest elements of NumbericObject array from the first element


multiply

public static NumericObject multiply(NumericObject f1,
                                     NumericObject f2)
Multiply the two NumericObjects


multiply

public static NumericObject multiply(NumericObject[] f)
Multiply every element of the NumericObject array


divide

public static NumericObject divide(NumericObject numerator,
                                   NumericObject denominator)
Divide numerator by denominator


mod

public static NumericObject mod(NumericObject numerator,
                                NumericObject denominator)
Returns the remainder after dividing denominator from numerator


IEEERemainder

public static NumericObject IEEERemainder(NumericObject dividend,
                                          NumericObject divisor)
Computes the remainder operator on two arguments based on the IEEE754 standard


acos

public static NumericObject acos(NumericObject a)
Arc cosine of specified NumericObject


cos

public static NumericObject cos(NumericObject a)
Cosine of specified NumericObject


asin

public static NumericObject asin(NumericObject a)
Arc sine of specified NumericObject


sin

public static NumericObject sin(NumericObject a)
Sine of specified NumericObject


atan

public static NumericObject atan(NumericObject a)
Arc tan of specified NumericObject


atan2

public static NumericObject atan2(NumericObject a,
                                  NumericObject b)
Arc tan of specified NumericObjects. Converts rectangular coordinates (a, b) to polar (r, thetha)


tan

public static NumericObject tan(NumericObject a)
Tan of specified NumericObject


ceil

public static NumericObject ceil(NumericObject a)
Ceiling of the NumericObject


exp

public static NumericObject exp(NumericObject a)
Exponential raised to the power of the NumericObject


floor

public static NumericObject floor(NumericObject a)
Floor of the NumericObject


log

public static NumericObject log(NumericObject a)
Natural log of the NumericObject


toDegrees

public static NumericObject toDegrees(NumericObject angrad)
Converts angle in radians to degrees


toRadians

public static NumericObject toRadians(NumericObject angdeg)
Converts angle in degrees to radians


pow

public static NumericObject pow(NumericObject a,
                                NumericObject b)
Computers b raised to a


random

public static NumericObject random()
Random number generator


rint

public static NumericObject rint(NumericObject a)
Double value closest to a and equal to a integer


sqrt

public static NumericObject sqrt(NumericObject a)
Square root of the NumericObject


abs

public static NumericObject abs(NumericObject a)
Absolute of the NumericObject


max

public static NumericObject max(NumericObject a,
                                NumericObject b)
Returns maximum from the two NumericObjects


max

public static NumericObject max(NumericObject[] f)
Returns maximum from the elements of the NumericObject array


min

public static NumericObject min(NumericObject a,
                                NumericObject b)
Returns manimum from the two NumericObjects


min

public static NumericObject min(NumericObject[] f)
Returns manimum from the elements of the NumericObject array


pi

public static NumericObject pi()
Pi value


e

public static NumericObject e()
Base of natural log


count

public static NumericObject count(NumericObject[] f)
Number of elements in the NumericObject array


sumSquare

public static NumericObject sumSquare(NumericObject[] f)
Adds the squares of the elements of the NumericObject array


average

public static NumericObject average(NumericObject[] f)
Average of the elements of the NumericObject array


variance

public static NumericObject variance(NumericObject[] f)
Variance of the elements of the NumericObject array


standardDeviation

public static NumericObject standardDeviation(NumericObject[] f)
Standard Deviation of the elements of the NumericObject array


factorial

public static NumericObject factorial(NumericObject a)
Factorial of the specified NumericObject


toString

public static StringObject toString(NumericObject a)
Convert NumericObject to string


toString

public static StringObject toString(NumericObject a,
                                    NumericObject dp)
Convert NumericObject to string with specified round up decimal point


toString

public static StringObject toString(NumericObject a,
                                    NumericObject dp,
                                    BooleanObject rup)
Convert NumericObject to string with specified decimal point


EspressReport 6.6