Hi,
I went into the data view creator and linked the “Sales Header” table (Field: No.) with the “Sales Line” table (Field: Document No.) but when I create a report using fields from each of the related tables I get the following error: “Filterfield is missing. Fielterfield of 0 or blank is not allowed”. I would really appreciate any guidance as to why I’m getting this error and how to fix it.
Note: I checked with our system architecture and he told me that these are the related fields on both of these tables so not sure why I get a #Value! error
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
The Data View Creator only affects the Jet Report Builder tool. If you build a report with that tool, then the result shouldn't give you the error you are saying. However, I suspect you are actually trying to build the report by writing formulas by hand, in which case the Data View Creator has nothing to do with what you are doing. If so, please attach the report or tell us what functions are giving this error. If this the case?
Regards,
Hughes
Please sign in to leave a comment.