How to exclude specific subtypes from even showing

[vhagerty]

I'm using Crystal Reports 9/SQL with the Track-It application. The report has only the one group {tasks.wotype2} and it shows them in ascending order. I need to somehow keep the subtypes of "Account Request" and "Conference" from showing in the report at all. What are my options to make this happen?

 

[synapsevampire]

Use Report->Selection Formulas->Record and place:

not({tasks.wotype2} in ["Account Request","Conference"])

-k

 

[vhagerty]

I had another formula in that location so it now reads

IsNull ({tasks.COMPLETED}) or {tasks.COMPLETED} = Date (0, 0, 0)and not({tasks.wotype2} in ["Account Request","Conference"])

but the report is still showing the Account Requests and Conferences

any other idea?

 

[MrBillSC]

Try using parenthesis:
(IsNull ({tasks.COMPLETED}) or {tasks.COMPLETED} = Date (0, 0, 0)) and
not({tasks.wotype2} in ["Account Request","Conference"])

MrBill

 

[vhagerty]

BINGO!!!
Thank You to both of you!!!