Some developers here are trying to use SQL Reporting and are running into some issues with rights and deployment. Essentially it appears that anyone who runs the report has to be in a group role that can access the report. I.e. just having access to the application under which the report resides is not sufficient. What is desired is the ability to access the report by a proxy ID so anyone having access to the application can run the report(s) also. However, none of the developers working on it know how or if this can be accomplished. What is the answer to this scenario and is there documentation for resolving it?

Thanks,
Bill