highjo
-
Posts
28 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by highjo
-
-
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.6It 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 :
SELECT COUNT(gender) AS total_by_gender, gender ,account_status FROM user_account ua, user_profile up WHERE ua.user_profile_id=up.user_profile_id GROUP BY gender,account_status
[/code]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 saygreen
andUNCONFIRMED
sayred
.For that i added a text field with this expression$F{account_status}.equals("ENABLED") ? "<style forecolor='#ff0000'>" + $F{account_status}.toString() + "</style>" :"<style forecolor='#999999'>" + $F{account_status}.toString() + "</style>"
[/code]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 textunconfirmed
orenabled
.My second problem is that i want to do the total of all
unconfirmed
and allenabled
. 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 -
Hello guys! please excuse me for this simple question post.Trully i've started reading on jasper ireport from saturday and decided to use it.
I'm desiging a report using ireport and wanted to display for now total number of users in a system based on their gender and then print the total of users (all genders). so i have this query " select count(gender) as totalbygender, gender from user_account ua, user_profile up
where ua.email_verified=true and ua.user_profile_id = up.user_profile_id group by up.gender"i drag the fields and all and view the preview .so in order to have that total i've decided to use variables.I've created one , set its class being Long and calculation being in the property files.so in the variable Expression i've written sum($F{totalbygender}) .Since the resultset is in 2rows , i was expecting for example if count for male is 50 and female 60 then the sum would be 110. but in having this error instead.What should i do to achieve my purpose.Thanks
Code:
Post Edited by highjo at 12/21/2009 20:10
Post Edited by highjo at 12/22/2009 09:32
Authentication Required.
in Products
Posted