Wednesday, March 21, 2012

interesting problem..related to selection criteria..

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

No comments:

Post a Comment