Thanks Derek, That was Helpful

Hello there,
I was trying to build a database for some operation and I wanted to sort or group my report data in terms of the Group header I specified instead of the data entry sequence in the "Lost sales form" but I was unable to do so as in the attached sample. In whatever sequence I enter the data, my desire is to group and sort them based on the "Machine. Name" category specified on the Group Header. I need someone to help me out. Thanks in advance.

Biruk

3

(4 replies, posted in Reports)

Hello,

Many thanks for your assistance Derek. I've got valuable tips and tricks from you on MVD. I have refined my report based on your previous suggestions but I still can't get the correct total STD time value and I don't know why. If anyone is out there who has better experience with Fastreport, please help me out on this.

4

(4 replies, posted in Reports)

Thanks, a lot Derek, That was a very helpful suggestion you provided and I managed to group the Jobs_done_detail based on Job_No as shown in the file attached. But here also I need help, to sum up the STD_Times that I found from each group on my report to finalize the report summary section highlighted in RED. Knowing the sum will help me evaluate the rest of the quantities like the average efficiency and others. Thanks in advance.

5

(4 replies, posted in Reports)

Hello guys,

I work in the automotive industry and was trying to make a database to record and report the daily job performance of technicians and I came across a problem. I prepared the database without any coding knowledge so I need your help with this problem. the database is used to record the daily working activities of technicians with standardized operations each having its own standard time to perform. It was working perfectly when I suddenly found a problem with the exaggerated efficiency calculation on the report. Those came from standard times that are greater than 8hrs which could not be finished in a day. But my database's actual time can only calculate the actual time for 1 day only based on the inputs. I was trying to find a way to add the actual working time of technicians for each day which has the same Job numbers and operation codes and need your assistance on this. I've attached the google drive link to my database and thanks a lot.

shorturl.at/ijC48