3 Replies Latest reply on Apr 14, 2015 6:58 AM by JeffBroderick

    Sub-summary report not showing all the records

    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?