Print Page - conditional statements in detail filter

Title: conditional statements in detail filter
Post by: kalyan_sekhar1 on 27 May 2008 09:59:07 AM

Hi,

Can i have a conditional statement in the detail filter? For e.g the below statement is giving errors.

IF ((P_ID=?p_grp?)>0) THEN (M_i='N') ELSE (P_ID=?p_grp?)

I am getting error if i use this in the detail filter ? Is there any work arround

Thanks

Title: Re: conditional statements in detail filter
Post by: almeids on 27 May 2008 11:45:01 AM

Use OR logic in filters rather than conditions:
(P_ID<>?p_grp? AND M_i='N') OR (P_ID=?p_grp?)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kalyan_sekhar1 on 27 May 2008 09:59:07 AM