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

Old thread, but I ran into this using VS 2015 and SSMS 2016. I was certain it was an issue with VS. When I went back to SSMS and tried executing my stored procedure, however, I found that passing certain parameter values would cause the query to fail. Interestingly, I was able to ALTER the stored procedure without encountering any errors. (Perhaps because some combinations of parameters wouldn't result in a failure?)

Anyways, at the end of the day it was faulty coding in my sproc that was causing the fields in SSRS not to refresh. When I went back and corrected the issues with my code, everything worked as expected in VS.

Answer 2

I had this same issue but the cause was different from the other answers at the time of this writing.

In my case, the stored procedure used as the data source was returning multiple data sets (due to some debugging code that I had left in there).

SSRS was "seeing" the fields in the first dataset, whereas I was expecting it to see the fields in the second dataset.

Removing the extraneous datasets fixed the issue and SSRS was able to see the fields that I intended.

Answer 3

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.

Answer 4

You can also delete the .data file if you still can't get it to refresh.

1. Go into the file folder where the .rdl file exists
2. 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:

1. In the Report Data windown, right click on you dataset and click Dataset Properties like so:

1. Click Refresh Fields near the bottom right of the Dataset Properties window:

Answer 5

I had the same issue. I installed SP1 so that .rdl.data file would get generated which inturn also fixed the data refresh issue.

Reference: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e2b199df-bc1b-4211-9110-85a0c63454b8/why-does-ssrs-not-create-a-rdldata-file-when-previewing-a-report?forum=sqlreportingservices

Answer 6

Had the same issue and I was able to resolve it by renaming my dataset in properties, creating a new dataset with the original name, and then hitting the refresh button.