the only thing that comes to mind is that your DSN may be set where you don't have access to the data...
Our application has multiple ways of limiting the data that a user can see, and if the connection is for a limited user, I would suspect that the result would carry through. The other thought would be that the DSN is not looking at the same server/database as the others.
If the report is the same, then one would suppose that it is the database or the access to the database, which is where I would start looking.
HTH
IP Logged
