Could it be that when the report is run by the page/job server service the DBMS is returning different data? Ie. is there role-type security in the underlying DBMS?
Check out the data connectivity FAQ in this forum for ways to test/resolve this.
Cheers, Alan Eldridge
Melbourne, Australia