Hourly Report

Oct 25, 2007 5 Replies

I am looking hourly report for RMS. We can see a graph from Register but can not print out. Is there any way we can see from back office - Hourly Report?



Chirag Thakkar NetLink Consulting



732 548-6300

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

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required