If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

conditional statements in detail filter

Started by kalyan_sekhar1, 27 May 2008 09:59:07 AM

Previous topic - Next topic

kalyan_sekhar1

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

almeids

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