Hi all,
New problem I've just come across, which I'm still scratching my head over a couple of hours later. I'm working on a new SSRS report, and I've created a Stored Procedure for it. The SP works fine when I'm in SSMS, but in SSRS when I set up the dataset and click Refresh Fields, it spins for 30 seconds or so and then says "Could not create a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct."
When I click the Details button, I also get: "Timeout expired. The timeout period elapsed prior to completeion of the operation or the server is not responding."
Has anybody seen this before and, if so, what did you do about it? Any assistance would be greatly appreciated.
Cheers,
Matt
I'm assuming that you are confident that the connection properties in SSRS are set up correctly so we'll skip that one :)
You might check your Stored Procedure for a couple of things..... Do all columns have a name? The first time I ran into this, I had a calculated column without an alias. Also, are there any columns with duplicate column names? I had a data set with customer_no twice and SSRS gave a similar message.
The only other thing I can think to try is to start commenting out pieces of the Stored Procedure and trying it in SSRS again until you find the section that is causing the delay. I believe that SSRS looks at the execution plan for the SP so if you have some high resource calculations taking place, it could potentially cause a time out.
Hope this helps!
- Levi