Optional report filters are ignored when OR'd

[Spyhop]

I have multiple Y/N prompts that are set to NOT required, and they are applied in an optional filter like the example below.

It appears that the filter is ignored (i.e I select one or more of the prompts but the results I am getting are not filtered).

(
[AAAA].[BBBB].[FLAG_1] = ?pFlg1?
or
[AAAA].[BBBB].[FLAG_2] = ?pFlg2?
or
[AAAA].[BBBB].[FLAG_3] = ?pFlg3?
or
[AAAA].[BBBB].[FLAG_4] = ?pFlg4?
)

Has anyone experienced this and better yet does anyone have a resolution!

Thanks

[BigChris]

Ok - can you let us know what the possible values of the fields are, and the possible values of your prompts? I'm guessing you've set it up so that whatever values you select in your prompts you're always going to get all of your records.

It all depends on your data, but what you might need your filter to look like is something like this:

Code Select Expand


(if[FLAG_1 = ?pFlg1?) then (1) else (0) + if[FLAG_2 = ?pFlg2?) then (1) else (0)
+ if[FLAG_3 = ?pFlg3?) then (1) else (0) if[FLAG_4 = ?pFlg4?) then (1) else (0)) > 1


[Spyhop]

Thank you for your reply...

There are 'boolean' flags so each of columns for a row contain either 'Y' or 'N'. 

FYI...This is a data cube drill through report so other than the reference in the filter, there is no prompt page for the report.

So if a flag is specified in the cube view the only possible values for the prompts in the optional filter are 'Y', other wise the prompt value will be null.

I only want to return records that have 'Y' values for the selected flags, regardless of the values of the flags not selected.