Can we add OR condition in drill through parameters

[Starfish2201]

Hi Gurus,

I have a requirement of passing "OR" condition in the drill through parameter, lets say I want to see all the target report data when

dataitem1 is null or
dataitem2 is null or
dataitem3 is null

Thanks a lot for your help !!!

[MFGF]

You can only pass data items/parameters etc in drill-through definitions. The actual filtering is done in the target report. From the looks of your requirement you can simply pass the three data items in your drill-though definition, and define your filter in your target report exactly as you have described.

Cheers!

MF.

[Starfish2201]

Thanks MFGF..

But my problem is how I would put the OR condition in the filters? If I put each dataitem as a separate filter, cognos will take it as an AND condition.
Like dataitem1 is null
and dataitem2 is null
and dataitem3 is null

whereas I want to  put OR in there.

Can you please help ?

[RKMI]

Hi,

As MF mention you need your target report to take the correct set of parameters being passed from your source by making the filters in your target report optional you will get the desired output.

Thanks,
RK

[MFGF]

In your target report, code a single filter with the expression

[dataitem1] is null OR [dataitem2] is null OR [dataitem3] is null

Cheers!

MF.