"TimS" <timstspry@msn.com(donotspam)> wrote in message
news:B5BD5E9C-95A6-4D40-835D-1AE35CB12746@microsoft.com...
> Hello, I posted this same question a while ago, but cannot seem to find it
> anymore. Anyway, I have what I think is a fairly simple question and am
> surprised that I have not received a reply to the original post, that I
> can
> no longer find.
>
> Here goes again. I have two parameters, one of which is cascading. They
> are client and account. The account drop down list is filled based upon
> the
> selection made in the client drop down list - thus the cascading
> parameter.
> A single client may have multiple accounts. I do not want to use a
> multivariate parameter for account as I want to be able to select a client
> and leave the account parameter optional. If a client is selected and no
> account is selected, then I assume the report should show all accounts for
> the selected client.
>
> However, I cannot find a way to make the account parameter optional. Is
> there a way to do this?
>
> Thanks in advance!
>
> Tim S.

"Kaisa M. Lindahl Lervik" wrote:

> Add a "All accounts" to the Account parameter data set. Set this to be the
> default option. That means when a user has chosen his Client, he has to
> choose an account, or he gets all the accounts for that client.
> You add your All row using Union in the data query.
>
> Then you have to make sure the report data query can handle the All option.
>
> Kaisa M. Lindahl Lervik
>
> "TimS" <timstspry@msn.com(donotspam)> wrote in message
> news:B5BD5E9C-95A6-4D40-835D-1AE35CB12746@microsoft.com...
> > Hello, I posted this same question a while ago, but cannot seem to find it
> > anymore. Anyway, I have what I think is a fairly simple question and am
> > surprised that I have not received a reply to the original post, that I
> > can
> > no longer find.
> >
> > Here goes again. I have two parameters, one of which is cascading. They
> > are client and account. The account drop down list is filled based upon
> > the
> > selection made in the client drop down list - thus the cascading
> > parameter.
> > A single client may have multiple accounts. I do not want to use a
> > multivariate parameter for account as I want to be able to select a client
> > and leave the account parameter optional. If a client is selected and no
> > account is selected, then I assume the report should show all accounts for
> > the selected client.
> >
> > However, I cannot find a way to make the account parameter optional. Is
> > there a way to do this?
> >
> > Thanks in advance!
> >
> > Tim S.
>
>