Creating reports and dashboards | Stimulsoft community forum

I have a data source that fetches a list of locations, which returns locationID and locationName.

I am attempting to set up a Report Variable that uses this data source to give the report user a list of locations to choose from. This is working, however the drop-down is showing the locationID and not the name. After selecting a locationID, the name will appear as the selected value.

How do I get the name to show in the list? I need to pass the locationID to the query, not the name.

Report Variable The locationID is appearing in the list, when it should be the locationName After selecting a record, the name of the location appears

Hello,

Please try to check the last version.

Thank you.

Thanks, the latest version has fixed that issue.

Is there a way to add an item to the list? For example, I want to add a key/value pair "All Locations" with a value of 0.

If the user selects a location, the default empty line can no longer be selected.

Hello,

You can add an additional variable for this:
https://demo.stimulsoft.com/#Net/Parame ... ingCountry

Thank you.