This seems like an easy thing to do but I can't figure out a solution for the life of me.

Running v10 Pro

3 tables included with 6 fields total, want to exclude a specific contract type from being included in the output. If I add the record selection formula to exclude the type I want removed from the report it does exclude them but since some accounts do not have a contract associated those records are also not printing which is a problem.

If I exclude the table that contains the contract type it obviously prints out all the records including the contract type I need to exclude.

Help please...

I first suspected that as well but each has a left outer join type and per our CRM vendor that is the recommended setting for their fields

I'm using option A - tableA.field <> 'contract type 1'

How do I change the select formula option 'use default values for nulls'?

Sorry but I'm not familiar with a "pick list" and its options. Can you please direct me as to what should I be looking for in the workshop?

As far as I can tell all of the toolbars are included in the workshop and the only pick lists I see are greyed out - one looks like a piece of paper and the other has the text "crystal syntax". I added the formula below and refreshed the data and it still not showing blank records.

NOT (IsNull({tblContracts.ContractType}))

Sigh....