That Report is calling 3 SQL Scripts.
@@EmployeePunchInLatest
@@EmployeeHoursDaily
@@EmployeeHoursTTL
The SQL scripts are in Automation > Scripts …
I just copied and pasted the code exactly the way you published them. I did not edit them in any way. Was I supposed to tailor them?
No you don’t need to change the SQL Scripts at all.
It might be because you have no Entity State Logs yet. Need to wait to find out what @emre says regarding your other issue.
They look fine.
P.S. you can post images directly in the Forum instead of linking them remotely.
When I upload screenshots, I use imgur because, right after I press the PrtScn button, I can just press Ctrl+V right onto imgur’s site. There’s no need to open up a new image file on your desktop or anything.
Btw, the file is NOT uploading properly. Once the upload percentage hits ~50-60%, it resets back to 0%.
You can do the same thing in the text-edit window here, and it will upload the image file.
Prt Scr, then Ctrl-V right here…
Which Browser are you using?
That’s cool. I’ll do that next time.[quote=“QMcKay, post:50, topic:7149”]
Which Browser are you using?
[/quote]
I’m using Firefox on my personal computer. I also tried uploading it from the POS’s server computer, which uses Chrome.
I had to switch to using Chrome here when the forum software (Discourse) broke the file upload (Ctrl-V) in Firefox.
It was supposed to have been fixed, but it may have been broken again.
I swallowed my fanboyism and just used the latest Explorer (IE 11) and it still didn’t work.
@rightguys thank you for backup. It saves settings just fine. Are you disabling design mode after changing settings? It saves when you disable it.
1 Like
First, I’d like to say, nice monitor resolution. Second, I don’t know if I am disabling disabling design mode. I’ll try that.
He just means this:
- Right-click and select
Design Mode. A check will appear to the left of Design Mode. - Click your Widget, then Right-click and select
Settings. - Make your changes, and click
Okat the bottom-right of the Settings Editor. - Right-click and select
Design Mode. The check will disappear.
The last step “disables” or “exits” Design Mode and saves your changes that you have made.
Thank you so much guys. I now see the message. Only one problem, though. My clock-in report still shows an error message.
[Current Hours Daniel B.:13,12, 12, 12, 20, 16, 7]
@@EmployeePunchInLatest:Employee,Daniel B.
[Previous Hours Daniel B.:13,12, 12, 12, 20, 16, 7]
>Date|Day|Start|End|Hours|OT|H
@@EmployeeHoursDaily:Employee,Daniel B.
>@@EmployeeHoursTTL:Employee,Daniel B.Find the error log and post it’s contents here in the forum. It is located at:
[Documents]\SambaPOS5\log.txt
It’s not like Sambapos crashes or anything. The report itself gives an error message:
ExecuteReader: CommandText property has not been initialized.
The same error should be in the log file.
Basically, it means the SQL is not executing properly for some reason. Probably has something to do with the way the parameters are being passed.
This is how it works.
Where you see in the SQL Script:
{Start} : replaced with Workperiod Start date/time
{End} : replaced with Workperiod End date/time
@1 : replaced with first parameter from Report, which is Employee
@2 : replaced with second parameter from Report, which is Daniel B.
So I can only guess, but what I would try at the very least, one at a time until it works:
- Ensure your Entity Type is called
Employee.
- Ensure you have started a Workperiod at least once. If you have no Workperiods, the report will fail. You do not need to be within a Workperiod to see the report, but at least 1 Workperiod must have existed in the past.
Try replacing in the SQL Script (the single quotes are mandatory):
'@1' with 'Employee'
'@2' with 'Daniel B.'
There have been many Work Periods in the past.
The Entity Type is correctly spelt.
Tried this; didn’t work.
Didn’t try this. How should I format the date/time?