Hourly Report

You can see the hourly report, or the graph of Report? For first case, it's easy... you can add a column with the date/hours of sales and adding a group on the new column..

cod

Cod,

Thanks for the reply, I am not seeing a Graph of Report in manager. Please tell me where i can see. Thanks

"cod" wrote:

You can replace the [Transaction].Time column in the report with the statement CAST(CAST(CAST([Time] as FLOAT) AS INT) AS DATETIME) as Date_Day

and create a new column with this field DATEPART(hh, [Time]) as Hour

cod

There is a great hourly report on JeanHolland.com