Its automatically shown
please see me screenshot and Report template.
Here is my report template.
[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)}
[Group Sales by Quantity:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Percent.desc,O.Quantity.Sum:(ODI=True)}
>Total||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True)}
[Sales:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1"}
{REPORT ORDER DETAILS:' '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}
Someone else asked that recently and I gave them the answer I can’t remember who it was.
Ok I found it. In your report Try this:
[Sales:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:O.MenuItemName,=[O.Quantity.Sum.desc],O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1"}
{REPORT ORDER DETAILS:' '+[O.PortionName],=[O.Quantity.Sum.desc],O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}
This was the post I was referring too.
Thanks for reply. I have tried your script to generate report that i want but can’t get solution as shown in pictures.
Show what you tried.
I have tried your this post
and got this result
I mean show a screenshot of your report so I can see if you made a typo. I can read my own post you don’t have to link it.
sir i am ordering 0.75 Chicken
order is added priceand quantity showing perfect
after completed order when i check it in report it show rounded quantity as shown in screenshot
while i am using the report code from your post
[Sales:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
{REPORT ORDER DETAILS:O.MenuItemName,=[O.Quantity.Sum.desc],O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$1”}
{REPORT ORDER DETAILS:’ '+[O.PortionName],=[O.Quantity.Sum.desc],O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$1”:2}
please help
What version of v5 are you using?
SambaPOS 5.2.22
Im sure I remember the solution to the person before needed the QTY field to be told the format like ‘#.###’ or something like that to stop the system rounding to whole number.
then how to stop system rounding. please guide me solution step by step i will be very thankfull to you
What I showed works it’s probably another nested tag messing with it. I’ll look at it over the weekend.
I am waiting your kind help
Try this
[Sales:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:O.MenuItemName,=[O.Quantity.Sum.desc],O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1"}
{REPORT ORDER DETAILS:O.PortionName,=[O.Quantity.Sum.desc],O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}
Actyually when I try the original report that I posted it works fine on my system. I think you need to change decimal places in the system. It may be your regional settings messing it up.
Here is how it looks on my system
Notice yours is not showing any decimals for prices either so you probably have a regional setting interfering. Look at hamburger on my report.