Just a general question regarding temp tables and SSRS. Whenever I use temp tables in SSRS and the query takes longer than 16 seconds, it will time out saying it could not populate all the fields while rendering the report. Does anyone know why this happens or what causes this? I use temp tables often, but I find that I cant use them in SSRS if the query takes longer than 16 seconds to run.
its being rendered from a standard report viewer. Everything works fine, but if the query takes longer than 16 seconds, i'll get an error saying SSRS could not update all the fields.
I ended up replacing all of my temp tables with CTEs and everything works perfectly. I just hate the fact that I can't use Temp Tables in SSRS if my query takes longer than 16 seconds to run.
Now, i'm starting to get this message even with CTEs: Not really sure where to go with this one. It takes 1 minute to run in managment studio.
An error occurred while the query design method was being saved. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
SSRS and Temp tables
Posted - 09/18/2012 : 20:14:58
