Using Report Builder - sometimes an #Error is printed, sometimes not

[courtneydunn]

When I open my report builder project, it displays #Error for all of these expressions I have built.  They are all reading from the same table/dataset on a SQL server: 

If I drag in another field from the same table it seems to reset this connection and will fix all of the errors: 

Has anyone else experienced this and is there a way to resolve this? Not exactly a workaround.

[Anonymous]

Hi @courtneydunn ，
Based on the error message you provided, I checked the relevant problem documents, it seems like reporting presentation issues. You mentioned that the report displays properly when you drag in another field, so that means there is no problem with the data in your other field. Then, according to the documentation I found, you can go ahead and check if the field contains a text value, field values are usually numbers. The solution is to qualify this value using quotes.
For more details you can check this documentation
#Error When Rendering Report - Microsoft Community Hub

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[courtneydunn]

Thank you - this is not the issue though, I don't actually need to edit any of the fields to resolve the #Error - it seems like it just needs to refresh and it resolves itself.  I resolve it by dragging in a field (and then removing it) and it seems that this refreshes the connection to the dataset and will render.

I'm thinking this may be a bug and I'm wondering if others have reported this.