[soapbox]If the fields are boolean type, you don't need to include "=True" or "=False".  The field value itself provides the true or false value.  Also, using If statements in the select criteria can slow down processing because Crystal has to process the records instead of the database.

So, this could also read:

({?IsActive} = 'Yes' or (<criteria to exclude records>))

Notice the use of parentheses - if there is more than one criteria used to exclude fields, you should put parens around all of that part of the statement.  When using an "or" statement along with other selection criteria, you MUST put parens around both 'sides" of the or statement, otherwise you won't get the data you're looking for.

-Dell