Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 9 - very basis 'or' help. 1

Status
Not open for further replies.

CalgaryCR9

Technical User
Aug 12, 2005
80
CA
I want to write, in Crystal Reports 9 a formula on the following fields:

{SERVICE_CALL.CREATE_DT}=YearToDate
{PART.PART_VENDOR_ID} not equal to 109 or 103 or 141

My base formula is:
if
({SERVICE_CALL.CREATE_DT}=YearToDate and {PART.PART_VENDOR_ID}<>(?????????????)
then 1

What is the correct syntax for writing the "NOT EQUAL TO" portion of this formula?

Thanks in advance.
Joy
 
if {SERVICE_CALL.CREATE_DT}=YearToDate and
not({PART.PART_VENDOR_ID} in [109,103,141]) then 1

-LB
 
Thanks so much. Don't ya hate it when you just can't get the easy ones right! :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top