Forum Discussion
Using Report Builder - sometimes an #Error is printed, sometimes not
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
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.
