For example: You have imported SQL 2005 Management Pack and its working fine, it monitors SQL servers fine, alerts, health state and everything for SQL monitoring works fine. But when try to see Reports for SQL under Reporting, you don’t see the SQL Server 2005 folder itself listed to see its reports.
You may also notice below behavior:
You check http://SRSservername/reportserver and find ALL reports folders listed here, including the missing reports folders in console.
You check http://SRSservername/reports and find some reports folders missing here. (In our example SQL Server 2005 is missing)
If you check Operations Manager event log on RMS server, you don’t see any error or warning event related to Data Warehouse reports deployment.
Cause: This can happen if the Report folder is configured with "Hide in list view" check box in its properties settings.
Resolution: To resolve this take the steps below:
1. Go to http://SRSservername/reports site, here click on Show Details button and it will list ALL reports, including the missing ones.
2. Then click on properties icon for one of the reports folder which is missing in console and you will find that, it has a check box selected which reads "Hide in list view".
3, Uncheck this checkbox, and apply it.
4. Now it should start showing under http://servername/reports even when Hide Details is selected.
5. It also starts showing under Operations Console in Reporting view. (You have to right and click refresh to see them)
Uncheck this checkbox “Hide in list view” for all the Reports which are Hidden for you, and all the Reports will start showing under Reporting.
Milan Jajal | Manageability Support Engineer