Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reporting Services Parameter challenge

Status
Not open for further replies.

Nuovo2004

Programmer
Jun 9, 2004
24
CA
Hi Guys,
This should be easy but I'm having trouble.
I have a report with a report parameter called 'Parameter A'.
Parameter A's values are listed as non queried values:
Label Value
ParamA ="A*"
ParamB ="B*"
ParamC ="C*"
ALL ="*"
NOT_C ="?????" ---Don't know this.
If I want to type in an expression that I want values A, B but not C, how do I do this?
I have a filter on this parameter where the field will be like the value of Parameter A. This works for the first 3 but this filter will not work if I want everything exept one of the values. Has anyone attempted this?
Can this be accomplished in the expression editor?
Either have some way of saying I to filter on Param A and B or say filter on everything but C. I want both options so changing the filter polarity/operator will not work.

Options?
Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top