Error showing subreport... due to user access?
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) - LinkedMainReport - 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. Problem: 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 displayed. What could cause this? All users belong to the same Windows AD group. All can access the folder and the main report... but one of them gets the ERROR. Thanks.
October 8th, 2010 7:25am
Does "lisa" have rights to access the dataset for the subreport?
October 8th, 2010 6:05pm
Hi Scott, I think the pmp07's reply makes sense. Please to check what type the subreport datasource uses. If using Windows integrated security, you need to go to SQL Server and verify if the lisa has rights to access the database of the subreport datasource. If the issue persists, then look into the report server error log to see any detailed message for this issue. thanks, Jerry
October 11th, 2010 6:34am
Ok both the MainReport and the SubReport use the same datasource ReportingWarehouse. This SQL Server datasource through ReportManager has the connection "credentials stored securely in the report server" and uses a dedicated Windows User Account for reporting. So both reports are using the same generic Windows Account to connect to the same datasource for both reports. Now checking out the error log. Thanks,
October 13th, 2010 2:02am
Ok just checked the logs and it seems to be a "permissions error" but I have no idea why: w3wp!library!1!10/13/2010-09:35:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOMAIN\Lisa' are insufficient for performing this operation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOMAIN\Lisa' are insufficient for performing this operation. w3wp!processing!1!10/13/2010-09:35:38:: e ERROR: An error has occurred while processing a sub-report. Details: The permissions granted to user 'ADELAIDE\Lisa' are insufficient for performing this operation. Stack trace: at Microsoft.ReportingServices.Library.RSService.ProcessingGetSubreport(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, String& description, GetReportChunk& getCompiledDefinition, ParameterInfoCollection& parameters) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.RetrieveSubReport(SubReport subReport, ProcessingContext processingContext, ProcessingErrorContext subReportErrorContext, Boolean isProcessingPrefetch) So I have my datasource as follows: Name = ReportWarehouse Connection Type = Microsoft SQL Server Connection String = Data Source=<servername>;Initial Catalog=<database> Connect using = Credentials stored securely in the report server User Name = ReportUser Password = xxxxxx CHECK - Use as Windows credentials when connecting to the data source UNCHECK - Impersonate the authenticated user after a connection has been made to the data source Again, both the MainReport and SubReport use this same datasource. The problem user "Lisa" belongs to a Windows AD group that has been given access to both the MainReport and SubReport. So I have no idea why she can access one report and its data but not the other. Thanks PS - Just checked... Lisa can also run the SubReport by itself via ReportManager... so she can run both the SubReport individually and a bulk of the MainReport except she gets the error where the SubReport should be.
October 13th, 2010 2:24am