>>No, I've always just pushed the data into the report from my application. I've never pulled the data right from the report.

Exactly. I used to struggle with privileges, etc too.

Now I use .NET datasets, fill them and atttach them when running the report from the app.
It's a snap.