• One option is to setup a subscription for the report and see how long that takes to run. This will reduce some latency/rendering issues.

    Also can you check the execution plan used by the Report vs what you get in SSMS. Sometimes the query plan may differ and get different performance results.

    Regards,

    Nachi