Hello!
I'm trying to get myself used to jasperforge ireport before using it in a real project next week and i seem to be stacked somewhere already .i'm using ireport 3.7.0 on windows xp platform + java 1.6
It sound easy to get a field color changed based on what it contains or calculate a sum of number in a field based on conditions but in practice it's taking me too much time to accomplish. I have a query say :
<span class="pln">SELECT COUNT</span><span class="pun">(</span><span class="pln">gender</span><span class="pun">)</span><span class="pln"> AS total_by_gender</span><span class="pun">,</span><span class="pln"> gender </span><span class="pun">,</span><span class="pln">account_status FROM user_account ua</span><span class="pun">,</span><span class="pln"> user_profile up WHERE ua</span><span class="pun">.</span><span class="pln">user_profile_id</span><span class="pun">=</span><span class="pln">up</span><span class="pun">.</span><span class="pln">user_profile_id GROUP BY gender</span><span class="pun">,</span><span class="pln">account_status<br /></span>
it gives me something like this:
| total_by_gender | gender | account_status |
| 160 |Female | ENABLED |
| 26 |Female | UNCONFERIMED |
| 100 |Male | ENABLED |
| 10 |Male | UNCONFIRMED | Now i want the ENABLED Text to Look say green and UNCONFIRMED say red.For that i added a text field with this expression
<span class="pln">$F</span><span class="pun">{</span><span class="pln">account_status</span><span class="pun">}.</span><span class="pln">equals</span><span class="pun">(</span><span class="str">"ENABLED"</span><span class="pun">)</span><span class="pln"> </span><span class="pun">?</span><span class="pln"> </span><span class="str">"<style forecolor='#ff0000'>"</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> $F</span><span class="pun">{</span><span class="pln">account_status</span><span class="pun">}.</span><span class="pln">toString</span><span class="pun">()</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> </span><span class="str">"</style>"</span><span class="pln"> </span><span class="pun">:</span><span class="str">"<style forecolor='#999999'>"</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> $F</span><span class="pun">{</span><span class="pln">account_status</span><span class="pun">}.</span><span class="pln">toString</span><span class="pun">()</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> </span><span class="str">"</style>"</span><span class="pln"> <br /></span><span class="pln"><br /></span>
well for each of them it gives me something like the same text like <style> (i think it's printing all the condition expression) instead of colored text unconfirmed or enabled.
My second problem is that i want to do the total of all unconfirmed and all enabled. i can do normal sum expression but with condition i don't have any idea. Can anyone shed some light? thanks for reading. i hope this time i'll get a response to my post
