>I think that theoretically it is possible to create a report (from VFP or maybe even other tools) that gets/pulls data from various SQL Server databases (even hosted by different SQL Servers).
>But I was wondering, has anybody done it and do you find it practical?
>
>I am "drafting" an approach of creating a report for a corporate that shows how the data is used in misc branches.

Yes, it is only a matter of using various connection strings.

However, during production, when the user requests such, you might be better off ahead to have automation to scale down the require data into one centralized container and query from that data set instead.