Page 1 of 1

New REPORT Request (or extend existing HOURLY READING report)

Posted: Tue Dec 17, 2024 9:38 am
by brucef2112
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.

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
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.

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
---------------------------------------
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:

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
---------------------------------------
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:

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

and for a MONTHLY choice of #Sales or Dollars:.

Code: Select all

      Time	       JAN  FEB  MAR  APR   MAY  JUN   JUL   AUG   SEP   OCT   NOV   DEC  Total ($)
        ...           ...   ...	 ...  ...   ...	 ...   ...   ...   ...   ...   ...   ...  .....
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,