In our environment, we are running SSRS 2008 with enterprise SharePoint 2007. We want to create a process that will deploy SSRS reports and data connections in a way that will give us the ability to proliferate those to multiple SharePoint sites without having to manually deploy to each one.

The concept we are toying with so far is a "Common Repository" that will provide the ability for the SSRS Viewer web part to get it's reports from the common repository (one version of the truth) and not be limited to reports only in the site collection.

Another idea we are throwing around is using the "Send To" function.