[10.1.1] How to apply a condition to a filter ?

[hittony]

Hey :)

Is it possible to apply a condition to a filter ?

I explain : if the condition si true, the filter should be required, otherwise it should be optional.

Thanks in advance for your help !

;)

[MFGF]

Hi,

Assuming your "condition" to drive this is (for example) [Field] = 100

the approach I would take is:

([FIELD] = 100 AND <current filter expression>) OR ([Field] <> 100 AND (<current filter expression> OR 1=1))

Cheers!

MF.

[hittony]

Hi,

Assuming your "condition" to drive this is (for example) [Field] = 100

the approach I would take is:

([FIELD] = 100 AND <current filter expression>) OR ([Field] <> 100 AND (<current filter expression> OR 1=1))

Cheers!

MF.

I forgot to detail that the filter was linked to a parameter. With your approach, the report asks users to give a value in both 2 cases, which isn't what i want to carry out :(

[Lynn]

Try setting a default value for the parameter.