Custom Group Report

[Eddie14jan]

Good day all
Please can someone help me with a customized group report.
I want to see revenue generated for Food, Shisha, Bottles & Bar.

For example:

Food Revenue Report

Group Name | Quantity | Amount

Main Course | 5 | 1000
Pizza |10 | 2000
Starter. | 7 | 4000
Dessert. | 6 | 1000
Total. | 28 | 8000

Bottles Revenue Report

Group Name | Quantity | Amount

Vodka btl | 5 | 1000
Rum btl | 10 | 2000
Cognac btl. | 7 | 4000
Whiskey btl | 6 | 1000
Total. | 28 | 8000

Bar Revenue Report

Group Name | Quantity | Amount

Mocktails. | 5 | 1000
Cocktails | 10 | 2000
Softdrinks | 7 | 4000
Juices | 6. | 1000
Total. | 28. | 8000

Shisha Revenue Report

Group Name | Quantity | Amount

Apple group. | 5 | 1000
Mint group | 10 | 2000
Flavoured group | 7 | 4000
Total. | 22 | 7000

GRAND TOTAL. | 106 | 31,000

I will be so grateful if the community can help me out with this report
Thank you so much.

[Posflow]

This is for all categories

[Group Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True)}
>>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) }

@{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Sum.desc::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}

[$1 Sales:8, 2, 3]
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1)}
{REPORT ORDER DETAILS:'         '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1) and O.PortionName!="Normal"}
>>Total |{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) and (MG=$1)}

This one is for your specific ones @Food,Shisha,Bottles,Bar

[Group Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True) AND ( (MG=Food) OR (MG=Shisha) OR (MG=Bottles) OR (MG=Bar) )}
>>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) AND ( (MG=Food) OR (MG=Shisha) OR (MG=Bottles) OR (MG=Bar) ) }

@Food,Shisha,Bottles,Bar
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}

[$1 Sales:8, 2, 3]
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1)}
{REPORT ORDER DETAILS:'         '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1) and O.PortionName!="Normal"}
>>Total |{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) and (MG=$1)}

You can find how to build your own reports here

Custom Report Tags in detail

We can prepare any type of reports with SQL and display results as a Custom Report. Alternatively we can use Custom Report Tags to prepare reports. If you need more information about preparing a custom report you can review this tutorial. ###Introduction Basically there are four types of tags. DETAILS TAGS: These tags contains DETAILS keyword in it and allows us to prepare table reports. TOTAL TAGS: If a tag contains TOTAL keyword in it we can use this tag read sum of a value. COUNT TAGS C…

[Jesse]

Kb.sambapos.com has a comprehensive reports section.

[Eddie14jan]

Thank You Jesse and POSflow. i was able to go through ur codes and also read through the knowledge base. and i came up with this.

[FOOD REVENUE:2, 1, 2]
@Breakfast,Salads,Deserts,Sandwiches,Soup,Wraps
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Sum.asc,O.ExactTotal.Sum:(MG=$1)}
>>Total|{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) AND ( (MG=Breakfast) OR (MG=Salads) OR (MG=Deserts) OR (MG=Wraps) OR (MG=Sandwiches) OR (MG=Soup) ) }

[BAR REVENUE:2, 1, 2]
@Beverages,Drinks,Rum Btl
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Sum.asc,O.ExactTotal.Sum:(MG=$1)}
>>Total|{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) AND ( (MG=Beverages) OR (MG=Drinks) OR (MG=Rum Btl) ) }


>Grand Total|{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True)}

[Eddie14jan]