SSRS Dataset Field Refresh not updating for Tablix
Just found it... I don't understand the need for hidden menus like this..
Click the report itself, then go up to View on the menu and at the very bottom there is "Report Data". From here you can select your dataset and go to its properties and refresh the reports attached dataset's fields. What a pain in the butt.
Here is a link that helps better explain it. http://blog.dontpaniclabs.com/post/2012/01/26/Developings-Reports-for-SQL-Server-Reporting-Services
After changing the Stored Procedure code, without changing the name and number of fields returned, I could only get the report to seemingly call the new format of the stored procedure by clicking the Refresh button in the report's Preview tab.
Go into your solution folder, where the rdl's are stored and delete .rdl.data file for your report. Next time you'll run the report, new rdl.data file will be created and it will have all the new fields from the updated SP.
You can also delete the .data file if you still can't get it to refresh.
- Go into the file folder where the .rdl file exists
- Next to it, there should be a file with the same name with the .rdl.data extensions. Delete this file.
It appears to force the refresh probably because it has to recreate the file.
Here's a less invasive way but may not always work:
- In the Report Data windown, right click on you dataset and click Dataset Properties like so:
- Click Refresh Fields near the bottom right of the Dataset Properties window:
