I have an ssrs report subscription which deployed to a shared folder on a separate webserver. The report is displayed through an asp.net web application. The main report is displayed fine. But when the user clicks on the drill through icon, they are seeing "The permissions granted to user 'Domainuserid' are insufficient for performing this operation. (rsAccessDenied)". The reason for this is because the drill through icon is linked to the ssrs server instead of the webserver. Users don't have access to the ssrs servers. Is it possible to generate reports so that all information required for the drilldown report will be deployed to the webserver and the links point to the webserver instead or the ssrs server. or is there a work around for this problem. Thanks in advance

Hello forum_user, Thank you to post your question on TechNet forum. I found that you raised a similar issue with this case, and I posted my suggestion over there. Did you review it? http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/02ef2833-8108-4083-b1f4-392ac63284e7 If you have any questions about this issue, please tell us freely. Regards, EdwardEdward Zhu TechNet Community Support

Hello forum_user, Thank you to post your question on TechNet forum. I found that you raised a similar issue with this case, and I posted my suggestion over there. Did you review it? http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/02ef2833-8108-4083-b1f4-392ac63284e7 If you have any questions about this issue, please tell us freely. Regards, EdwardEdward Zhu TechNet Community Support

Yes. Thank You Edward for the reply. It is surprising to me that this is not a built in option in SSRS already. I thought there could be a setting in RDL or somewhere we could specify to generate and migrate all resources required for the report at once.

Yes. Thank You Edward for the reply. It is surprising to me that this is not a built in option in SSRS already. I thought there could be a setting in RDL or somewhere we could specify to generate and migrate all resources required for the report at once.

Hello forum_user, Thanks for your quick response on this issue. I think you can submit a suggestion on http://connect.microsoft.com. If the feature is voted by many people, then Microsoft will add this feature in the later version of reporting service. Thanks, EdwardEdward Zhu TechNet Community Support