SSRS Dataset Field Refresh not updating for Tablix

Question

I have updated the SP for the attached dataset that the tablix is using. The refresh worked fine and I can see my new fields in the shared data set when I look in the Fields tab. My problem is the tablix itself is not giving me access to the new fields. There is a disconnect somewhere and I cannot figure out hot to get the tablix to see the updated fields available in the dataset. I run into this problem frequently and hope I can get a good answer here to return to in the future as I am sure I will need to. I have googled and looked through the suggested questions here and I cannot find one that is directly related to this issue.

I will also know note that the report project is in TFS source control as I read that has some adverse side affects. I have marked the whole project for edit and also went to the folder structure and made sure everything was unset to read only.

I am using SSRS 2008 in VS 2010.

Answer 1

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

Answer 2

ok, this maybe an older thread, but I kept running into the same problem on occasion. The absolutely easiest way to fix this is adding the following line of code to the beginning of the stored procedure that produces your dataset for the report:

SET FMTONLY OFF;

Happy coding :)

Answer 3

I am working in Visual Studio 2015 and none of the above answers worked for me. If you are getting the data from a stored procedure, you need to open the .xsd file and right click on the data model. Select Configure, and the correct values from the procedure should appear on the right of the window. Then refresh your dataset from the Report Data tab.

Answer 4

I am having exact same issue in VS 2012. The stored procedure used as a query will not allow to refresh fields. When the button is pressed nothing happens.

The only solution I found is to flip the Query Type to Text and provide the parameter values on the exec call to the SP.

Why do we have to put up with these obvious show stopper bugs?

Answer 5

1. Open the Visual Studio 2008 reports solution
2. Open (double click) your report (.rpt file) on left pane
3. Press Ctrl + Alt + D to open the Report Data panel
4. Expand the DataSets folder
5. Find the report's main data set and right click the "DataSet Properties" menu
6. Click the "Refresh Fields" button on the popup window.

Answer 6

I was trying to use an ODBC driver for the datasource that connected ok, but wouldn't show Fields in VS 2015 SSRS report. I went back and used a datasource based on SQL Server driver (it's in the choices when designing a datasource) and it worked perfectly.