Parameter ComboBox Selected Value

[Jaymie]

Good morning,
I am having an issue with reporting and getting the selected value of a databound combobox. The value only returns the selectedItem.Text of the combobox and I wish to get the selectedValue instead.
Could you let me know what the code would be to achieve this please?

The Lists are defined as:

    Public Shared Function ReturnTypes() As ForecastTypeCollection
        Dim pTypeCol As New ForecastTypeCollection
        For i As Integer = 0 To 2
            Dim pType As New ForecastType
            Select Case i
                Case 0
                    With pType
                        .ValueMember = "Both"
                        .DataMember = ""
                    End With
                Case 1
                    With pType
                        .ValueMember = "UK"
                        .DataMember = "UK"
                    End With
                Case 2
                    With pType
                        .ValueMember = "International"
                        .DataMember = "EX"
                    End With
            End Select
            pTypeCol.Add(pType)
        Next
        Return pTypeCol
    End Function

    Public Shared Function ReturnPeriods() As PeriodCollection
        Dim p As New PeriodCollection
        For i As Integer = 1 To 12
            Dim pPeriod As New Period
            With pPeriod
                .DataMember = i
                .ValueMember = i
            End With
            p.Add(pPeriod)
        Next
        Return p
    End Function

and then they are assigned to the parameters as below:

    Public Sub New()
        InitializeComponent()

        Report.ReportParameters()(0).UI.AvailableValues.DataSource = ReturnTypes()
        Report.ReportParameters()(0).UI.AvailableValues.DataMember = "DataMember"
        Report.ReportParameters()(0).UI.AvailableValues.ValueMember = "ValueMember"

        Report.ReportParameters()(1).UI.AvailableValues.DataSource = ReturnPeriods()
        Report.ReportParameters()(1).UI.AvailableValues.DataMember = "DataMember"
        Report.ReportParameters()(1).UI.AvailableValues.ValueMember = "ValueMember"
    End Sub

Then I bind the report as follows:

    Private Sub ForecastNextPeriod_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.NeedDataSource
        Try
            Dim pCalendar As Calendar = ReturnCurrentYearAndPeriod()
            Dim pType As String = ReportParameters("Type").Value
            Dim pPeriodCount As Integer = Me.ReportParameters("PeriodCount").Value

            DirectCast(sender, Telerik.Reporting.Processing.Report).DataSource = ReturnForecastReport(pPeriodCount, pCalendar.Period, pCalendar.Year, pType)
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub

pType and pPeriodCount only grab the selected item. I have tried searching the forums and reading documentation but I can not find anything that explains how to get the selected value.
Any help would be appreciated.

cheers,
Jaymie

[Steve]

Hi Jaymie,

Unfortunately this is not possible in the current version of the product and we have it logged in our features list. For the time being the only thing you can do is use the same column for ValueMember and DisplayMember.

Please excuse us for the inconvenience.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Amy]

Has this been corrected in Q3 2010?  I did not see it addressed in the release history for reporting: http://www.telerik.com/products/reporting/whats-new/release-history/q3-2010-version-4-2-10-1110.aspx

But what is confusing is that you refer to using the DisplayMember and ValueMember as separate fields in your documentation and blog posts: this is one example:  http://blogs.telerik.com/kevinbabcock/posts/09-04-24/connecting_the_dots_ado_net_data_services_and_telerik_reporting.aspx

from the above blog page:

The ReportParameter Collection editor will appear, which you can use to add a single parameter with the following properties – Name: Category; Type: Integer; UI.AllowBlank: False; UI.AvailableValues.DataMember: CategoryID; UI.AvailableValues.DisplayMember: CategoryName; UI.AvailableValues.ValueMember: CategoryID; UI.MultiValue: True; UI.Text: Category; UI.Visible: True.

[Steve]

Hi Amy,

This functionality has been implemented in the Q1 2010 release, namely the following work item: Added support for retrieving parameter's label as well as its value in expressions.
As visible from the Using Report Parameters in Expressions help article, in the expression editor you can access the DisplayMember by using Label "keyword" e.g. "= Parameters.MyParameter.Label".

Kind regards,
Steve
the Telerik team