Crystalkeen logo
Crystalkeen header image 3
Crystalkeen header image 5

Crystal Reports Tools: Improve Performance While Saving Time and Money




CR Schedulers
CR Viewers
DataBase Tools
Mail UFLs


About us

Contact Us

on Steroids

Crystal Reports: Use XOR to Perform Exclusive OR

Now you can be an "XORcist" when you do your Crystal Reports! Use an exclusive OR to select data.

Most report designers are comfortable with basic selection criteria. They will combine multiple clauses with AND and OR operators to select the data they want in a report.

Sometimes you may want records that meet one or other criteria, but do not want records that meet both or neither criteria.

Here is a Boolean operator not often used. You can use XOR to perform an Exclusive Or.

An example would be
{Dept}=ABC Xor {Qualifications} =XYZ

This will select everyone in dept ABC or anyone in other departments with a qualification of XYZ, but will ignore the people in Dept ABC who already have a qualification of XYZ.

But what if you want to do the exact opposite? No problem!

You can use the XOR Boolean operator to combine two Boolean clauses and return TRUE if one of the clauses is true--but false is both or neither are true. If you require the opposite result use the EQV operator inside your formula.

That is, use EQV if you want records that meet both or neither criteria, but do not want records that meet one or the other criteria.

TRUE Eqv TRUE returns a value of TRUE
FALSE Eqv TRUE returns a value of FALSE
TRUE Eqv FALSE returns a value of FALSE
FALSE Eqv FALSE returns a value of TRUE


See also: Crystal Reports: Boolean logic


This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.


  • Questions? Please write to We do want your business.
  • Do you have your own tips for Crystal Reports administrators and designers? Write to and we'll post your tips with a link to your Website (or with some other attribution if you choose).
  • Crystal Reports is a subsidiary of Business Objects, which is owned by SAP.