I have a table with 3 columns.
I need to create a report which has 2 dropdowns . 1st dropdown is for products. It should have a list f products.
2nd Dropdown is for currency(Dollars and Pounds).
If some one selects a product from Products dropdown and dollars from currency dropdown, then dollar value for that product has to be returned.
I could successfully create dropdown for products. I am having trouble in creating drpdown for currency. I am not knowing how the dataset should be for the currency dropdown and what parameters have to passed in the main dataset.