When I try to refresh fields I get an time out error... The proc just takes 30 secs to run and returns around 120 rows when i run the detail version of the sproc... but I get a time out error when i try to refresh the fields.. I am using SSRS 2008 R2. Any one else getting this error. Thanks Karen

I was getting this error when my query was taking around 10 mins to run. In my case I applied the filter in my Proc and refresh the fields and then removed the filter back from Proc.

In Your Dataset Kindly change the timeout property.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Karenros, The query time-out values are specified during report authoring when we define an embedded dataset. By default, the time-out value is set to 30 seconds. As Rakesh posted, you can try to increase the query time-out value. For more information about Setting Time-out Values for Report and Shared Dataset Processing (SSRS), please see: http://msdn.microsoft.com/en-us/library/ms155782.aspx Thanks, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

I have made custom report using ssrs. It timeout if my fetchxml query take more than 5 minute. Any solution !! I have change rsreportServer.config of ssrs web.config of CRM

I have made custom report using ssrs. It timeout if my fetchxml query take more than 5 minute. Any solution !! I have change rsreportServer.config of ssrs web.config of CRM Dataset timeout is 0 of report