This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Sum of columns in iReport

 
Kunal Lakhani
Ranch Hand
Posts: 622
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using iReport for developing report
I am using joins for getting data from 4 different tables mysql.
For getting the sum of columns i am using the expression "new Double($F{a}.doubleValue()+$F{b}.doubleValue()+$F{c}.doubleValue())", where a,b,c are in tables a,b,c respectively.
if value of a is null, then the overall sum returned is null regardless of value in b and c column.
For example, row with id 1 is not present in table a, table b, but exists in table c, but still the overall sum returned is null
How to solve this problem?
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic