Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    1

    Exclamation Unanswered: I need help with this kind of report mySQL

    hi guys.. i really tried many things to solve this problem.. but i really cant figure this out..

    i have 2 tables actually its 3 tables but the other is just for the user's account so here it is:

    employee table
    ins_ID -> pk
    emp_ID* -> unique key
    last_Name*
    first_Name*
    middle_Name*
    position
    pos_Stat* this is enum which can be RnF or M
    branch

    sample:
    ins_ID emp_ID last_Name first_Name middle_Name position
    1 727 lname fname mname tester
    2 826 lName fName mName tester
    3 999 name nam na manager

    pos_Stat branch
    RnF loc1
    RnF loc1
    M loc1

    RnF is for Rank and File and M for Managers

    payment table
    payment_ID -> pk
    emp_ID*
    date*
    amount*

    sample:
    payment_ID emp_ID date amount
    1 727 2007-05-26 10.00
    2 727 2007-05-27 50.00
    3 727 2007-05-28 60.00
    5 826 2007-05-26 30.00
    6 826 2007-05-27 90.00
    8 826 2007-05-29 50.00
    9 999 2007-05-26 50.00
    10 999 2007-05-27 50.00
    11 999 2007-05-28 50.00
    12 999 2007-05-29 50.00


    i've placed * on the important data's needed in the creation of the report.

    now here's the sample report i needed to display after choosing the from and to date..

    for example the user chose May 26, 2007 to May 29,2007
    it should look like:

    i didn't include the first name, last name, middle name its just an example anyways. But if needed it is located just after Emp No.
    im using php with html tables here. Any suggestions, comments,
    will gladly be appreciated ^^


    Emp No. May26 May27 May28 May29 Total
    727 10.00 50.00 60.00 00.00 120.00
    826 30.00 90.00 00.00 50.00 170.00
    999 50.00 50.00 50.00 50.00 200.00

    Total - RnF 40.00 140.00 60.00 50.00 290.00
    Total - M 50.00 50.00 50.00 50.00 200.00
    Grand Total 90.00 190.00 110.00 100.00 520.00

    up there is what i cant get.. please help anyone!! thanks..
    mine has tons of mysql queries.. im so tired of it T_T

    the report feature is the most important part of my system T_T
    Last edited by TrojanFrost; 05-08-07 at 13:08.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    are you using any reporting software or any other software? you would be best to do what you are looking for in one of those.

  3. #3
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Any chance of a MySQLDump of your data?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •