• Are your reports calling stored procedures or using embedded SQL? Are there lots of joins in the code? Is all the data on the same machine?

    If the sole purpose of this report is to do aggregates in Excel, then also consider what Jeff mentioned about pulling the data directly into Excel from Sql Server.

    ----------------------------------------------------