I have a BAQ report I want to add a field to. I added the field in the BAQ and tried to Sync Dataset in the Report Style Maintenance screen but get the error below. I I looked at the group named JobHead_JobNum1 and I don’t see anything referencing the partnum field. I don’t know where to see the Hidden expression. If it means the Hidden settings (like is it visible) it’s just set to false, there is no formula or anything.
Nothing there 
It’s just set to Show. When I choose that radial to see the formula there is nothing in the formula.
Reckon how is it organized, is it possible it is a Static section underneath the Group that it is talking about?
Is jobpart_partnum still a field in your BAQ? Did you possibly remove that column, or replace it with another?
My guess is that the “Sync Data” is only really any good at adding fields. If a field was “replaced” by another (like if your BAQ originally had orderhed_ordernum, and you decided to use orderdtl_ordernum - which are basically the same - instead)
FTR - “Sync Data” is really good at another thing … totally screwing up an RDD based report.
This sounds vaguely like an issue I’ve run into many times. SSRS has a concept of the “current dataset”, which serves as the default when the dataset is not specified in a field expression. You can’t directly see or change the current dataset in Report Builder. But it changes if you drag and drop a field from another dataset, so a seemingly unrelated change could break other fields that worked before. The solution is to either always specify your datasets, or, after adding fields from another dataset, drag in a new field from the dataset that you intend to be the default and then delete it.
