NAV 2013 Report grouping

Krieck

I've succeeded in making an invoice which groups it's lines based on the "Item Category Code" and "Product Group Code" fields from the Item table.

Unfortunately I also need to print the Sales Comment Lines for each Sales Invoice Line.
When I place DataItem "Sales Comment Line" 1 level under the "Sales Invoice Line" DataItem, the total amount of the groups ("Sales Invoice Line".Quantity * "Sales Invoice Line".Unit Price) in the report isn't correct anymore.

Has anyone already made this kind of report in NAV2013?

himanshu

please elaborate more abut ur problem so that we can help.
at present i can only suggest u to use last function befor ur field eg: =LAST(Fields!ABC.Value)
u will get the correct amount

amazan

Hi Krieck,

Are you looking for something like this?.
http://www.fileswap.com/dl/ovrGfCvmGP/

Pay attention to SalesCommentLine DataItem.

Greetings

Nikolas

you have to set the condition on sales comment line in visual Layout that IIF(isnothing!,false,true)
And set group in sales comment line group by Sales comment Line .Line No.
It will work better.