Sort item sales report by product group

V5 Question
1

Hi.

I need help modifying the report template for item sales report, so that it groups all products from each product group together instead of jumbling them up.

For example all pizzas are listed together, cocktails are listed together etc.

Thank you

Anders

2

Simplest way is to add group as a column and sort asc.

3

Thanks for the reply.

Can you show me the string. I have no idea how to do that

4

It should show on the preductive popup.
Would be something like M.Groupecode.asc

5

Solved with thanks. I added O.ItemGroup.desc and that worked. If anyone else is doing this, remember to delete other .asc or .desc to make it sort the way you want.

A follow up question is then. How to choose the sort order of you don’t want it alphabetical. For example:

Starter
Main Course
Pizza
Salad
Desert
etc

I tried O.ItemGroup =Pizza Pizza.ItemGroup just Pizza and a few others without result.

Any ideas?

6

Add a number in from of groupcode LOL :stuck_out_tongue:
You would need to use an @ declaration with CSV type list and then do a =$1 expression on report which will give you a table per group.

7

Thanks for the the suggestions on.

I couldn’t get the second option to work, so I went lazy and just added the numbers in front. Works like a charm lol

8

Will do the job LOL, used that trick on so many different things hehe