Friday, March 9, 2012

RDL Location on the Server

Hello,

I'm wondering where exactly is the default location of the rdl file stored on the server?http://<server>/reports/

Thanks,

-Lawrence

If you right click one of your reports and select properties, it shows the full path to the report.

It is stored in your report server project folder by default.

|||

Report Property yields

http://<server>/Reports/Pages/Report.aspx?ItemPath=%2fCustomProducts%2fRIAx%

Report Server Location is below, but does not provide me location of the RDL files.

C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\

Are reports not stored as RDL? Instead just stored in the config?

-Lawrence

|||

Anyone else know where I could find the RDL on the server?

Appreciated!

|||

Hi there,

The reason you don't see the RDL on the server is that it is in your ReportServer *database*. Not separately on disk. I think in the Catalog table in compiled form.

To see how you read the report definitions (either using the SOAP API or the RS.EXE utility) you might want to start here.

http://msdn2.microsoft.com/en-us/library/aa258101(SQL.80).aspx

>L<

No comments:

Post a Comment