Currently, I’ve hooked up 2 tills to a sql database, and the message server hooked up and it’s all working. What currently happens is that no matter which till you are on, when you view the work period report, it shows the grand total of everything that both tills have done. I’ve managed to follow…

[image] QMcKay: This is the Report: [#Punch Editor:1,1, 1,48,48, 1] >Date|Day|Hours|START|END|ID @@EmployeeHoursDailyPE:$1,$2,$3,$4,$5 Feels like I am watching an artist when I seem your work Q! You have ID NO. 274 highlighted in your image above (partly obscured). How have you done that…

[#Punch Editor:1,1, 1,48,48, 1] ^ the # symbol turns the Report into a result grid, so we can select individual lines When we have a #Report, we can select an individual Row and then access individual Cells within that Row using the Setting Mappings in the Custom Report Viewer Widget Settings. […

So we could call an Update Action for an Individual Line or Cell i.e. Toggle On or Off a value? (Can’t tell you guys how excited I am getting here with these tools! Like "#" - did not pick that up from my reading)

I know it must be getting late for your so sorry for being a pest. I understand almost all of this stuff but little confused with this picture and syntax: [image] [image] QMcKay: @@EmployeeEarningsSummary1530:$1,$2,$3,$4,$5 >@@EmployeeEarningsSummaryTTL:$1,$2,$3,$4,$5 So it seems you hav…

[image] pauln: “#” - did not pick that up from my reading Way back when Custom Reports first came to be, Emre mentioned it, but it gets passed over because it isn’t often used. It wasn’t until we started to hash out the idea of the Punch Editor that Emre reminded me. I was building this cra…

Yes I do not want to edit the data as displayed in the Report BUT I wish to update the source data coming from an Entity and then refresh the Report Grid? For instance maybe the Report used a EXPRESSION:x=y and through an Update we change “Y” so therefore when we refresh the report that Grid Line i…

[image] pauln: I do not want to edit the data as displayed in the Report BUT I wish to update the source data and refresh the Report Grid? That is exactly what the Punch Editor does. It passes data into {SETTING:x} variables, then Automation executes SQL UPDATE Statements directly to the DB …

[image] pauln: How is the 2 lines after the “@@” evaluated to get the output in the image, like how does it know to place which “$parms” and the Data syntax changes? :confused: Ah @QMcKay it is passing 5 variables to a @@SQL script - :relieved:? The script is only returning 2 values? My t…

Sorry, I was composing this reply and lost internet access for the rest of the day/night. [image] pauln: So it seems you have listed 5 parameters as you have shown above (fantastic) but there are only 2 colums defined in the template [Earnings Summary $2:6, 4]. How is the 2 lines after the “@@…

OMG! - Leonardo da Vinci! [image] Yes that sneaky Rule - thanks for taking the time, I am sure many posters will enjoy that schematic :smile: Leonardo was an Engineer… :grin: ( @QMcKay - hope no offense taken, just having a little fun)

SambaClub Forum

Individual Work Period Report Per Till

V5 Question

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled