Hide the sub reports in ssrs

Question

Hide the sub reports in ssrs

p.nagaravikumar

SSC Eights!

Points: 844
More actions
July 9, 2008 at 6:04 am

#184481

i want to hide the sub reports in the tree view of reportviewer application.I can hide these through reportmanager by selecting each report and hide individually.but i need dynamically hide all the subreports.How i can do please suggest any solution

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

nigel.c.west Hall of Fame Points: 3468 More actions · Answer 1

If this is really all you want to do (to hide them from the tree view) then probably you can use the same type of expression you have used for Visibility, but use it on the Document Map entry.

For example, if your visibility expression looks like:

=IIF(Fields!Region.Value="N/A",TRUE,FALSE)

Then you could also create a document map entry that looks like:

=IIF(Fields!Region.Value="N/A","","Region Sub Report")

Or maybe it's more complex, but if so, you need to give a little more information on your requirements.

Regards,

Nigel West
UK

p.nagaravikumar SSC Eights! Points: 844 More actions · Answer 2

Thanks for your quick response.I need some more clarification i am showing my requirement here

+PeerGroup

PeerGroupSignatureAnalysis

PeerGroupSignatureAnalysisDetails(SubReport)

PeerGroupRanges

+Entity

EntityNotesReport

in web application under tree view reports are presently showing like this.I want to not to display the sub report name in the tree view.

Required Output

+PeerGroup

PeerGroupSignatureAnalysis

PeerGroupRanges

+Entity

EntityNotesReport

nigel.c.west Hall of Fame Points: 3468 More actions · Answer 3

Are you using the document map entries?

Nigel West
UK

p.nagaravikumar SSC Eights! Points: 844 More actions · Answer 4

Hi,

I am not using document map entries.Presently for solving this problem i an going to report manager and going to properties of the subreport and there enable the check box which describers Hide this report in tree view option.But if show many reports are there it is difficult to do each and every report.So i need any other solution

Thanks

nigel.c.west Hall of Fame Points: 3468 More actions · Answer 5

I have never seen this option, the only one I can find like this is

Hide in List View

Is this the one you are using?

If this is the one you are using then it has nothing to do with an actual document tree or map, it simply means that the end user will not be able to see (and therefore select to run) the sub-report using the report manager.

If this is what you are referring to then this is the only control available.

Nigel West
UK

p.nagaravikumar SSC Eights! Points: 844 More actions · Answer 6

Sorry,I am using Hide in list view only.Then i need to proceed for each and every report and select this option.Or any other method is there.If not there then i will follow this method.

Thanks for your valuable suggestion.

Regards

Ravi

nigel.c.west Hall of Fame Points: 3468 More actions · Answer 7

Yes, this is the only option that will deal with this.

Nigel West
UK

maddogs SSCrazy Points: 2474 More actions · Answer 8

If you have update access to the database behind Reporting Services and know the names of all the objects you want to make hidden (subrereports in this case), open the ReportServer.dbo.Catalog table and set the 'Hidden' column value for these objects to 1 which is a bit datatype. Unfortunately there is nothing I am aware of that identifes if an object is a subreport versus a normal report so that you could do a mass update of the hidden column values basd on that identifier. As a normal practice however I name all my subreports with a prefix of 'SR_' so in my case I could have done an update like:

UPDATE ReportServer.dbo.Catalog SET Hidden = 1 WHERE LEFT(Name, 3) = 'SR_'

NOTE: The above is for SQL Server 2000 and I am not sure if it would apply to 2005 or 2008.

maddog

primerasoft SSC Enthusiast Points: 108 More actions · Answer 9

Hi,

I had hide some of the reports in SSRS 2008 using report manager. Few days later I want to show those reports again. Where can I see those Hidden reports ? I had tried all the ways. In SSRS 2005 we can see all folder/reports details thru SSMS. But in SSRS 2008 saying that all options will see thru reports manager. Please give an idea ?