update on my SQL expression problem

[Durango122]

Hi All
i need some help plz
cr 9.0
ms sql
I have a table call Fund
in that table there hare these fields
"FUNDS"."PORTFOLIO",
"FUNDS"."FUND_GROUP" = '59' and
"FUNDS"."CSTM_FundChannel"
from the field
"FUNDS"."CSTM_FundChannel it has multiple value but i need to filter my record selection to have only theses return
---------------------------------
example from my ms sql query return the right value
age
(select distinct "FUNDS"."PORTFOLIO"
where "FUNDS"."FUND_GROUP" = '59' and
"FUNDS"."CSTM_FundChannel" = 'Age-B'
)
--------------------------------------
years
(select distinct "FUNDS"."PORTFOLIO"
where "FUNDS"."FUND_GROUP" = '59' and
"FUNDS"."CSTM_FundChannel" = 'Years'
)
--------------------------------------
Equity
(select distinct "FUNDS"."PORTFOLIO"
where "FUNDS"."FUND_GROUP" = '59' and
not("FUNDS"."CSTM_FundChannel" in ['Years','Age-B'})and
not("FUNDS"."CSTM_FundChannel" like'MDP?'})
)
--------------------------------------------------
not sure if i need to create 3 command to get these value
or 3 sql expressions????????????
not sure what to do??????????????????
i tried sql expression with the sample above for each and keep getting error in syntact
maybe you can give some pointer

also forgot they have to be in separated group
ex:
gh1 Age-Based
gf 1 sub total Age-Based
gh2 Years
gfe sub total Years
gh3 Equity
gf3 sub total Equity
thanks





Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[daughtery]

Have you tried clicking the field to be filtered then clicking on the "Select Expert" icon (or Report/Select Expert) then entering your filtering criteria?