A document report in Navision 2017

I was working on a report which contain two tables: Sales Invoice Header and Sales Invoice Line, watching “How Do I-Build a document report in Microsoft Dynamic Nav 2013” at minute 12:03. When the lecturer run the previous it displayed dataset but mine displays "The following fields must have the same type:

Fields: Document No. <–Number

Table: Sales Invoice Line <–Integer

Type: Code <–Integer.

Please I need your help,



Have you added “Number=FIELD(Document No.)” in DataItemLink property of any of your integer dataitem?. Just remove it and that would resolve your issue.

I added “Document No.= FIELD(Number)” in DataItemLink property of Sales Invoice Line, I have removed it. It is working Properly now.