The report has a Boolean field to indicate if the Customer was active (or not). Our user wanted the report to select Active or Inactive clients.

We used a Boolean parameter, and then to make it the question easier to answer, we created a default pick list with True and False and a description against each one. Then the selection formula was a simple

{Customer.Active} = {?Active}

Pick list problems? Then you need cViewPICK, our pick list rebuilder. Don't wait until disaster strikes. Buy cViewPICK now, and have it on hand so you can act quickly.

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.