This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 71%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
I am a SSRS newbie, so pardon simple questions. I created two main reports. One report has hidden reports within. The other report has sub-reports. When I deployed the programs to Reporting Services, the sub-reports appear as selection options. How do I hide these sub-reports so a user cannot select them?
One report has hidden reports within
What are "hiddens" reports good for, if no one can see the "hidden" content?
No, you can't achieve your requirement.
The hidden report is "unhidden" by clicking on a toggle switch. It shows the data behind a chart if one desires to see it. The sub-reports are separate programs called by the main program which passes data to the sub-report. On their own the sub-reports can't run because they would be missing input data.
Hi @Stephen Schleyer,
Not really clear about your issue, could you please give more information?
If you want to hide the sub-report, you may remove it when you design the report.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
I do not know how to hide/remove it from the menu selection screen. That is what I am trying to find out. I do not want the user to be able to select the sub-report. It should only be called from the main program which passes the sub-report the data it needs.
Hi @Stephen Schleyer,
You may right click the subreport and choose subreport properties, under the visibility--hide the report.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Thanks for your answer and sorry for my delayed response (this really got pushed to the back burner) but I am still unsure as to where I can get to the subreport properties. I am developing this in Visual Studio 2019. Is hiding the report done in VS19 before I deploy the report or after it is deployed to production? I do not see a subreport selection to get to subreport properties.
In Visual Studio, I created a orders and sales report. If the user clicks on the “Total Orders" box a subreport will be produced to show the data behind the total value. Besides not being able to find the sub-report properties menu, the visibility option says on initial run. In my report the subreport doesn’t run until it is selected. What does the hide option do in this case?
When these reports were deployed to the production server, the icons “Total Sales” and “Total Orders” appear. I don’t want the user to be able to see these. If I right-click on the icon and select manage, it allows me to select “Hide this item” but all this is doing just greys out the icon but still allows the user to select it.
I just want to user to see two options “Total Sales and Orders” and “Vendor PO Report”.