You would do something like;
@{report tag giving list of ticket ids}
{report ticket details:id,user etc:(Ticket id=$1)}
{report order details:prod,price etc:(ticket id=$1)}
The $1 make line 2 and 3 loop per value in the @ report results.
These are obviously not the actual report expressions, fields and constraints but demo how you would do that layout.
I tried this report bellow i get all tickets with all details only thing it lack and its important is how to get to integrate {REPORT ORDER DETAILS:O.MenuItemName} inside the the main report on each Ticket line
@JTRTech , I tried to change date begin and date end (as u told me in ur last post) and when i hit refresh it doesn’t change report data and date begin goes to first ticket date , i think i nee to change code in my report ?!
Have you been closing and opening work periods?
Reports will only show whole work periods…
If you dont close each day and say have a work period open for several days the dates will be automatically expanded to include this, or visa versa if you have multiple work periods per day which is also not reconmended the reports will report all the periods within the days set to be reported.
There is but that is not what you asked. You can also create a custom entity screen and use the custom report widget and automation to set date filters for the report.
You can report by date fields, it will report over multiple work periods. but you need to do work period PER DAY!!!
If you have not closed your work period you will just get the current work period for ALL TIME.
You havent said if this is the case or not though… have you been closing work period each night?
If you dont open and close work periods then your reports will not be accurate. The reason for work periods is for report periods and accurate stock adjustments.