2008 Report Server - where are my files ?

Question

2008 Report Server - where are my files ?

onlo

SSCertifiable

Points: 5080
More actions
March 25, 2010 at 4:30 am

#386578

I created some reports with : MS SQL Server 2008 + Report Builder 2.0,
I could list them out :
(1)http://localhost/ReportServer or
(2)use Report Builder 2.0 to open my reports.
However, in the Windows Explorer, I couldn't find out (or even I didn't know) what are their corresponding windows files.
I need to find out the answer as I need to do some Windows security control and I also wonder where were their Report Definition Files located.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Luke L SSC-Dedicated Points: 35547 More actions · Answer 1

Check out the following section from BOL http://msdn.microsoft.com/en-us/library/ms159236%28SQL.90%29.aspx

The pertinent part is about Published reports which is what you seem to be asking about... Basically they are stored in the Report Server database not as specific .rdl files on the SSRS instance.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Ben Teraberry SSChampion Points: 11845 More actions · Answer 2

For information about how to set permissions on the reports you created, you can read http://msdn.microsoft.com/en-us/library/aa337491.aspx and other Google searches for "Reporting Services security".

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

onlo SSCertifiable Points: 5080 More actions · Answer 3

Thanks for all of your information

But I still don't undrstand :

Why if I use Visual Studio to creat a report, I can locate the report's fils in the Windows Expolrer easily

But if I use Report Builder 2.0 to create a report, I can't locate its files, its files seems to be disappeared in the Windows Expolrer.

Why ?

Luke L SSC-Dedicated Points: 35547 More actions · Answer 4

When you create a report using VS, it actually create the rdl file on your local machine. When it's published to the report server the XML is taken from the rdl file and inserted into the catalog table in the report server database. Once it's on the server it's no longer stored as a file per se.

Although I do not know for sure, it would seem to me that Report Builder would create a temporary file on your local machine which is then automatically published to the report server when you save it. According to Book Online (SQL Server's help files) it appears as though you can save the .rdl files locally to your machine and then report rendering will happen on the local machine as opposed to on the report server. So it looks like you can save the files to your local machine after all.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Paul White SSC Guru Points: 150467 More actions · Answer 5

In addition to the information Luke posted, you might find this reference useful:

Finding, Saving, and Managing Reports (Report Builder 2.0)

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Perry Whittle SSC Guru Points: 233846 More actions · Answer 6

Hi

the following is a great little utility I use for managing and extracting reports, etc from SSRS

http://www.sqldbatips.com/showarticle.asp?ID=62

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉