Tags: create, database, deploy, files, machine, microsoft, mysql, oracle, rdl, report, rs2000, server, setup, sever, sql

Where are the RDL files on the Report Sever?

On Database » Microsoft SQL Server

4,375 words with 5 Comments; publish: Sun, 01 Jun 2008 22:16:00 GMT; (25062.50, « »)

I can create and find RS2000 RDL files on my development machine, and I can

deploy them, and they work. I setup RS2000 on my server using all the

default directories etc.

I have searched my server for *.rdl, <reportname>.rdl, etc, etc, including

hidden files, hidden directories, etc.

Are the rdl files encrypted and/or hidden somewhere on a report server?

Where?

Life used to be simple with DOS :-)

All Comments

Leave a comment...

  • 5 Comments
    • New poster. Have mercy on me.

      >From the report manager if you go to the properties of the report you

      will have an option to 'Edit'. This allows you to create the rdl file

      for the report from the location to which it was deployed. Although in

      the designer you have created an RDL file it is not this specific file

      per se that is copied to the report server. You are in fact creating

      the report definition in the report server database as metadata.

      #1; Sun, 01 Jun 2008 22:17:00 GMT
    • They are stored as metadata within the Reporting Services database. They

      are not files on the file system.

      Use Report Manager to manage them.

      hth

      "kvr901" <kvr901.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:B9F80EA5-025B-4DF3-A8BA-3F678F069571.sqlserver.todaysummary.com.microsoft.com...

      >I can create and find RS2000 RDL files on my development machine, and I can

      > deploy them, and they work. I setup RS2000 on my server using all the

      > default directories etc.

      > I have searched my server for *.rdl, <reportname>.rdl, etc, etc, including

      > hidden files, hidden directories, etc.

      > Are the rdl files encrypted and/or hidden somewhere on a report server?

      > Where?

      > Life used to be simple with DOS :-)

      >

      #2; Sun, 01 Jun 2008 22:18:00 GMT
    • When you deploy RS stores the report definitions in the database.

      Bruce Loehle-Conger

      MVP SQL Server Reporting Services

      "kvr901" <kvr901.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:B9F80EA5-025B-4DF3-A8BA-3F678F069571.sqlserver.todaysummary.com.microsoft.com...

      >I can create and find RS2000 RDL files on my development machine, and I can

      > deploy them, and they work. I setup RS2000 on my server using all the

      > default directories etc.

      > I have searched my server for *.rdl, <reportname>.rdl, etc, etc, including

      > hidden files, hidden directories, etc.

      > Are the rdl files encrypted and/or hidden somewhere on a report server?

      > Where?

      > Life used to be simple with DOS :-)

      >

      #3; Sun, 01 Jun 2008 22:19:00 GMT
    • Ah ha! Of course, it is part of the Reporting Services database... not an

      RDL file.

      I'm trying to learn too many things at one time, so sometimes I get

      confused. This time I had terminal brain-fade.

      Thank you so much for taking the time to mention the option to save the

      current report to an RDL file. I don't need it now, but I am sure I will

      soon.

      "lmcatl" wrote:

      > New poster. Have mercy on me.

      > >From the report manager if you go to the properties of the report you

      > will have an option to 'Edit'. This allows you to create the rdl file

      > for the report from the location to which it was deployed. Although in

      > the designer you have created an RDL file it is not this specific file

      > per se that is copied to the report server. You are in fact creating

      > the report definition in the report server database as metadata.

      >

      #4; Sun, 01 Jun 2008 22:20:00 GMT
    • That is the second time today you have saved me.

      Thanks again!

      "Bruce L-C [MVP]" wrote:

      > When you deploy RS stores the report definitions in the database.

      >

      > --

      > Bruce Loehle-Conger

      > MVP SQL Server Reporting Services

      > "kvr901" <kvr901.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:B9F80EA5-025B-4DF3-A8BA-3F678F069571.sqlserver.todaysummary.com.microsoft.com...

      > >I can create and find RS2000 RDL files on my development machine, and I can

      > > deploy them, and they work. I setup RS2000 on my server using all the

      > > default directories etc.

      > >

      > > I have searched my server for *.rdl, <reportname>.rdl, etc, etc, including

      > > hidden files, hidden directories, etc.

      > >

      > > Are the rdl files encrypted and/or hidden somewhere on a report server?

      > > Where?

      > >

      > > Life used to be simple with DOS :-)

      > >

      > >

      >

      >

      #5; Sun, 01 Jun 2008 22:21:00 GMT