in v5 is it possible to pass parameter for time (from and to) inorder to retrieve report for hourly bases. Meaning my client want item sale report from a specific time like item sale during peak period or happy hour or hourly basis. can this be done in v5 ? thanks

There isnt a Order time expression in the report tag in detail topic but thats getting old now so not sure if its been added since then. Order table has a date column so should be fairly easily doable with sql.

Yes its possible and it could be done with input using Report Widget, Editor Widget and a custom Entity Screen.

This is a starting place. [image] Sales Per Hour Report V5 Tutorial For next version I’ve added Format Time (FT) function support to V5 reports so you can create something like that. [ORDERS:1, 1, 1,1] >Time|Order Count|Total|Percent {REPORT ORDER DETAILS:FT([O.Time],'hh…

Pass Time Parameter to retrieve a report

V5 Question

Jesse January 29, 2016, 3:21pm 4

This is a starting place.