Duplicate record in report exported to excel

(0) Share

Report

Posted on by AntonioTorre

574

When I run report 106 Customer Detailed Aging (NAV2016) it looks fine in NAV, but if i chose Print in Excel, the last line of each customer is the same as the first line of that customer, it is as if first line is printed twice (at the begining of the group and then at the end of the group). However, if I print it in WORD it goes fine.

How can I avoid that last line of the group to be a copy of the first line of the group?

Output in Nav (right)

Output in Excel (wrong):

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Amol Salvi 18,696 on at

Like (0)

Report

RE: Duplicate record in report exported to excel

I think it is customized report .Kindly check the report for excel programming did in report
Community Member on at

Like (0)

Report

RE: Duplicate record in report exported to excel

Check some standard NAV report which uses Excel export. Like R108. take a look at that report might help you to fix this issue.
Suggested answer

Rabin 2,976 on at

Like (0)

Report

RE: Duplicate record in report exported to excel

Hi,

It seems like the Report is a custom made. While creating a report in some cases the values are not properly fetched and presented. There might be some hidden loops of the code or some values that, due to the grouping is holding the first value and is being pulled at the end.

I also agree with Alexander, try checking for the default setting of the excel. And also check if the variables are properly managed in the NAV Report.
Suggested answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Duplicate record in report exported to excel

My best guess it is happening due to the behavior of your Excel for Group structure. Try playing with the default settings of the Excel Group structure, perhaps it would resolve your issue...