Maybe parameter sniffing? I noticed some threads where this was the cause of slow SSRS reports.
T-SQL Best Practices - Parameter Sniffing
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP