Dynamic Prompts

Hi All

I'm currently trying to shift to the SRS 2005, (Mainly the report builder)
My former report generator had a capability of popping up a list of pre-defined prompts that had a dynamic data in their dropdowns, I.E whenever I asked to choose let's say employee full name it had some sort of a SELECT DISTINCT command that pulled the data and showed it in the drop down.

I have tried searching for a similar capability in the SRS but all I found is that it can draw the SELECT DISTINCT data and let me choose the permanent values into the drop down.

Do you have some sort of work around for this kind of issue? am I doing something wrong or have I merely missed a spot?

Thanks!

Ron

In Report Builder you can specify that the user be prompted for the value of a particular filter condition by clicking on the field name part of the filter condition and choosing "Prompt" from the menu that appears. However, the user will only be given a dropdown of values to choose from if (a) the field is a model attribute with ValueSelection=Dropdown, or (b) the field is a model entity with InstanceSelection=Dropdown.

In Report Designer you can create report parameters for which the user is prompted to choose a value from an arbitrary query you specify.