all in prompt

[Nandini.t]

Hi all :)

I have one requirement from my client.
I have a branch prompt where it should display only 2 values 'ZA09' and 'All'.
'All' should contain all branches except 'ZA09'

Pl do help me out..
Many thanks in advance...

[Nandini.t]

any views????

[HalfBloodPrince]

Hi Nandini,
               First Create a static prompt ie Just drag a Value prompt click on next make filter optional and say finish. Do not select any column and all. then go to prompt properties go to Static choices and add two choices ZA09 and ALL. ok ?

then go to Report Page and add this filter
(?Parameter1?='All' AND [Branch]<>'ZA09') or([Branch]=?Parameter1?)

Try and let me know

[Nandini.t]

ya prince i tried d same its wrking.....

Thanks :) :)

[Nandini.t]

hi prince,

I have one issue regarding the filter expression above when i use it on my final query after few joins.


I have Following queries
>1> List
>2> Trans List
>3> Trans List1
>4> List-Trans List(combination of >1> and >2>)
>5> List-Trans List--Trans List1(combination of >3> and >4>)

After the following procedure

First Create a static prompt ie Just drag a Value prompt click on next make filter optional and say finish. Do not select any column and all. then go to prompt properties go to Static choices and add two choices ZA09 and ALL.

If i go to report page and while adding the filter iam getting
Sources (contains only Joins) but not the metadata
Data Item(only the contents of nail list)
Queries(all available queries)

so now which Querie's [Branch] should be considered to create the filter.


Pl do help me .
Thanks,
Nandini