Background info: I am trying to customize the generic SCOM 2007 reports. There is a report server on a SERVER that contains these reports. I just want to view the SQL code or copy the .rdl file to my filesystem so I can see where the data is being pulled from and make my changes to it. So when I navigate to http://SERVER/Reports I can view all the reports just fine. But when I log into reporting services via SQL Management Stuido there are no reports visible. I believe they should all be listed there and I could right click, edit, and save them to my file system then open them in visual studios. Why are the reports not visible when using Management Studios? I have tried using different versions of management studio but no luck. When I check the properties of the reporting services isntalled on that server it says the report server path is http://SERVER:80/ReportServer. This is not the path I was using so I thought that might be the problem but when I open that link in a browser it still shows all the reports, it's just not in a pretty format. So if someone could shed some light onto why these reports aren't showing up in Management Studios or give me another way to view the code for those generic reports or another way to copy the .rdl files to my filesystem I would be ecstatic. Thanks, Jason

Hi, You havent mentioned your SSRS Version. In SSRS 2005 Reporting Services login, we had HOME folder, under which the deployed reports were available. In SSRS 2008, the HOME folder has been removed. I guess this is what you mean. If you want to copy the .rdl file, you can do that from Report Manager-->Show details--?Edit. Hope this helps.MSBI Developer

Hi tarheels058, As TDPN posted, we cannot view, manage, distribute or secure Report Server content in SQL Server Management Studio 2008 or later. For more information, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms143380(v=SQL.100).aspx In addition, you can try to use the Reporting Services Scripter tool to manage items on Report Server. For more information, please see: http://www.sqldbatips.com/showarticle.asp?ID=62 If you have any more questions, please feel free to ask. Regards, Bin Long