I have a report solution with multiple reports. Until now, I could not add a SPROC based dataset without problems. However, when I try to add the last dataset and use SPROC for its query type, when I click Refresh Fields, I get the following error: Timeout. The wait period expires before the operation is completed or the server is not responding.
I tested the database connection in the properties of the data source> Modify> Test connection and it works fine.
I increased the timeout to 100 in the following areas:
SPROC works great in an SQL database. It takes about 55 seconds.
Any other ideas? Thank.
UPDATE: now I can not add any data set using SPROC. I even thought that SPROC work fine in SQL !!!!!!
If you use Report Builder, you can increase the timeout also in your DataSet.
, , , , , , , , . , , SSRS, , , .
, , sp_who , , . 52 , , , . , .
NO LOCK, , . , procs ... , . NO LOCK . , .
.
, .
Now that a new column has been added, then do not comment on what is being requested in sp.
My solution was to go to the dataset properties for the given dataset, paste the query into the "Request" field, click "Update Fields" and click "OK".