# Pass Time Parameter to retrieve a report

**URL:** <https://forum.sambapos.com/t/pass-time-parameter-to-retrieve-a-report/9216>\
**Category:** V5 Question\
**Created:** [January 29, 2016, 3:48am UTC](https://forum.sambapos.com/t/pass-time-parameter-to-retrieve-a-report/9216 "2016-01-29T03:48:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\
**Post date:** [January 29, 2016, 3:48am UTC](https://forum.sambapos.com/t/pass-time-parameter-to-retrieve-a-report/9216/1 "2016-01-29T03:48:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [January 29, 2016, 2:32pm UTC](https://forum.sambapos.com/t/pass-time-parameter-to-retrieve-a-report/9216/2 "2016-01-29T14:32:13Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [January 29, 2016, 3:15pm UTC](https://forum.sambapos.com/t/pass-time-parameter-to-retrieve-a-report/9216/3 "2016-01-29T15:15:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [January 29, 2016, 3:21pm UTC](https://forum.sambapos.com/t/pass-time-parameter-to-retrieve-a-report/9216/4 "2016-01-29T15:21:52Z")

</div>

This is a starting place.

> [@Sales Per Hour Report](http://forum.sambapos.com/t/sales-per-hour-report/5443/19):
>
> 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'),O.Id.Count,O.Total.Sum,O.Total.Percent}