For a long time I have a problem that occurs every time. I am creating an ssrs report using some select query. when I try to run the report, it takes about 20 seconds to render. I checked the sql profiler, and indeed, the query has been running for more than 20 seconds. when I copy the request to the management studio, it starts in 0 seconds.
as written in earlier posts, I tried to go around declaring parameters in the request and setting their value using ssrs parameters. once it works, currently it doesn’t ...
any other walk around?
source
share