Displaying ReportParameter DisplayMember in report

[Billy Rawls]

Hello:

I can't seem to figure out how to display a ReportParameter's DisplayMember in a report. The ReportParameter is set via a SQL query.

I am generating the parameter using the code below:

reportParameter1.Name = "ClientId";
reportParameter1.Type = Telerik.Reporting.ReportParameterType.String;
reportParameter1.UI.AllowBlank = false;
reportParameter1.UI.Visible = true;
reportParameter1.UI.AvailableValues.DataSource = ds.Tables[1];
reportParameter1.UI.AvailableValues.DisplayMember = "name_display";
reportParameter1.UI.AvailableValues.ValueMember = "client_id";
this.ReportParameters.Add(reportParameter1);

"client_id" is an int, "name_display" is a string.

I have a textbox on the report that I am attempting to fill in the report's ItemDataBound event like this:

this.tbClientId.Value = string.Format("Client Id = {0}", reportParameter1.Value.ToString());

Obviously this only returns the "client_id" member. I need it to display the "name_display" member. How can I accomplish this?

[Peter]

Hi Billy Rawls,

There are two approaches available to achieve the desired effect. In general you have to access the Processing Report Parameter's Label property as shown below:

1. Set the TextBox value to an Expression:
   Client Id = {Parameters.ClientId.Label}
   
   
2. Within an ItemDataBound event as shown in the following code snippet:

private void textBox2_ItemDataBound(object sender, EventArgs e)
{
    var procTextBox = (Telerik.Reporting.Processing.TextBox)sender;
    procTextBox.Value = procTextBox.Report.Parameters["ClientId"].Label;
}

Kind regards,
Peter
the Telerik team

[Billy Rawls]

Label is not an available property for me when I follow approach 2.

In the mean time I have a different solution in place where I bind the value using in-line SQL. Thanks.

[Steve]

Hi Billy Rawls,

We have introduced this functionality in the Q1 2010 release of Telerik Reporting. So if you want to use the suggested solution, you should upgrade to that or later version.

All the best,
Steve
the Telerik team