Group with chart

[David]

Hi,

I want to know how, if possible, I can put a chart in a group and this chart show the info about this group. I tried to put my chart in the footer Group (where it should be), but I don't know how to specify the group in wich it is. Let's said that I want to make a rapport about the number of gummies inside a gummies machine. My rapport should look like this:

Machine 1
Gummies Color  Gummies Number
Red 150
Green 29
Yellow  87

My chart (pie) should be here and will show the % for each color

Machine 2
...

So, I have three values : The machine number (group) , the colors (details) and the number(details). So, for my chart, I should create a serie and I guess the name of each items of this serie will be the color of the gummies and the value will be the number of gummies with this color. But I tried it this way and it doesn't work. 

Thank you in advance for your answer.
David

[David]

Hi again,

I read this post and tried his solution, but it doesn't work. In short , this topic said the best way to realize my scenario is that each time the chart is "show" at the screen, I get the current grouping value by using DataObject, I create a filtering expression based on this value and apply the result of the expression to the chart. The problem is that the example in the post is in VB and, after I transfert it in C#, the DataObject property doesn't seem to work. So, this solution will surely work, but I first have to find how to get the current grouping value. Does anyone know how to get it ?

Thank you,
David 

[Peter]

Hi David,

In order to achieve your requirement our suggestion is to use a new approach the involves bindings. Just follow these steps:

1. set up the report's data source;
2. add a report group;
3. add a chart item within the group header section with the required series;
4. set a Binding for the Chart.DataSource property with the =ReportItem.DataObject expression. 

Check out the attached example. Just to note that to run the sample report you will need the AdventureWorks database that comes with Telerik Reporting installation.

Regards,
Peter
the Telerik team

[David]

Hi Peter,

Thank you for your answer. It works great, except when I change the dataSource to use a array instead that a sqlDataSource. For some reason, no data are bind to the charts (in preview it said " There is no or empty series"). I also tried a objectDataSource, but the final result was the same. So, does is it me that is doing something wrong, or binding on a dataObject don't work with dataSource bind on a array or objectDataSource?

Thank you for your answer,
David

PS: If you want, I can send you my project in a support ticket.  

[Peter]

Hi David,

This is a known issue related to using binding and ObjectDataSource. It's logged in our bug tracking system and we will introduce a fix in a subsequent Telerik Reporting release. Please excuse us for the temporary inconvenience.

Greetings,
Peter
the Telerik team

[David]

Thank you

[Steve]

Hi David,

Just a quick follow up to let you know that the problem that Chart item cannot be bound with binding expression to ReportItem.DataObject when using ObjectDataSource has been fixed in the Q2 2011 SP1 release.

All the best,
Steve
the Telerik team