Hello, We need a report that can distiguish between days of the week....specifically we are in need of a report that show Saturday and Sunday sales for the last two years... Please email at snipped-for-privacy@zcollectionsf.com if you can help... Thank you, Diana
Add this Weekday column to your report, and then you can add filter: Weekday=Saturday or Weekday=Sunday.
Begin Column FieldName = "Weekday" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Weekday" VBDataType = vbString Formula = "case datepart(w,[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 = 2115 GroupMethod = groupmethodNone ColFormat = "" End Column
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.