1 Reply Latest reply on Oct 11, 2012 3:43 PM by timwhisenant

    Report Layout

    Jason_Farnsworth

      What is the proper way to set up this report

       

      Person Relating to Tasks / Begining Date - End Date (Date range to look at)

       

      Job Number 1

      1. Work Task1
      2. Work Task2
      3. Work Task3

      Job Number 2

      1. Work Task1
      2. Work Task2
      3. Work Task3
      4. Work Task4

      Job Number 3

      1. Work Task1
      2. Work Task2
      3. Work Task3
      4. Work Task4

      Job Number 4

      1. Work Task1
      2. Work Task2

       

      Normal footer info

       

      My job number is in a Jobs Table, my Work Task & Employee are in a WIP table

       

      The report that I am trying to get will show all active jobs and directly under each Job it will show all tasks completed by that person for that job and between the date range selected.

       

      Would the Correct format be.

       

      Header = Normal header stuff ie. report name

      Sub-Summary Leading = Job Number

      Body = Work Tasks

      Footer Normal footer details ie. Page numbers

       

      If correct would my layout be based in the Jobs table

      The Sub Summary Sorted by Job number

      Body the individual work tasks

       

       

      Any help would be great I can not seem to a clear picture in my mind about this.

       

      Jason Farnsworth

      Midland, Tx

        • 1. Re: Report Layout
          timwhisenant

          Jason,

           

          You are correct with the exception that the report should be based on the WIP table not the jobs table. Get your job information through the relationship WIP -> Jobs.

           

          Sort by WIP::JobNumber and draw your subsummary by WIP::JobNumber, but display the Job table fields if you need Job Name, Location, etc.

           

           

           

          HTH,

           

          Tim