4 Replies Latest reply on Jul 12, 2016 1:08 PM by theharrisonlee

    Please Help - Monthly Grid Report

    theharrisonlee

      I am trying to produce a monthly report showing  the numbers for each day, and the user can select the month they want to view the report as.

      And as i try to do it i realised that it is extremely complicated and all the information i found on the web are ridiculous complicated and hard to understand.

       

      Basically I have a daily form for users to record the contractors involved and number of workers for each contractor

      and also the type of machinery used each day and the number of each type

       

      Contractor Name:

      Number of Workers:

       

      Machine Type:

      Number of Machine:

       

       

      and the number of contractors and machines vary each day

       

      and i want to produce a report like this:

       

       

       

      -------------------------------------------------------------------------------------------                            

                                                 MONTH

                              1   2    3    4    5    6    7    8    9    10    11    12 ...........   31

      Con A

      Con B

      Con C

      Con D

                            =============================================

      Total                x    x    x    x    x    x    x    x    x     x      x  .....................

       

      Machine A     xx

      Machine B     xx

      Machine C     xx

       

      -------------------------------------------------------------------------------------------       

       

      Could someone please give me some guidelines in doing this report, i have completely no ideas what i need to research on and the methods required.

       

      Many thanks and greatly appreciated