I have a main report "New Items" with 5 subreports "Sub1" through "Sub5" all within a project "Project1". I deploy all the reports to the same TargetReportFolder on SharePoint. When a user goes to the SharePoint site to run the report, they see the main report along with all the subreports which is confusing to them.
How do I hide the subreports from the users so they don't click on them? I've read a lot of forums mentioning "Hide in List View" but I do not find that option in SSRS 2008 R2. Is there a properties setting to hide the subreports that I'm not finding?
In your scenario, you can remove the permission on the subreport for users. (Click the down arrow, and on the menu, click Manage Permissions>click the check box next to the user or group, click Actions, and then click Remove User Permissions or Edit User Permissions) For the detail information about it, please see:
How to: Set Permissions for Report Server Items on a SharePoint Site (Reporting Services in SharePoint Integrated Mode)
If you have any questions, please fell free to ask.
TechNet Community Support
Removing permissions in SharePoint does not work with the subreports.
The user gets an error when running the main report "The subreport 'Sub1' could not be found at the specified location..."
The user needs permissions to run the subreport but I just do not want them to see the rdl file in the same folder as the main report.
I believe the best you can do is to put your subreports in a subfolder. The user still needs rights to the subfolder to run the reports.
I do not understand where I'm supposed to put in the full path as the documentation states:
On a SharePoint site: You must specify the report name in an expression, with the full URL of the item and the file extension .rdl. For example, ="http://server/site/library/folder/Report1.rdl".
Where does the "http...rdl" path go? I assume it needs to go in the main report rdl code but where? Any code examples? I'm not a programmer by title but I have enough skills to get by.
This also requires changing the project properties (e.g. TargetReportFolder) when deploying the main report or the subreports.
- Edited by jvangheem Monday, June 24, 2013 7:05 PM added more info