COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: praveendammu on 25 Jan 2008 11:20:02 PM

Title: Filter problem
Post by: praveendammu on 25 Jan 2008 11:20:02 PM
 
Hi
This is praveen,am facing one problem with filters.
Can u define "where clause" in filter on report studio,What is the syntax.
any body can help me
its argent
Title: Re: Filter problem
Post by: Suraj on 26 Jan 2008 10:01:02 AM
The equivalent to where clause in RS is either if else statement or case statement.
if () then () else ()

case
when then
when then
else
end

Where are you having problem?
Title: Re: Filter problem
Post by: jahnavi on 30 Jan 2008 12:16:47 AM
We can define when clause in a filter

In case statement we can use

Case

when ( condition) then(expression)

else(expression)

end