How to make Query filter

building reports webintelligence
1

Hello all,
I have three objects, type i , type2 and DSN.In query filter i drag all these three objects and make Or and it is showing

Type1 =902
OR
Type2 = 300
OR
DSN = ‘38’

But i want to have the filter below

Type1 =902
OR
Type2 = 300
AND
DSN = ‘38’

how can i achieve this requirement?Do i need to do Custom SQL and make it AND instead of OR?

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

2

hi!

double click the condition and it should change.

regards,
r.A.

R.A. :philippines: (BOB member since 2008-10-28)

3

Hello,

if I double click on OR it will show AND, and the SQL will be
Type1 =902
AND
Type2 = 300
AND
DSN = ‘38’

But i want to show

Type1 =902
OR
Type2 = 300
AND
DSN = ‘38’

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

4

You need parenthesis.

Drag the objects that need to be “grouped” right on top of each other. It will indent them. Then you can change the ANDs and ORs.

Steve Krandel :us: (BOB member since 2002-06-25)