Microsoft have started the SQL Server labs with all kind of experimental Services on SQL Server. One of them is a Reporting Services 2008 add on that will allow you to connect to SSDS authorities and containers via HTTP SOAP to extract data sets, build rich reports using standard tools like Report Designer / Report Builder and deploy the reports to Report Manager.
Sounds promising ! The start of bi in the clouds !