New REPORT Request (or extend existing HOURLY READING report)
Posted: Tue Dec 17, 2024 9:38 am
Hi Dale,
In short: sales reports C. Hourly readings needs the DATE added to each line of data when choosing to export as DATA.
When Creating a hourly sales report for this register the user can choose a single date and then choose a time interval. The printed report is great and can be very useful for humans to view.
However when choosing the option to "export as data". The data is formatted just like the printed report, which isn't really conducive to a "DATA" format. The issue is that the DATE isn't included on each line of the interval. As it is now, this makes is difficult to import into a spreadsheet. The delimited data needs to manually take the date from the bottom of the report and adding it to each row of the time interval. If you are trying to create this report for say a week's or a month's report, it is manually time consuming.
The "export to data" version should have the DATE included on each line of the time interval data. like this.
A data layout which includes the 'DATE' makes it much easier to actually import into a spreadsheet and cleanup to generate more useful reports.
With the date added, HOW ABOUT FOR A SERIES OF DAYS.
This format of 'DATA' would also allow expanded feature to be added to the report.
The "Hourly readings report" could now also include a RANGE of Dates to report on. (Prompt user for 2 dates)
Example Data report:
This also allow an opportunity for extended report layout for printing and Data
for a weekly sales tracking, for monthly, yearly.
Example WEEKLY Report choice by #Sales or $$Dollars:
and for a MONTHLY choice of #Sales or Dollars:.
If these reports are too much to add to POS at this time, then in the least the 'Data Export" should include the DATE on each line.
With this, the user on their own could create the WEEKLY, MONTHLY, YEARLY reports in EXCEL while maintaining a current level of sanity.
As always, Dale, Thank you,
In short: sales reports C. Hourly readings needs the DATE added to each line of data when choosing to export as DATA.
When Creating a hourly sales report for this register the user can choose a single date and then choose a time interval. The printed report is great and can be very useful for humans to view.
Code: Select all
---------------------------------------
TIME SALES TRANS SALES/TRANS
12:00 241.18 6 40.20
13:00 45.28 3 15.09
15:00 2.99 1 2.99
18:00 147.00 1 147.00
TOTAL 436.45 11 39.68
---------------------------------------
10-01-2011
The "export to data" version should have the DATE included on each line of the time interval data. like this.
Code: Select all
---------------------------------------
DATE TIME SALES TRANS SALES/TRANS
10-01-2011 12:00 241.18 6 40.20
10-01-2011 13:00 45.28 3 15.09
10-01-2011 15:00 2.99 1 2.99
10-01-2011 18:00 147.00 1 147.00
10-01-2011 TOTAL 436.45 11 39.68
---------------------------------------
With the date added, HOW ABOUT FOR A SERIES OF DAYS.
This format of 'DATA' would also allow expanded feature to be added to the report.
The "Hourly readings report" could now also include a RANGE of Dates to report on. (Prompt user for 2 dates)
Example Data report:
Code: Select all
---------------------------------------
DATE TIME SALES TRANS SALES/TRANS
10-01-2011 12:00 241.18 6 40.20
10-01-2011 13:00 45.28 3 15.09
10-01-2011 15:00 2.99 1 2.99
10-01-2011 18:00 147.00 1 147.00
10-02-2011 12:00 41.18 5 8.24
10-02-2011 13:00 15.28 2 15.09
10-02-2011 15:00 52.99 1 52.99
10-02-2011 18:00 47.00 1 47.00
---------------------------------------
for a weekly sales tracking, for monthly, yearly.
Example WEEKLY Report choice by #Sales or $$Dollars:
Code: Select all
Time Monday Tuesday WednesdayThursdayFriday SaturdaySunday Total ($)
7:00 AM 8:00 AM $XXX $XXX $XXX $XXX $XXX $XXX $XXX $XXX
8:00 AM 9:00 AM $XXX $XXX $XXX $XXX $XXX $XXX $XXX $XXX
9:00 AM 10:00 AM $XXX $XXX $XXX $XXX $XXX $XXX $XXX $XXX
... ... ... ... ... ... ... ... ... ...
9:00 PM 10:00 PM $XXX $XXX $XXX $XXX $XXX $XXX $XXX $XXX
Code: Select all
Time JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Total ($)
... ... ... ... ... ... ... ... ... ... ... ... ... .....
With this, the user on their own could create the WEEKLY, MONTHLY, YEARLY reports in EXCEL while maintaining a current level of sanity.
As always, Dale, Thank you,