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.
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:
(
?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.
Thanks you for your help