Sales by the hour without headquarters

Try adding the following fields to your sales report (you an edit the .QRP file and paste this at the end of the columns section):

Begin Column FieldName = "TransactionHour" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Hour Sold" VBDataType = vbString Formula = "replace(str(datepart(hour, [transaction].time),2,0),' ','0') + ':00-' + replace(str(datepart(hour, [transaction].time),2,0),' ','0') + ':59'" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1605 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "DayofWeek" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Day of the Week" VBDataType = vbString Formula = "STR(DATEPART(dw, [transaction].time),2,0) + ' - ' + CASE DATEPART(dw, [transaction].time) WHEN 1 then 'Sunday' WHEN 2 then 'Monday' when 3 then 'Tuesday' when 4 then 'Wednesday' when 5 then 'Thursday' when 6 then 'Friday' when 7 then 'Saturday' END " ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1605 GroupMethod = groupmethodNone ColFormat = "" End Column

You will then be able to sort and group your report by these fields.

Have you looked at the graphs function in POS (Shift-F6)?

Glenn Adams Tiber Creek C> I am trying to analyze my sales by the hour for each day of the week for a

First of all, thank for responding.

I am a bit of a novice at this, and so I do not know how to access the .qrp files.

Can you tell me how to navigate to them>

Thanks,

WEll, I have navigated to the files now. I found them in the c drive, program folders, RMS, Reports, if anyone else had the same problem.