Create Computed Column

You can create functions that can be used for a particular query.  This is advantageous because it allows you to quickly and easily create these functions without the hassle of writing formulas.

The following window is shown




The functions found here are not JReport system functions.   They are from the connected database you use.  Thus, if you change your data source, some of these functions may no longer exist.  For each database, the different supported functions list will be returned.

The following list of functions shown below is to give you some help in writing an expression. We used Access 97 as the database source.  For more detail about any function shown, you should refer back to your database manual.  

String:

• ASCII (string): Returns the ASCII value of the first char in the string
• CHAR (charcode): returns a string contains the character has the value specified by the charcode
• CONCAT(string,string): returns a string concatenation of two expressions
• LCASE (string): Converts to lower case
• LEFT (string,length): Returns a string containing a specified number of chars from left side               
• LENGTH (string): Returns the length of string
• LTRIM (string): Deletes the leading space of the string
• RIGHT (string,length): Returns a string containing a specified number of chars from the right side
• RTRIM (string): Deletes the trailing space of the string  
• SPACE(number): Adds the specified number spaces  
• UCASE (string): Coverts to upper case
  

Numeric:

• ABS (number) : return Absolute value
• ATAN (number): return the arctangent of a number.
• CEILING (): does not know
• COS (number): Cosine
• EXP (number): Exponential
• LOG (number): Logarithm
• MOD (number,number): return the remainder
• RAND (number):  return a random number
• SIGN (number): return a number t o indicate the sign of a number
• SIN (): Sine
• SQRT (): Square Root
• TAN (): Tangent
  

+ icon: Add numbers or fields together in the Expression menu.
-  icon: Subtract numbers or fields together in the Expression menu.
*  icon: Multiply numbers or fields together in the Expression menu.
/  icon: Divide numbers or fields together in the Expression menu.

= icon: Equate fields together
"  icon: Place quotations on long character strings or name that have blanks in them (example: place quotes on values like "New York" or "Washington DC")
||  icon: Allows you to place fields together in the same Expression menu. (example: "New York" || "Washington DC")
( ) icon: Place your fields in parentheses