September 8, 2008 at 2:03 am
Hi,
I`m using win XP in cilent PC and win2003 in Server PC.I`m developed a simple reports in client PC and deployed in Server.
Nowaday, My client PC is crushed, so my developed reports rdl file are deleted.
I want rdl file located in server(PATH).
September 17, 2008 at 1:41 am
Hi,
I got the Solution.
1. First open the MSS Management Studio.
Start--> Programs--> Microsoft SQL server 2005---> SQL Server Management Studio.
2. Open "New Query" Button.
3. Select Available databases "ReportServer"
4. Write the Query
SELECT Name,
CAST(CAST(Content AS VARBINARY(MAX)) AS XML) AS reportXML
FROM Catalog WITH (NOLOCK)
WHERE Type = 2
5. Click "Execute" button
6. Display Report Name and Report XML link.
7. Click the XML link and copy XML code.
8. Open the "Notepad" and Paste the XML code.
9. Change the extension 'txt' to 'rdl'
10. Open the RDL file...
September 17, 2008 at 8:33 am
You can also go to the Report Manager Web Page, select Properties and Click Edit Report. This allows you to download the rdl file.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply