Have report where the user should be able to enter some selection critera to EXCLUDE from the result set displayed.
I deally Iwould liek to include it in the sql parameters to avoid retunring a larger then necessary result set, but Couldn't I also use it inthe filter criteria?
Has anyone done anything like this.
ie: a drop down box where people could add exclusions.
ie: Apples, Oranges
would be excluded from the result list.
So If I entered Apples, Oranges
the resultset would eclude these from the returned dataset.
I realize using a multi param box is fruitless. WOndering if there is another way to do this
Why wouldn't multi-param work?
Select something from sometable where (@.multiparam is null or fruit not in (@.multiparam))
Does this look ok?
cheers,
Andrew
