Connect a linked server to MS Reporting Service?
I don't see any problems generating reports the usual way, as long as you use the 4 part name:
'select top 10 col1, col2 from server.database.schema.table' in the code used to get the data for your reports.