I'm not getting the results I expect in a report. It looks like some records are missing.
The first thing to check is that you have the correct filter for the report. If the filter is too restrictive, you won't see all the records you expect. The second thing to check is that Stonefield Query is accessing the correct database. The name of the database is shown in the status bar at the bottom of the Reports Explorer. Finally, if your database has a "reindex" or "database maintenance" feature, use that feature to ensure the database indexes are accurate.
Filtering a report on a formula doesn't seem to work correctly.
Try turning off the Pad shorter string with spaces when comparing strings (ANSI standard) setting in the Options dialog.