One DataSource, 2 Report Items

[sitefinitysteve]

Ok, lets say in my report I setup a SqlDS which points to a stored procedure

Then inside the Detail portion I drop in a crosstab wizard and a table wizard and link them into the SQLDS

Is the SqlDS being called twice?

I'm running into a problem right now where if I add in the table I go from 3 second report generation to infinite generating icon.

(The DS is 21,000 rows)

[Peter]

Hi Steve,

Currently the data is being retrieved for every report data item. The declarative DataSource components don't store the data in order to avoid large memory allocation. Generally retrieving 21000 rows of data should take a few seconds, thus in most cases retrieving data is not the bottleneck, but the actual rendering. However if in your case retrieving the data is time consuming operation our suggestion is to create a method with some custom logic that will fill a dataset just once and use the table's NeedDataSource event to call your methods and set the datasource as shown in the following code snippet:

private void table1_NeedDataSource(object sender, EventArgs e)
{
    ((Telerik.Reporting.Processing.Table)sender).DataSource = this.getData();
}

private void table2_NeedDataSource(object sender, EventArgs e)
{
    ((Telerik.Reporting.Processing.Table)sender).DataSource = this.getData();
}

private object getData()
{
    if (this.productCatalogDataSet.ProductCatalogDataSetTable.Count == 0)
    {
        this.productCatalogDataSetTableAdapter1.Fill(this.productCatalogDataSet.ProductCatalogDataSetTable);
    }

    return this.productCatalogDataSet.ProductCatalogDataSetTable;
}

Greetings,
Peter
the Telerik team