>I am trying to print a report that involves records from 5 files in VFP6. They all have to meet a certain criteria (a matching index). I use a select sql command to filter the right records, but never the less my report only prints the first record in my main file, one that doesn't match the condition.
>Any suggestions?
>
>Andrew Belle

Is your report "hard coded" to the alias name of your main file? Check all your fields to make sure they are not referencing an alias name, only a field name. And make sure the SQL cursor is what is the currently selected area before you run the report.