Here's a test to try. Add a field to your detail band that uses ALIAS() as the expression. This way you will see without a doubt what table is active as the report is printing. Try your test of previewing with next and previous and see if that field changes on the report.
Some things that could be going wrong ....
- You are calling a UDF or method somewhere in the report and that code is changing the current alias to something else.
- You have a bad index on the table driving the report and you need to reindex the table
- You are calling the report from a form and the form has a grid on it. This often causes problems because the grid keeps trying to change the alias back. If this is the case, move focus off the grid before running the report.
Cathy
