Odd charting issue on report

3 posts, 1 answers
  1. Derek
    Derek avatar
    118 posts
    Member since:
    Oct 2008

    Posted 26 Nov 2011 Link to this post

    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. Answer
    Elian
    Admin
    Elian avatar
    435 posts

    Posted 28 Nov 2011 Link to this post

    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!

  3. DevCraft banner
  4. Derek
    Derek avatar
    118 posts
    Member since:
    Oct 2008

    Posted 28 Nov 2011 Link to this post

    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.
Back to Top