• The slowest part of your reports is by far the data retrieval. This means that your tsql to get the data is the biggest impact.

    That can boil down to either bad logic, complex business rules, poorly running tsql, or any combination of these items.

    To improve report performance, you need to tune your queries.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events