Very good, we will rely on SQL Views to write our code against then in conjunction with linked servers.  Thanks for the insight.

Thanks Jeff, but what if the database name may be something different and the owner may be different?  I was wondering if I wrote views local in my app DB...

Actually, the sub total will produce whatever the aggregate function is in the detail cell, so if it is an average, it will produce an average subtotal rather than a...

Found out how to add a sub-total, but how do I make that an average instead of a total?

I'm trying to figure out how to add a total column to a matrix table?  When I add a column, it adds it for each occurrence of my series rows...any...