Reuse DataSource for multiple parts of report

[Christopher]

I have a report that is made up of four different charts, that all use the same data, just grouped and displayed differently.  Originally, I had them all pointing to the same DataSource, but then found that it was running the same exact query four times, one for each part.  Then I came across this thread: http://www.telerik.com/forums/multiple-database-hits-for-same-datasource which seems to explain the solution.  I tried the proposed solution, which is setting the top-level Report's DataSource to the DataSource I want, and then for each part, setting a Binding of DataSource = ReportItem.DataObject .  However, what I get instead, is that the entire report is repeated multiple times, one for each row in the data.  Now the query is run way more than four times!  What is going on?  Why does the solution work differently now?  Did something change in the way it works?  How do we implement this now? 

[Katia]

Hi Christopher,

When the report's DataSource property is set the Detail section will be repeated for each row from the data source. This means that if the Graph item is placed inside the Detail section it will be repeated for each row from report's data source.

The solution would be to place the Graph item inside the section that is repeated once, for GroupHeader section of a static group or ReportHeader section. 
More information about report sections is available in Report Structure help article.


Regards,
Katia
Telerik by Progress