AnsweredAssumed Answered

Report Layout

Question asked by Jason_Farnsworth on Oct 11, 2012
Latest reply on Oct 11, 2012 by timwhisenant

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

Outcomes