SSRS Dataset Properties Reset Fields... doesn't

In an SSRS report that looks at a stored procedure, I changed some fields and when I clicked on the "Refresh Fields" button in the "Dataset Properties" window, it didn't. 

Grrrr.

Here is what fixed it for me.

I looked carefully at the stored proc, and I had some code before the select statement that returned the data. I pared it down so the stored procedure had exactly one SELECT statement and it refreshed. 

TEMP tables are a big thing, but most any statement besides the SELECT probably will cause this issue. 

On another occasion I had to go into the Query Designer and change the parameters to get it to make the round trip. It appears to cache the results. 


RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences