How to see Customised Fields

[2004 IR Help]

By: anuj - anujs_iitd

How to see Customised Fields

2004-07-01 04:35

I want to see Customised Fields like (maths+physics)/3

 

i run the query as

 

select (maths+physics)/3 from students in ireport but it says that the corresponding field does not exist which is true as teh field are maths and physics

 

helppppppppppppppppppp

 

 

 

 

By: Giulio Toffoli - gt78

RE: How to see Customised Fields

2004-07-01 09:05

 

try to use an alias for the field in query like:

 

select (maths+physics)/3 as CALC_FIELD from students

 

or use this query:

 

select maths, physics from students

 

with this expressiom:

 

new Integer( ($F{maths}.intValue()+$F{physics}) / 3)

 

U can return a Double if you need decimals.

 

Giulio