I am designing a report which i would like to have the following:
- Month sort
- Weekly Total Salary
so , for example Report would be similar to something like this:
EMPLOYEE NAME: "Jane Doe"
NAT INSURANCE #: 19019012190
MONTH : JANUARY 2012
week jan 1 - 12 :
TOTAL Salary: $499.99
week jan 14 - 21:
TOTAL Salary: $699.99
The issue is what "FIELDS" , SUMMARY calculation(s) do i need in order to get this?
i have from
EMP_TABLE [employee ID, Natinsurance # ,
TIME_TABLE [start week ,end week]
but for month , would i just create a MONTH( start_week) or create a new field or value list
then would i create subsummaries by month for the main heading and underneath that Subsummaries for the weeks?