I'd like a report that shows certain information (from Document Items) from the quotes; however, I don't want to show each part# or qty for each line item; I only want to see the grand total of the quote. Basically, my report would include the doc date, exp date, sold to, internal notes, last modified, doc status, prepared by and then the grand total.
I'm struggling with either having each line item/qty AND grand total or nothing.
I'm sure this is an easy fix, but I cannot find this information anywhere.
Thank you in advance for any guidance!
It's always difficult to understand reporting requirements via text, but I think you need to make use of Sort Headers/Footers.