Troubleshooting

Selection Formulas

There should be data in the report, but no records are returned.

Start by breaking out the Selection Formula into the component parts. As an example, the Selection Formula from Figure 11.15 is made of three parts. Start by commenting out the existing formula and build it up one part at a time. Test to see when the expected result is different from what is returned. After the specific parts are identified, it should be easier to see what the problem is. Also, remember that the result of the Selection Formula is Boolean (True or False) and only those records that result in True are accepted into the report.