report

[quick27]

I have struggled with writing a script to make a report and thought maybe someone could give me some direction.
Ive attached a file that is output from a DataBase query. Columns are workgroup, userid, functionid, functionname, function start time, and function complete time. I need to make three report from this output. The first by workgroup that would look similar to the following:
Work Group Hr Function Name Qty Avr. per hour
---------- -- ------------- --- --------------
10 00 function1 44 44

Second Report would look as follows:
Work Group USER ID Hr Function Name Qty Avr. per hour
---------- ------- -- ------------- --- --------------
10 user1 00 function1 44 44
01 function2 6 6

This report would look as follows:
10 user1 00 function1 44 44
10 user1 01 function2 6 6

So i would need to add the quantity of each function that user does by hour. I hope this makes sense. I would include my code but it would be pointless because i havent even had anything that came close to what i wanted to do.

thanks for any help

 

[KevinADC]

Including your code would be helpful because it gives the people that are helping an idea of how much perl you know and understand and it demonstrates that you put in some effort before posting your question. Is this school/class/course work?

------------------------------------------
- Kevin, perl coder unexceptional!