Count same items on report instead of having multiple rows?

aquinco

Hi guys
I have created a report where it shows all of the Sales lines. Now, I wish following to happen.
When someone adds for example 5 exactly the same items (rows) not to display them individually but to show those items in one row but with Quantity field updated to show how many items are added. How can this be done? thanks!

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

Save the records in a temptable and update that temptable in case of doubles and then use the temptable to print the info.

postsaurav

Hi,
I partially get your query.
can you put an image what type of output you are looking for assuming sales order have 20 lines.

postsaurav

Hi,
I partially get your query.
can you put an image what type of output you are looking for assuming sales order have 20 lines.

kaspermoerch

You could use a Query object as the datasource for your Sales Lines.

The Query should then sum the Quantity field on Item No.