Not Showing correct data in chart

Hi ,

I am using BIRT 2.3.1.
I have designed a chart using crosstab.
In crosstab i calculated percentage.
When i designed chart using crosstab, it was not showing Percentage filed.
So i inserted manually data["Percentage"] in series ares. after that in X axis i inserted data["time"].
In grouping field i inserted data["industry"].
In perview birt was showing me correct data .

But When i deployed it and show report using tomcat,
chart was not able to group the data. It is showing 100% for every time range.

can any one tell me, then hy it was showing me correct data in perview.

Thanks,
Sumit

Find more posts tagged with

Comments

mwilliams

Hi Sumit,

Can you recreate this issue with the sample database so that I can see exactly what your issue is? Thanks.

SumitSingh

Thanks Michael.

Suppose i have following dataset:

time department count
2008(Q1) Adimn 24
2008(Q2) Admin 46
2008(Q1) Management 56
2008(Q2) Management 50
2008(Q1) Finance 34
2008(Q2) Finance 76

I have following data in my crosstab.
Admin Management Finance
2008(Q1) 24 56 34
2008(Q2) 46 50 76

But I want Percentage instaed of count something like:

Admin Management Finance
2008(Q1) 21.05% 49.12% 29.82%
2008(Q2) 26.74% 29.06% 44.18%

so i took grand total on row basis and devied each count with this grand total.

If I see crosstab in tabular format it shows me right data.
I want to see data in chart.
so i selected chart view of crosstab. As Percentage was not measure so it was not shown in dropdown list in Select Data Tab. So i inserted manually correct value and Fortunately it was showing me correct data in perview.
When i deployed the report on linux server and view result using Tomacat the was showing worng data.

I feel its hard to expalin in text.
If it is not sufficiant, I will send you some more details.

Thanks,
Sumit

mwilliams

Sumit,

Can you put the data from above in a flat file and create an example using it that I can run. You say you put data["percentage"] in the series area. I am unable to change this value in the chart editor. Are you manually entering the percentages into your dataSet? so they can be used in the crosstab? Let me know. Creating an example I can run would be the best. Thanks.

SumitSingh

Hi,

I have uploaded the sample data file.
Please let me know if you want anything else.

Thanks,
Sumit

mwilliams

Sumit,

If you could create a simple .rptdesign file with your exact setup using this data in a flat file dataSource, that'd be great. Thanks.

SumitSingh

Hi Michael,

I have attached zip file which contains sample report.
This report have Count,Percentage and chart view of percentage.
In preview all works fine.
When we deploy this report, the percentage Chart View does not show correct data.

I have also attached csv file of data.

Thanks,
Sumit

mwilliams

Sumit,

What preview does it work for you in? In the chart editor, I see all the lines at 100%. In the preview tab, I see the same. Let me know. I'll try this in later BIRT versions to see if anything has changed.

mwilliams

Sumit,

It works as expected in BIRT 2.5.1. So, if you can upgrade at all, it works.