The folks at R-Tag.com have just released a new tool called CR Data Source which is designed to do just one thing. It lets you perform a “Set Location” on a folder full of reports, all in one stroke. The tool does just this one task, but then again it only costs $29, so it will probably be a popular choice for certain users. If you look at my review of RPT management utilities you will only find one other tool that does this, and that tool does lots of other things and costs about $400.
The current limitations are:
- It only works with ODBC/OLEDB
- It can only be used on reports that only have a single data source.
But even with these restrictions, the tool will still work on most reports. And, if the tool catches on I am sure the folks at R-tag would be open to suggested improvements. As always, if you try this tool please let me know what you thought.