Report Grouping issue.

Question

Hi,I’m building a report in Acumatica Report Designer where I want to show headings like “Smoking Tobacco” and “Moist Snuff” only once, followed by all the detail lines for that category.Right now, the group header (e.g., Smoking Tobacco) is repeating for every single record. I only want the heading to appear once, then all detail rows for that group, and then the next heading (e.g., Moist Snuff) with its details.I tried using an expression like: =IIf([InventoryItem.ItemClassID] = 'PIPETOB' OR [InventoryItem.ItemClassID] = 'HOOKAHTOB' OR [InventoryItem.ItemClassID] = 'RYO' OR [InventoryItem.ItemClassID] = 'WRAPAPRTUB')…but this still causes the header to repeat for each record instead of grouping properly.How can I set up grouping in Acumatica Report Designer so that the header prints only once per group, with all the records underneath it?I am trying to populate for example smoking tobacco transaction uder its heading and other data under another one. Report is based on the Report format what ever user selected from Param. Just want to get an idea from you all. Thankyou

tahayabali · Accepted Answer

Yes this is solved and already in our production. Sorry for delayed reply. I changed the logic created the Subreports

meganfriesen37 · Answer

It sounds like you’re trying to group by item class? If so, I’d recommend that you use the [INItemClass.ItemClassCD] as the data field for your grouping.

Or if you’re trying to group multiple item classes together, then you’re on the right track with your grouping. In the scenario below, I’ll end up with 3 groups max.

i.e. use =IIf([INItemClass.ItemClassCD] = 'Class A' OR [INItemClass.ItemClassCD] = 'Class B', 1,
iif([INItemClass.ItemClassCD]= 'Class C' OR [INItemClass.ItemClassCD] = 'Class D', 2, 3 ))

Move your group header “title” box to the GroupHeaderSection2.

If you’re doing the multiple classes in a group, then take the same formula as above, but replace the 1 / 2 / 3 with your group titles

=IIf([INItemClass.ItemClassCD] = 'Class A' OR [INItemClass.ItemClassCD] = 'Class B', ‘Group Title 1’,
iif([INItemClass.ItemClassCD]= 'Class C' OR [INItemClass.ItemClassCD] = 'Class D', ‘Group Title 2’, ‘Group Title 3’ ))

Report Grouping issue.

1 Attachments

4 replies

1 Attachments

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded