Combo ID Problem...
Posted: Tue Jul 26, 2011 9:10 am
Hi everyone,
I have designed a WPF Report. I have a datasource named "Jobs" bound to the report. Now I want to filter Jobs by PersonId.
So I have created a DataSource called "Persons", which is loading PersonId and PersonName from DB. Now I want to show a combo box and put the Persons into that combo. The user selects one of the persons, and I like to filter the jobs by the PersonId of the selected Person.
For this to accomplish I created a variable, checked "Ask user" and "Allow User Values". As DataSource I choose DataColumns. So I have two dropdowns (Keys and Values) there I can choose Fields of my datasource. For Keys I selected Persons.Id and for Values I selected Persons.Name.
The combo is shown as filter in the report designers preview. It is filled with person names. But if I select one of the persons, its ID is shown in the combo. The list of the combo is correctly filled with the names, but if the combo closes, the Id of the selected person is shown, instead of its name.
Is this a bug, or am I doing something wrong?
Hope you can help me with my problem.
Regards,
Koray
I have designed a WPF Report. I have a datasource named "Jobs" bound to the report. Now I want to filter Jobs by PersonId.
So I have created a DataSource called "Persons", which is loading PersonId and PersonName from DB. Now I want to show a combo box and put the Persons into that combo. The user selects one of the persons, and I like to filter the jobs by the PersonId of the selected Person.
For this to accomplish I created a variable, checked "Ask user" and "Allow User Values". As DataSource I choose DataColumns. So I have two dropdowns (Keys and Values) there I can choose Fields of my datasource. For Keys I selected Persons.Id and for Values I selected Persons.Name.
The combo is shown as filter in the report designers preview. It is filled with person names. But if I select one of the persons, its ID is shown in the combo. The list of the combo is correctly filled with the names, but if the combo closes, the Id of the selected person is shown, instead of its name.
Is this a bug, or am I doing something wrong?
Hope you can help me with my problem.
Regards,
Koray