[How to Map dropdown (select single query) input control to Jasper report parameter in Jaspersoft Server]

@zh3ntil: Could you please elaborate the steps with screenshots. I have tried with almost all possiblities but nothing works for me. Thanks for your reply

[How to Map dropdown (select single query) input control to Jasper report parameter in Jaspersoft Server]

I created an input control (single select query), I loaded data to the input control using a select query like the below.

select id,country from countries

My input control has country values displayed for example.

USA,CANADA,EUROPE,.....

once the user choose a particular country then I have to pass the "id" of that selected country to parameter used in the report.

I tried with different ways like the name of the report parameter exactly mapped with name of input control but nothing works.

Kindly provide me the steps to accomplish this since I am struggling for the past two days.