ian.moree

designing a report, but don't know what i need

Discussion created by ian.moree on Apr 30, 2012
Latest reply on May 1, 2012 by digital-carpentry

Hello Everyone;

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?

 

thanks,

 

-ian

Outcomes