>>>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.

Bingo. It keeps the data access centralized and under control. Crystal Reports isn't perfect, and I'd hate to think what it's generate SQL could possibly do to my database server resources...