I would look at having a central database (support or management type) that contains this type of information.
Example:
- Create a management database on the instance your SSRS is configured on.
- Create linked servers to each instance you need to manage
- Create a procedure that pulls in your data from each instance and writes to a local table within your management database
- Create a SQL Agent job that executes that procedure on a schedule based on when the report needs to be run
- Build your report based on the data in that management database, allowing you to keep up with one data source.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton