7 Replies Latest reply on Oct 5, 2016 12:25 PM by Matt Hong

    Hidden fields within data connection file

    Mikhail Venkov

      I am running into a strange problem. There are some fields that exsist in the data connection file but are never displayed. They are not hidden through "Hide" context menu option. I've selected "Show Hidden Fields" option. I know the field exsists somewhere out there because when I try to create a calculated field (called "Number of Incidents") it says it already exisits in the database with that name.

       

      That wouldn't be a big problem on it's own but when I published the data source to the server and used it, some sheets would get an error and not load. It would say "No such column [Number of Incidents]." Even though, like I said before, this field is not used or shown anywhere.

       

      Any ideas what might be at fault here?