"Andy" <Andy@discussions.microsoft.com> wrote in message
news:7D9D8D67-B4F8-42ED-953C-103338F3FA98@microsoft.com...
> Is there a way in Reporting Services to create an optional multivalue
> prompt
> whereby the user does not need to do anything to the prompt to completely
> skip it. For example, let's say a report has the following prompts:
> Year
> Month
> Country
> State
> City
>
> If the user wants to complete the Year prompt and State prompt, is there a
> simple way to bypass the Month, Country and City prompts without having to
> select anything? I'm told that the Null option does not work on
> multivalue
> prompts so I was looking for an alternative means to do this.

"Mike Morisoli" wrote:

> Why not just supply a default value for each prompt, that way if they skip
> it, the report will run with the default values?
>
> Or am I missing something?
>
> m
>
> "Andy" <Andy@discussions.microsoft.com> wrote in message
> news:7D9D8D67-B4F8-42ED-953C-103338F3FA98@microsoft.com...
> > Is there a way in Reporting Services to create an optional multivalue
> > prompt
> > whereby the user does not need to do anything to the prompt to completely
> > skip it. For example, let's say a report has the following prompts:
> > Year
> > Month
> > Country
> > State
> > City
> >
> > If the user wants to complete the Year prompt and State prompt, is there a
> > simple way to bypass the Month, Country and City prompts without having to
> > select anything? I'm told that the Null option does not work on
> > multivalue
> > prompts so I was looking for an alternative means to do this.
>
>