3 Replies Latest reply on May 1, 2012 4:26 AM by digital-carpentry

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

    ian.moree

      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

        • 1. Re: designing a report, but don't know what i need
          digital-carpentry

          So where is the data stored? is there a third table with the salary?

           

          Assuming that is the case, the report would be based in the salary table, simply calculate the month based on the date for each record.

          Calculate the Week (Honestly I would just use WeekofYear for this and do away with the Time_Table unless it's needed for something else, you can calculate start and end dates for display purposes)

          Then do a  report with 3 subsummaries, Employee, Month, Week and sort in that order.

          Then one Summary Field to calculate the Total.

          • 2. Re: designing a report, but don't know what i need
            ian.moree

            No third table

            1 table - Employee

            1 table - TIme Entry for employee

            Which all the data is entered & calculated!

            So you are saying:

             

            Add a Salary table, but would i create a calculation for calculating the week using WeekOfYear Function?

             

            i need the time table for time in and time out, vacation time, hours worked,etc though.

             

            so summarize by EMPID, Month( in salary table), week ( in time table)

             

            -i

            • 3. Re: designing a report, but don't know what i need
              digital-carpentry

              Ok you listed your time table before as "month" which didn't make sense to me.  Those 2 should be fine, just calculate the month and week for each time record, and use those to pull your sub summaries for your report.

               

              Thanks,

              Bill Pelfrey

              Digital Carpentry LLC

              www.digital-carpentry.com

               

              "Let us build a foundation for your business."