SSRS Reports on MOSS

Posted on 2009-04-22
1 Endorsement
Last Modified: 2012-05-06
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?
Question by:Hollie18502
    LVL 26

    Expert Comment

    by:Chris Luttrell
    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.
    LVL 26

    Assisted Solution

    by:Chris Luttrell
    You can do it on a Report by Report basis also, but that can be tedious, we have lots of them.

    Author Comment

    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?
    LVL 26

    Expert Comment

    by:Chris Luttrell
    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.

    Accepted Solution

    This question is still open, can anyone help?

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now