Drop Down Prompt

[ar0421]

I have following problem. I would like to populate dropdown box  on a prompt page from the query (state for example). I want first value to be selected to be 'None' which is not in the query. What is the best way to do it?

Thank you.

[Lynn]

Add a static choice to the prompt control called "None" and make it the default.

You will need to modify your query accordingly so it knows what to do with a value of "None". Otherwise it would look for a state called "None" and never return results. Unless there is a state called None....my geography could be a little rusty  :D

Filter might look something like this:

Code Select Expand

(
?Select State? <> 'None'
and
[YourNamespace].[States].[State Abbreviation] = ?Select State?
)
or
(
?Select State? = 'None'
)

Personally, I would generally make it an optional filter. Selecting nothing from the prompt control doesn't restrict the result set in that situation.

[ar0421]

Thanks you for your help