Hourly Sales Report Issue

ishyampandey@live.com

Hi Everyone,

i'm Developing Hour wise sales sales report in which i have to show sales on hour basis.

for this, i took Integer as a data item for iteration IF Number IN [1..24]

to make as a hour like 00:00 -00:59 to 23:00 to 23:59.But i'm stuck and fail to how to get time interval and how to apply time as a filter.



>>i'm taking integer as data time

>>start time and end time will come from Statistic time setup table

>>and calculation will come from trans header.



Please help me.Thanks

joshuasung

I would suggest you to use VARIANT2TIME.
you put integer and format it to make it XXXT, then covert that to time to compare

joshuasung

I would suggest you to use VARIANT2TIME.
you put integer and format it to make it XXXT, then covert that to time to compare

ishyampandey@live.com

Thanks Josh sir,

I resolve this issue by taking Time statistic management as a data item.and by table relation with trans. header report work properly.