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.

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.