Duplicate lines when no. of copies > 0

HollandPoland
HollandPoland Member Posts: 62
edited 2014-02-24 in NAV Three Tier
Hi all! I've a problem with report's Nav 2013. I've a report to print sales lines. If I have 1 sales line, when I write no. of copies (e.g. 2), the report shows 3 (same) lines. I group in the layout by "Document Type", "Document No.", "OutputNo" and "Line No.", but the report is also wrong.
What do I do?

Thank you in advance for your replies.

Comments

  • clausl
    clausl Member Posts: 455
    You look at the dataset in Excel, here you can see the rows being produced.
    If to many rows are produced you fix in NAV. If rows produced are OK, then try to to do exact same grouping in Excel which you are doing in Visual Studio.
    When you do this in Excel, it is usually clear why it does not work in Visual Studio.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)

Categories