Hi ,
I have got a requirement as below .I tried n number of solutions but its not working as expected.
There is a multi select prompt .My requirement is to filter the report which values are not selected in the prompt. and to display the not selected values in the report as well..
I tried with not contains ,not like and <> but they work for single values :( :(
Thanks
I think you probably want [YourDataField] not in ?YourParameter?...
yes but not in is not working. :(
Quote from: Mita on 28 Nov 2016 04:45:42 AM
yes but not in is not working. :(
What does "is not working" mean? Do you get an error? What error? The wrong results? What results do you see? No results? Something else?
How can you expect people to be able to help when all you have posted is "I have tried n number of solutions but its not working as expected". You haven't told us what you have tried, and what results you got. It's quite likely posters will suggest things you have already tried, because you didn't describe your situation and results in any detail.
MF.