Report not pulling in all data

[bennyamy]

I have a simple table & simple query. I created a report that pulls the data from the query. The query pulls all lines of data but the report does not pull all lines.



The table contains 5 lines. I am creating this so i can upload invoices into an ERP system for payment. I attached the report screenshot
It pulls in everything except the header data for the 2 PO that has 2 or more line items

Field1	PO Number	Invoice Date	Invoice Number	Invoice Amount	PO Line Item Number	PO Line Item Amount	PO Line Item Quantity
2	4900387376	1/12/2017	BACTEST	$3,000.00	20	$1,000.00	1
2	4900387376				10	$2,000.00	1
3	5001928338	1/31/2017	HE456	$15.00	10	$15.00	2
4	4300212454	2/1/2017	HE466	$2,500.00	10	$1,500.00	1
4	4300212454				20	$1,000.00	1

The query only sorts by Field1 Ascending

[RuralGuy]

Are you using a Group Header?

[bennyamy]

Are you using a Group Header?

Yes I am using group headers, I need some data to be on different levels for the correct upload format

[RuralGuy]

Are you grouping on anything?

[bennyamy]

I am grouping on PO number

[RuralGuy]

Can you post a screen shot of your grouping/sorting screen?

[Bulzie]

Looks like all of your fields are in the PO Header area. Only the PO number should probably be in this area so it does not get duplicated. All the other fields should go in the Detail section.