Hello, is there a way to do Data Binding on parameters?
I want to allow users to pick parameters from the list, so Multi-select works great but it requires hard-coded list of values. I’m looking for a way to pull a list from a database. For example,
select ID, Name from dbo.Animal:
returns:
1 Cat
2 Dog
3 Horse
etc.
and then multi-select parameter would be auto-populated like this:
Any workaround or way to make this work?