AnsweredAssumed Answered

Please Help - Monthly Grid Report

Question asked by theharrisonlee on Jul 11, 2016
Latest reply on Jul 12, 2016 by 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

Outcomes