Grouping line items

Hi @ALEXSLUSSER15! For this you’ll need to add a grouping section to the report and then group by the either the refnbr of the work order or something else which will lump all the items together and then grouping sections auto SUM the amounts in the group, so that is already taken care of.

Have you already tried adding a grouping?

@ALEXSLUSSER15 Yes that is what I meant, this will add a grouping section to the report and the items you are wanting to group need to be placed in the grouping section which corresponds to the grouping condition specified.

After adding the field to the grouping conditions in your screenshot, a new section was added to the report, groupheader, place the fields needing to be grouped in there.

@ALEXSLUSSER15 You can tell that this grouping section corresponds to the grouping condition because the grouping condition is called ‘list’ and this screenshot shows (Header of list), so that means that fields placed within this section will be grouped according to the grouping condition specified, which is AMProdItem.ProdOrdID.

You may need to expand the section, but this specific groupheader section was created when the grouping condition was created and if you delete the grouping condition, it will delete the group section on the report.

@ALEXSLUSSER15 Place the fields in the groupheader section:

They will be grouped according to the grouping conditions specified, if there are multiple things to group on it will group them in hierarchical order

@ALEXSLUSSER15 It’s close, but the fields were placed in the detail section:

They need to be moved up into the groupHeaderSection1

@ALEXSLUSSER15 It’s close, but the fields were placed in the detail section:

They need to be moved up into the groupHeaderSection1

@BenjaminCrisman I did as you suggested and this did not solve the issue. I moved them into groupHeader and it is still printing each line item.

 

@BenjaminCrisman After a little experimentation it is now printing a single line item but it is not summing the “material used” column as I intended. I want it to print one line item, but sum the material used from ALL line items. How do I make this happen?

@BenjaminCrisman Is this the screenshot you’re looking for? If not, let me know.

@BenjaminCrisman The field is in the screenshot below. I’ve also attached a screenshot of the printed report- the actual total should say 2723. 

@BenjaminCrisman That worked! Thank you.

I have another question for you- how do I add a running line number?

@ALEXSLUSSER15 You can check some other reports (Like SO641010) to see how it is setup, but it looks like this:

Create a LineNbr variable for the section you want the line numbers to show, give it the ValueExpr seen, then add the variable to the section

@BenjaminCrisman I see that you have it in the detail section, will it work in the header?

@BenjaminCrisman I added the variable but it is continuously printing as 1.