This is a migrated thread and some comments may be shown as answers.

Odd charting issue on report

2 Answers 20 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Derek
Top achievements
Rank 1
Derek asked on 26 Nov 2011, 02:22 PM
We have a simple report, that lists people by group and gender. The report combines a table and a chart. The table appears accurately, but the chart seems to move the values around so that the values appear under different groups. You can see what I mean from the attached screen shot.

The chart is configured as follows; default type is stacked bar, xaxis.datalabelscolumn is groupname, datagroupcolumn  is gender.

The data source has three columns; groupname, gender, and a count.
ACFN    Male    1
FMFN    Female    1
FMFN468    Female    1
N-CAN    Male    1
OABO    Male    2
OCAN    Male    1
OLNA    Male    1

Both genders don't always show up in the result set for any specific group; could that be the issue?

Any and all suggestions are appreciated.

2 Answers, 1 is accepted

Sort by
0
Accepted
Elian
Telerik team
answered on 28 Nov 2011, 06:16 PM
Hi Derek,

Currently this scenario can be achieved only with code. Here is a a forum thread discussing how to do this. You will have to build up the series in code and take into consideration the null values (so the bars match the axis labels);

All the best,
Elian
the Telerik team

Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

0
Derek
Top achievements
Rank 1
answered on 28 Nov 2011, 07:21 PM
Thanks for the clarification; that's what I thought.

I think this is appropriate as a feature request. I note that the crosstab object is able to deal with missing values, and with a busy chart this kind of discrepancy might get overlooked. In the real world there are often missing values in a result set.
Tags
General Discussions
Asked by
Derek
Top achievements
Rank 1
Answers by
Elian
Telerik team
Derek
Top achievements
Rank 1
Share this question
or