hi this is workperiod report so this sales column individual sales we can see like delivery with amount take away with amount so i am making this reports in excel but i am not able to find exact tag for this need help for tag of all this.
like i want to break down the report by separating this.
Try rewording your question, dont think its very clear what your asking.
Hi i made this tag for report and i have share the screen shot also of it.
but here i dont want the name of ticket type just amount of it.
example u can see ground floor in the screen shot.
so i dont want name ground floor just i want the amount of ground floor.
and here is the tag of it. can some one help to do this please.
[Sales:3,3]
{REPORT TICKET DETAILS:T.TicketType,T.TotalAmount.sum}
You would need to add column layout on end of expression something like;
TICKET DETAILS:T.TicketType,T.TotalAmount.sum::{1}
no its same after i give this tag.
the only thing i want is how much is total sale of delivery in numbers i dont want name just amount of delivery, ground floor, take away
How will you know what amounts relate to what?
Have a look on forum for expressions like that with the column numbers at end.
like example i finding tag something like this tags and it will just show me amount of particular ticket type sale amount.
{TICKET DETAILS:T.TicketType=Delivery,T.TotalAmount.sum::{1}}
{TICKET DETAILS:T.TicketType=Mezanine,T.TotalAmount.sum::{1}}
{TICKET DETAILS:T.TicketType=Ground Floor,T.TotalAmount.sum::{1}}
What jTR showed should work. Did you even try it?
This is all wrong… arnt you a reseller?
ya i know it was my idea to find some thing like that those tags are example something i am searching like this
{TICKET DETAILS:T.TicketType=Delivery,T.TotalAmount.sum::{1}}
{TICKET DETAILS:T.TicketType=Mezanine,T.TotalAmount.sum::{1}}
{TICKET DETAILS:T.TicketType=Ground Floor,T.TotalAmount.sum::{1}}You cant constrain like that. You put constraints in the first :: section
Because that’s wrong still.
Plus how is that a constraint, there is no =
Generally constraints use different expression that column headers.
Have you bothered looking at forum and how other reports are formatted…
Suggest you start by learning the basic fundamentals of custom reporting module.
i have try all this but did not work for me
If you had read that you wouldn’t have thought either of those attempts were correct.
I cant speil report expressions of top of my head and not near PC to load up samba so cant help much more for time being.
Suggest you go back and read up on reports.
Hi i got help from support now its ok i can see the sale individually.
but i want i wan to see the sale in one row like delivery, ground floor to be in one row.
i have share the tag and screen shot in the screen shot delivery column is blank. please need help for this.
[Item Sales by Department:3, 4, 3, 1, 2, 1]
>Date|Delivery Sale|Mezzanine Sale
{REPORT ORDER DETAILS:O.Date,O.Total.Sum:(TY=DELIVERY)}|{REPORT ORDER DETAILS:O.Total.Sum:(TY=Mezzanine)}
>Total|{REPORT ORDER DETAILS:O.Total.Sum:(TY=DELIVERY)}|{REPORT ORDER DETAILS:O.Total.Sum:(TY=Mezzanine)}
Is delivery block capitals? These will be case sensitive.
yes it is capital letters
