Grouping duplicate product in invoice

[Hydroxy]

I wrote an application to control product movement in my office but I cannot grouping duplicate list of product's name. For more information, My company's product need to use serial number to detect when it's received or sold out or comeback to repair.

This is my script used to add data to table

 this is the result when I add to table ( I type in Excel for easy to see)

but I need them to show like this

So, anyone could you please suggest for this case

 

[comment]

To display products grouped by their name, sort them by name and use a layout with a sub-summary part and no body part. 

 

[Hydroxy]

Thank you for your suggestion. I follow that and I have got it  ^___^

However, if I use this method I cannot fix the end of report that need to print on my company form.

I try to use trailing grand summary but it not work to fix the position.

Do you have anymore suggestion for this situation.

[comment]

3 minutes ago, Hydroxy said:

I try to use trailing grand summary but it not work to fix the position.

I don't understand what you mean by "it not work to fix the position".

[Hydroxy]

my office have printed form for invoice that need to fix the position of any letter to match position when the report printed.

 

like this

[comment]

If you want to place the totals in a fixed position relative to the bottom of the page, then you must use the footer part for this. But that will only work if the entire invoice fits on a single page.

[Hydroxy]

2 hours ago, comment said:

If you want to place the totals in a fixed position relative to the bottom of the page, then you must use the footer part for this. But that will only work if the entire invoice fits on a single page.

Many thank for your suggestion