History of Report Definition File for Published Reports...

I would like to know if there is a way to maintain the history of changes to the reports that have been published to the report server?

I know that the report definitions get saved onto ReportServer database. But let's say a user makes a change to the published report and then saves it back to the server. And that the latest change was incorrect and I have to revert back to the previous version of the published report. Is there a way to do that? Does the report server maintain a history of previous versions.

There is a history for each report and I think that corresponds to the history of report executions (output data). But I am talking about the history of actual report definition.

Thanks for you help.

The report definition is stored as XML in the ReportServer database.

There is no concept of source management in Report Server. How would the user be making a change to the published report?

If they are accessing the report through Visual Studio, you would perform all source control operations there.

Otherwise you may be able to setup a trigger to copy the report definition to another table, though it would mean some hacking around with SQL profiler to determine what fields are required.

You could also setup a job that runs the RS Scripter utility to export definitions on a regular basis.

cheers,

Andrew

|||

I should have told "for reports created using the report builder". These reports are published to the report server. Once published, the users can open the report again from the report builder and then make changes to the report and then publish it again. In such a case, is there a way to track the history of changes in that published report? Because if some user edits a report and messes it up, how would I go back to the previous version of the report?

Thanks for your response.