How can multiple charts share a datasource?

[Samuel Santiago]

I have a report with two charts on it.  The report has a particular datasource and the charts have a different datasource, but both charts use the same.  The Stored Procedure for the charts is called twice - once for each chart.  I was hoping to prevent this behavior.  Is there anyway to bind the 2nd charts datasource to the first chart?  I found this article:

http://www.telerik.com/community/forums/reporting/telerik-reporting/set-datasource-of-table-same-as-report-data-source.aspx

Which talks about sharing the Report's datasource.  I have not been able to figure out how to get two child objects (the charts) to share a datasource.  Any ideas out there?  Any tips greatly appreciated.

Thanks,

Sam

[Peter]

Hi Samuel Santiago,

Currently the SqlDataSource is retrieving the data for every data item and we do not cache the retrieved data. If your stored procedure is slowing down the report you have two options:

• The article you've referenced explains how to use the same datasource for a container data item (the report) and a Table item and this is not applicable for your scenario. However if you haven't set a datasource to the report itself you can move your charts to the Report Header, set the SqlDataSource to the report and use the Bindings property of the Chart items to bind it to the same datasource as the report by using the following expression: =ReportItem.DataObject.
• Another solution will be to retrieve your data in a collection and bind the Charts to an ObjectDataSource component.

Regards,
Peter
the Telerik team