Menu
I am working on a legacy application for a client, that uses Reporting Services. I have imported the project SVN repository, which includes a Reporting project and folder, setup in a Visual Studio Reporting solution/project.
Included in this SVN folder (but not the VS solution/project) are .rdlfiles (the actual report definitions) and .rdl.data files . I believe the .rdl.data files are used for caching reports.
From a development perspective, should these .rdl.data files be source controlled? I was thinking of deleting them from the repository, as they tend to change very often (almost everytime I preview a report), and it's making SVN report that the file/folder has changed, which is irritating.
I don't think these .rdl.data files are necessary for deveopment. Can/should I delete them from source control?
953
The location of this file depends on what version of Visual Studio you are using. For versions up to 2015, this file can be found in C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies.
SSRS has a built-in caching capability where the data required to render a report can be retrieved from the ReportServerTempDB database instead of executing queries on the database specified in the report's data source. Caching is enabled in the Execution Properties for the report in the Report Manager.
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.
SSRS Cache Refresh Options Please navigate yourself to Cache Refresh Options tab and select the New Cache refresh Plan option. Once you click OK, it will ask you the description of the Cache report, and the cache refresh time. Once you click on the Configure button, report manager will navigate you to a new page.
I never store them in source control. I think they are used for offline diagnosis of report problems. I think you could send your report and the .data file to someone and they could attempt to debug them. I think I once sent some when I had a case with microsoft.
175
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
