Search results for query: *

Hi Pete, thank you again for your help and the information you have provided - I have saved all this information and hopefully I will revert to this page, also hopefully helped out someone else as well :) Regards Philippe

Thank you Pete perfect all weel very well now, I had no idea it was going to be this involved. In regards to your writing and trying to pick out things I don't understand can I ask the first question or point me in the direction about "WhilePrintingRecords;" I have not used this of as yet and...

With the below image for example Tuart only has one person and nothing in the report footer Fantastic, I will wait for your last bit of help so we can have one conversation going :) "To answer your 2nd question first, absolutely. I learned a great deal from this forum in the early days of my...

One last question with the below code "Else A := ' is on time'" does not seem to be working as its coming up blank? Then If {#Acacia} = 2 Then If {@Time Vs APP} <= -1 Then A := 'is running a little behind ' Else...

Hi Pete yes completely agree with timing much easier for me ;). I have moved @timing to the details section and is working perfectly, thank you! My theory is if only one person was queued there are on time so with the below image "banksia" when only one is queued basically is also on time, so...

Hi Pete, again thank you for your help. I have attached the report with the changes you have made and the results are great that is the the separation of the results in the group footer. With the results, I was hoping for when Acacia for example has 2 queued it could also say "is on time" If...

Hi Pete, I really appreciate the work undertaken, I have had to take leave and won't be back until Monday, please bear with me then and can carry on the conversation if this suits you (I am not at work not and had to travel). I do want to add to this conversation with some extra questions on...

Hi Pete, I have added the report with the new formulas and apologies for not following your guide properly it's all me. This is exactly what I was after, thank you With the attached report I have deleted other information not needed as I was experimenting as I went. I need to look and add to...

Hi Peter thank you for the information With your first question not answered. 1. With the running totals I want to look at the second ID for each location so with this screenshot acacia is on-time banksia is on-time jarrah is on time - I only want to evaluate the second running total - is...

Hi Pete, I have added the report with saved data We have 4 locations and trying to see when locations for customers are running on time or running late. My idea was to look at the second ID so I have a running total for each location which is my first problem. I was using the report footer...

Hi Pete thank you for the reply back, I really appreciate it. The formula includes "... {@Time Vs APP} <= -9 and {@Time Vs APP} <= -29 ..." which doesn't make sense. If the formula result is less than -29, it will also always be less than -9. If you are trying to test for results between -9 and...

Hi, I am trying to show four locations running late or on time. in detail, I am evaluating the time if ({Location} = '1' and {#RTotal0} = 2 and {@Time Vs APP} <= -9 and {@Time Vs APP} <= -29) then 'Running a little behind ' else if ({Location} = '1' and {#RTotal0} = 2 and {@Time Vs APP} <=...

Hi trying to work out how to compare two number values but I want to highlight the difference of of 5 less and greater than ? if{table1} <>5 {table1}} then '1' else '0' thanks