• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

SSRS Reports on MOSS

I have a ssrs report that has two subreports embedded in the main report.  I works great.

I have deployed it to SharePoint; that worked fine.  The problem is in the reports library, the main report as well as the two subreports show up for the user to select.  How can i prevent them from seeing the two subreports in the list?
1
Hollie18502
Asked:
Hollie18502
  • 3
  • 2
2 Solutions
 
Chris LuttrellSenior Database ArchitectCommented:
We do it by creating a folder called Linked Reports and hiding it at the folder level.  Go into Report Manager and view details of the folder to set it.
SSRS-Folder-Options.png
0
 
Chris LuttrellSenior Database ArchitectCommented:
You can do it on a Report by Report basis also, but that can be tedious, we have lots of them.
0
 
Hollie18502Author Commented:
Are you talking about within SharePoint.  and if so, if I  move them to a different with the main report still be able to locate them?
0
 
Chris LuttrellSenior Database ArchitectCommented:
Sorry I was confusing our linked reports with subreports.  subreports we just hide in list view on a report by report basis, in the directory with the main report.  I am used to using the Report Manager interface so I am not sure if you get to it differently within SharePoint but the concept should be the same, mark the subreport as Hide in list view.
0
 
Hollie18502Author Commented:
This question is still open, can anyone help?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now