Jump to content
Changes to the Jaspersoft community edition download ×

How to see Customised Fields


2004 IR Help

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...