query filtering from value prompt

[kiran04]

Hello All,
I have a value prompt (checkbox) and i should not show one of the values for that prompt.
Say i have total 4 values(A, B, C, D) and i should not show say(D) value.
The requirement needs that the report should also bring data for that D value along with all other values even though we do not show
the value(D) in prompt.
The issue is (if we only showing A,B,C Values ) in prompt, report query also brings down those data only not for D value
because we are not selecting that value in the prompt.
Any ideas or suggestions are most welcome.

thank you,
KWAS04

[HalfBloodPrince]

Try this
in prompt query put filter as [Data Item]<>d so prompt will show only  A,B and C

In report query put filter
[Data Item] in ?_Parameter? or [Data item]='D'

[kiran04]

Thank you, it worked.. :)

KWAS04