I am experiencing a strang issue in SSRS 2005.
a) I have a MainReport that contains a SubReport and I deploy these up into Report Manager into a folder called MyFolder.
b) MyFolder has restricted access so only I can access it via ReportManager.
c) I ceate a linked report for each report: LinkedMainReport and LinkedSubReport and move these linked reports into a folder called YourFolder.
d) YourFolder is restricted to a Windows AD group... called ManagerGroup.
e) Report Manager folder structure now looks like this:
MyFolder (my access only)
- MainReport (original report)
- SubReport (original report.. and set to be hidden)
YourFolder (ManagerGroup and my access)
- LinkedSubReport (set to be hidden)
f) Security from the folders is applied to each report and link report by default.
g) ManagerGroup contains say 3 users: Homer, Lisa and Bart.
Homer and Bart can run the report "YourFolder -> LinkedMainReport" without any problems. The main report and subreport embedded within it run fine. The problem I have is when Lisa runs the same report "YourFolder -> LinkedMainReport" she sees
the main report but gets the "Error showing subreport" message where the subreport is usually display
View Complete Post