Friday, March 23, 2012

Recovering Reports

I had an unfortunate situation where a downed server resulted in a significant amount of lost work (the rdl files of several reports I had been working on).

I had previously uploaded them to the reporting services server and had hoped that I could recover them from there - but I can't find them anywhere.

Is there a mechnaism for recovering rdl files (or at least the sql behind them?) from the reporting services server?SadIt's very easy. Open the SQL Managment Studio. Connect to Reporting Services. Then right click on each report do you want to export and select the option script, script to file.
That's all.
I hope it helps you.
VectorR3|||Excellent - thank you...sql

No comments:

Post a Comment