You are correct the datasource parameters approach will result in database query for every subreport instance. Thus if this will cause performance troubles our suggestion is to avoid the datasource parameters approach.
We are not sure about the table filter approach you have in mind. However every table (data item) instance have separate datasource instance. They will not share the same data and separate query will be executed. Thus our suggestion is to create a method with some custom logic that will fill the dataset or you own caching custom type, just once and use the table's NeedDataSource event to call your method and set the datasource as shown in the following code snippet:
sender, EventArgs e)
.productCatalogDataSet.ProductCatalogDataSetTable.Count == 0)
the Telerik team
Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward!
We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>