I have been racking my brains about this all day and i cant figure it out. I am building a brand new report, and I have added a load of fields from the "Purchase Line" table. When I select "View" --> "Layout" it opens the SQL report builder as i have "User Report Builder" set to "Yes". For some reason for some of the fields, it creates a duplicate column in the report with the field name but "format" on the end. E.g. "ProjectCode_PurchaseLine" was selected in NAV Dataset designer but when viewing layout in SQL Report Builder it has "ProjectCode_PurchaseLine" and "ProjectCode_PurchaseLineFormat". It does this 20+ fields, but not all fields strangely. I have tried to view layout with "User Report Builder" set to "No" so it opens in "Visual Studio 2013 - Shell (Integrated)" but this only shows the XML view of the report, not a visual view AND it still includes the duplicated columns with the "format" suffix. These fields don't appear in the table why are they here ? I can delete them in the report builder but then the report errors on compile and when I view layout the next time, all the "format" fields re-appear. Help :/
*This post is locked for comments
I have the same question (0)
