Report parameter: Populate drop down list with query

[mahdy]

Hi...

I was wondering if anyone has any tip about how to create for a report a parameter with a drop down list with the values of the drop down populate by a query...

I've tried different things in the design studio but so far I haven't managed to do it...

That requires some Javascript I guess...


If anyone has any idea??...

Thanks

[pstoellberger]

Have a look at the samples...

you need to create a new relational (get data from > relational) action before your input parameter selection in the XACTION file
define value and name column in the "relational" step and in the prompt/secure filter put the result from this relational query as source for a dropdownlist

just look at the samples, there are plenty in there.. they will tell you how to do it :)