Big problem with piechart

[AsyNew]

Hi,

I'am using the ireport 0.5.3.

I want create report that contains a piechart: that is the problem and i don't know why noone never had the same problem.

So to create a pie chart we need to have "a key expression" (like $F{name}) "a value expression" like (like ${number}). According to each name we have a number.

But in my case , i need to represent for exemple for the same 'name' the value of 'number1' and value of 'number2' in a piechart, i really don't how to do.

I hope you will help, you are my last chance, please help!!!

[nittu02]

It depends upon on what basis you are taking the number 1 and number 2 values right?? you need to put that expression in the key expression there. Or, if you are saying you need to put the same expression and different values, in the query, put the static value for the field you are selecting.

[nittu02]

It depends upon on what basis you are taking the number 1 and number 2 values right?? you need to put that expression in the key expression there. Or, if you are saying you need to put the same expression and different values, in the query, put the static value for the field you are selecting.

[AsyNew]

Well, actually i need two key expression ans two value expression , something like series in the bar chart.

To be more clear, i will show my real sql query:

 

select sum(HN),sum(HS) from table where number="XX"

HN :(official hour)

HS : (non official hour)

 

So in my pie chart i need to represent the value of both sum(HN),sum(HS) .

[AsyNew]

No one has an idea??!!

[dpinfo]

Your query is :

 

select sum(HN),sum(HS) from table where number="XX"

 

you need to create a new query like this

 

select TYPE_HOURS,TIME from

(select 'OFFICIAL HOUR' AS TYPE_HOURS,SUM(HN) TIME

FROM TABLE

GROUP BY 'OFFICIAL HOUR'

UNION

SELECT 'REAL HOUR' AS TYPE_HOURS,SUM(HS) TIME

FROM TABLE

GROUP BY 'REAL HOUR')

 

The query will show :

 

Official Hours and the total time

Real Hours and he the total time

 

Then you can make a pie chart which will show for the type of hours the value of each one.

 

 

I hope that this help.

 

Bye

[AsyNew]

It's really fantastic!!!! Your solution is absolutly great!

Thank you very very much for your help.

I'am sure that you will help many other people in this forum.:P