Chart

[deepthirohini86]

Hi,

 I need to add more than one category expression and value expression for stacked Bar chart in ireport-nb-3.5.1.

But there is no option in ireport-nb-3.5.1 to add more than one category expression and value expression,

but it is having one option,  Right click the chart area->chartdata->Details and we can add but it is asking all the inputs say for (Series Expression,Category Expression,Value Expression),etc and it is not doing what i need.

But i need to achieve the following.

For one Category Expression i need to have more than one Value Expression.

Can any one suggest me how to achieve this.

 

Regards,

Rohini

 

 

[dnvsrikanth]

Hi rohini,

 

In a chart these values - Series Expression,Category Expression,Value Expression are mandatory fields they are the fields that are to be given compulsorily.

 

If you want to have one Value expression for one category expression, I will describe you one example, lets see you can understand or not,

If you have one superset and subset of values, specify the superset in series expression and the subset in category expression and set the reset-group of chart to the category-expression.

 

DNV Srikanth

[deepthirohini86]

Hi Srikanth,

             Thanks for ur reply. I tried whatever u r telling but i am not get the reset-group as visible in the chart data.

Actually i will tell you what structure of datas i am having,

I am having a table like this

select log_date,total,used,free  from log_details;

 

So in my stacked bar i want to show a bar with used with used part as  50 percent and the free with 20.

So it needs to display stacked for used log and free log in a bar.

I need to show like this,

 

 

70 |              +---------+

     |              |           |  -> Free 20

     |              +---------+

     |              |           |

     |              |           | -> Used 50

     |              |           |

     |             +----------+

     ----------------------------------------------------

                    date

 

I need to show the following the stacked bar,

For this i search in this forums itself they are telling that we need to write the customized class.

so kindly tell me whether the following can achieve with the normal ireport itself or we need to write the customized class.

 

Thanks,

Rohini

[deepthirohini86]

I found this how to do this,

i add like this in ireport-nb-3.5.0

 

 

click chartdata

Add the series,category,value for the first part that is Used Expression,

Then add the another series,category,value for the second part that is Free Expression.

 

Now if u run it will show u the stacked bar.

 

Regards,

Rohini A.M