Are you saying that you can run the report, even from the other machine, when you connect as yourself, but not when you connect as another user? If so, the problem is a database object priviliges issue.