I feel like a total novice in Alpha4 even though I have had it set up in my office for at least 6 years. I am using version 4 and am trying, to no avail, to set up a report which will give me the total hours for each service rep during a particular time period. This is a report which is really needed to track the production of the employees for the hours that they are being paid, but I cannot get the report to work and I am really getting frustrated.
I have two databases tied together in a set with the customer's phone number as the linking field. The parent field contains the servrep, hours, amount and of course, the customer phone number field. The only information that I need from the child database file is the customer's name.
My problem is that I assume that I need 1 group in order to have the various calls from each service rep grouped together. However, I get stumped everytime I try to figure out what is supposed to go into the footer section of the report. I assume that should be a total of the hours, but how in the world do I get that to total?
Am I making any sense here? If the Group 1 footer contained a field that would total, I think I could get that figured out, but since I am dealing with just one group - that of the service reps - I cannot figure out what to do with the Group 1 footer or for that matter, how to get the totals for 'hours' for each sales rep.
Am I just being stupid here - or just fighting a losing battle? The reports are supposed to be fairly easy, but I am getting nowhere. Please help. And by the way, I am using a range in order to make the report cover a specific period of time.
Thanks for any help that anyone can offer. I haven't done any real work on Alpha 4 since I first set it up and obviously, I have forgotten everything that I ever learned all those years ago!!
Nancye Fisher
I have two databases tied together in a set with the customer's phone number as the linking field. The parent field contains the servrep, hours, amount and of course, the customer phone number field. The only information that I need from the child database file is the customer's name.
My problem is that I assume that I need 1 group in order to have the various calls from each service rep grouped together. However, I get stumped everytime I try to figure out what is supposed to go into the footer section of the report. I assume that should be a total of the hours, but how in the world do I get that to total?
Am I making any sense here? If the Group 1 footer contained a field that would total, I think I could get that figured out, but since I am dealing with just one group - that of the service reps - I cannot figure out what to do with the Group 1 footer or for that matter, how to get the totals for 'hours' for each sales rep.
Am I just being stupid here - or just fighting a losing battle? The reports are supposed to be fairly easy, but I am getting nowhere. Please help. And by the way, I am using a range in order to make the report cover a specific period of time.
Thanks for any help that anyone can offer. I haven't done any real work on Alpha 4 since I first set it up and obviously, I have forgotten everything that I ever learned all those years ago!!
Nancye Fisher
Comment