HP Intelligent Management Center Standard Software Platform - Manual (Page 205)

• If it does, then you know that this part of the selection formula is
working.
• If it does not, then troubleshoot this part of the selection formula.
7. Once the selection formula with one selector activated is working properly,
add a second selector. For example, the new selection formula might
look like this:
{customer.POSTAL CODE} > "80000" and {customer.CONTACT
LAST NAME}[1] = "C"
8. Preview the report and evaluate the data that prints when you have two
selectors activated. Evaluate the data in the {customer.CONTACT LAST
NAME} field (since you already evaluated {customer.POSTAL CODE} in
the last step).
Does the {customer.CONTACT LAST NAME} field show only text strings
beginning with the letter "C"?
• If it does, then this part of the selection formula is working.
• If it does not, then troubleshoot this part of the selection formula.
9. Once the selection formula with two selectors activated is working properly,
add a third selector, then a fourth, and so on, until you have tested each
selector in the selection formula.
Correcting selections that do not generate data
You may encounter a situation in which you create a record selection formula
and, while header and footer information prints on your report, no detail
information appears. The problem is the selection formula is rejecting all
records. This usually occurs because of an error in the creation of the
selection formula.
Correcting uppercase/lowercase inconsistency
Record selection formulas are case sensitive. That is, "Bob" matches only
with "Bob". It does not match with "bob", "BOB", "BoB", "bOB", "boB", or
"BOb". Thus, if your selection formula is set to include only those records
with "BOB" in the {customer.CONTACT FIRST NAME} field, but all the entries
Crystal Reports 2008 SP3 User's Guide 205
9 Record Selection
Troubleshooting record selection formulas