Sub-summary report not showing all the records
I'm testing some reporting on an invoicing solution. The particular report is based on a Line Item table which I am searching by date range.
The desired report will show the item name on the left-most column, sorted alphabetically. The next column would show the total quantity of that item from all of the invoices searched for the period.
When I put the item and quantity in the sub-summary line, I only get the total quantity of the first item description in all the invoices.
I have found if I move the quantity into a Body part, it separates out all the quantities.
How can I get all of the item quantities to a total qty on the same row as the item description?