November 2, 2009 at 3:02 pm
I am looking for a way to export a report to a rdl that is already in a Reporting Services 2008 database.
In Reporting Services 2005 I used to connect to the RS install from Management Studio and three directories would display: Home, Security, and Shared Schedules. I would then navigate to a report through the Home directory and right click and select edit. This would allow me to export a report to a .rdl file.
In Reporting Services 2008 the Home directory does not display in Management Studio. I only see the following directories: Jobs, Security, and Shared Schedules.
Why is the Home directory not displaying?
Is there another way to export a report to an .rdl file?
Thanks
November 3, 2009 at 6:39 am
I found the answer.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102320
Go to Report on Report Manager, Click properties of report, under the report definition you will see Edit and Update link...if you click on Edit you can open or Save the RDL files.
February 11, 2010 at 3:30 pm
Additionally, you can use the following....
SELECT [Name],
CAST(CAST([Content] AS VARBINARY(MAX)) AS XML) AS reportXML
FROM ReportServer.dbo.[Catalog] WITH (NOLOCK)
WHERE [Type] = 2
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply