3.7.2i. Sum calculating

[braverju]

Hello! I am very new on IReport, but I have experience with Java and some experience with MySQL. I have the following quesiton.  My database looks like this:

Username Q1 Q2 Q3

I have to report a total score (Q1 + Q2 + Q3) for each user. How can I do it with I-Report 3.7.2i?

 

Thank you.

Julia

[despec]

Hello,

 

I would take care of it in the query.  For example:

 

select

  USER,

  Q1+Q2+Q3  as user_total

from

  (your table name)

 

Hope this helps,

David

Post Edited by despec at 07/21/2010 20:29