Skip to Content
0
Former Member
Jul 27, 2016 at 09:34 PM

Dynamic parameter selection (selecting a sub-set of values)

21 Views

Hi,

I am trying to pull a report using parameters. I am populating all the vacancies (values) in our recruitment database to a parameters drop down list. But the problem is, some vacancies in parameter drop down list are no longer active (there's a flag in table which marks a vacancy is active or not). We don't want vacancies which are not active in parameter drop down list. I can think of statically adding active vacancies in the list, but then there may be new positions added to vacancies column in future. Therefore, statically adding vacancies to list is not an ideal solution.

I was just wondering whether it's possible to populate active vacancies into parameter drop down list. I would really appreciate any help on this.

Thanks,

Vaseem