question

Tanquen-8329 avatar image
0 Votes"
Tanquen-8329 asked Joyzhao-MSFT commented

Keep SSRS reports as local RDL files not in the SQL database

It looks like the default configuration is for the reports to be in a SQL database table. You can export them to RDL files for back up. We are migrating an older SSRS setup and it seems to be publishing and modifing from a local reports folder with .RDL and .RDL.Data files. Is this an optional setup from SSRS or maybe how it was done in the past?

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @Tanquen-8329
Report Definition Language (RDL) is an XML representation of a SQL Server Reporting Services report definition. A report definition contains data retrieval and layout information for a report. RDL is composed of XML elements that match an XML grammar created for Reporting Services. You can add your own custom functions for controlling report item values, styles, and formatting by accessing code assemblies within report definition files.

Depending on the version of Visual Studio you are using, the rdl.data Files may be located in your documents folder or in your user folder under your username, sources and repositories. In the solution folder, there are definition files (.rdl files) for each report and a data file (.rdl.data) for each report once it has been previewed. You can manually delete .rdl.data and it will be created the next time you preview.

You could use Powershell to batch download reports locally.

If you want to close rdl.data, please see the following link: What is the rdl.data File and What Does it do?
Best Regards,
Joy


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Tanquen-8329 avatar image
0 Votes"
Tanquen-8329 answered Joyzhao-MSFT edited

Ok but it seems like this older setup is working with the reports in a local folder as the RDL files and in the SQL database. They don't need to export them as they are already RDL file in the local "Reports" folder. Maybe there is a setting to automatically export the reports so it just looks like they are working on the local files.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I can not get your point clearly. If you are migrating SSRS, you need to migrate Report Server Database and ReportServerTempDB. The report will be stored in the report server database.
This has nothing to do with local reports.

0 Votes 0 ·
Tanquen-8329 avatar image
0 Votes"
Tanquen-8329 answered Joyzhao-MSFT commented

Sorry, never used SSRS before. There is a system from 2014 that is using SSRS and when they make changes to the reports the local RDL files in a "Reports" folder are updated at the same time. Is there a setting to auto export them or was there ever a way to use RDL files and not a table in the SQL database?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If you only change the report locally, you can choose to save the file only locally instead of uploading to the server, and your report in the database will not be updated. If you want to migrate local reports, just copy the rdl file. In a new environment, you may need to modify the connection string to ensure that the report can get the data in the database.
If I misunderstand what you mean, please feel free to correct me.

0 Votes 0 ·