Odd charting issue on report

[Derek]

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.

[Elian]

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

[Derek]

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.