I'm creating a report to show invoices through a date range. We have 3 different types of invoices and I would like a section for each.

Report with no supressing:


Report with this code(removing everything but quoted(wo.type 0)):

Detail a - Section Expert Supress [wo.type]=0

The Sum stays the same so it is still adding in everything that is not quoted.
If I change the code to:

Detail a - Section Expert Supress [wo.type]=1

I get the same issue, everything is added in but not seen on the report.

How do I make the addition correct for the totals? Should I make separate groups for all 3 invoice type or can I do it in 1 group and 3 detail sections.

Thank you

Group on {wo.type}.  Do your sums at the group level, not at the grand total level.  This will split the types by group and get you the sums at the group level.