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
Job Number 2
Job Number 3
Job Number 4
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.
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.