Hi, I have a problem with report, I have three table(product,invoice,invoicelineitem) and want to know for each item how many I sold(qty)

for example:

Invoice:

Invoice:1 Item A qty::5

Item B qty::6

Invoice::2 Item A qty::7

Item B qty::6

I want see in report:

Item A qty::12

Item B qty::12

Stuff.zip

Produce your reports from the Linetems table. A report sorted and summarized by invoice will look like your first example; a report sorted and summarized by item will look like the second one.

How I can summarized in report?

This way?

InvoiceReports.zip

Thank you very much,

But In my database don't change like you sample, can u see?

I don't understand what you mean.

I change my database like your sample, But in report have error and don't show like your report

Stuff.zip

I am afraid that's something you'll need to work out on your own. So far, I don't see that you have a reporting layout with the necessary sub-summary parts, nor a script to produce the report.

I design layout but in the end, it give me wrong result.

Stuff.zip

If you look again at Comment's InvoiceReports.fp7, you will find a layout named Report. This has sub-summary parts like what was explained. Not a single layout in your last file has a report layout or sub-summary in it at all.

I have modified your file and added a Report layout. When you create a new layout, FM walks you through 'report' and adding sub-summary parts - it even shows you the resulting report (to the right) as you design it, inserting sub-summary parts as you specify. You need to understand how this works.

Look at your report layout in layout mode. It clearly shows the sub-summary parts. You can work with them by selecting Layouts > Part Setup.

StuffMOD.zip

thank you I find my answer.