Show Information from several SharePoint in a single Report

You could create an intermediate table in SQL Server which sould allow more flexibility of querying. The main gotcha in this approach is that the intermediate table would need to load prior to the report running. For a scheduled report this can be managed easily, whereas an ADHOC report might have problems.