Reporting Parameter LoadOnDemand

[DM]

I am using the latest version of Telerik Reporting. My Report has 3 parameters that use seperate Datasources for each. One of the Datasource objects returns a large dataset. I would like to know how to implement the same  Load on Demand  functionallity as I use on the RadComboBox Controls Load on Demand. 
It would even work if I had the functionallity like Telerik uses on the ComboBox used when you Select your Country on the Create accout page.

Thanks,
DM 

Example from RadComboBox
protected void RadComboBox2_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
     DataTable data = GetData(e.Text);
}

private static DataTable GetData(string text)
{
     SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from Customers WHERE CompanyName LIKE @text + '%'",
ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", text);

DataTable data = new DataTable();
adapter.Fill(data);

return data;
}

[Steve]

Hi,

The built-in report parameters' purpose is to provide basic UI that is available out of the box and that is enough for most scenarios. For other cases, when you require customization, you can hide all report parameters (Visible=false), create a custom parameter area and wire it up to the Report API e.g. use RadComboBox for ASP.NET AJAX control and pass the input via the report API:

Copy Code

Telerik.Reporting.Report report = (Telerik.Reporting.Report)this.ReportViewer1.Report;
report.ReportParameters["MyParam"].Value = RadComboBox1.SelectedValue;

This way you can implement the load on demand functionality which you require.

All the best,
Steve
the Telerik team