AnsweredAssumed Answered

Sub-summary report not showing all the records

Question asked by JeffBroderick on Apr 13, 2015
Latest reply on Apr 14, 2015 by JeffBroderick

Title

Sub-summary report not showing all the records

Post

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?

Outcomes