I thought the report was running, while it was actually just hung. I'm still having the same problem, I can run it from BIDS but not when scheduled under sql server agent. I even moved the report locally, gave that share full access to everyone - doesn't make a difference.
So how do you do that, log in or run as SQL server agent? Is this account supposed to show up under users? I have the service set up to login as a domain user account, which for sure has the credentials to run that report.
I appreciate your help!!