Will you be reporting the JTD labor, but just for the jobs that had payroll in the most recent week? Unless you are using the Weekly accumulator option in your job setup, you will need to produce this report from the Job Cost Transaction file rather than the Job Cost Master file.  

Since you will need to use the Current.JCT file as your driving record, you need to create a formula that determines if there are labor costs within the reporting period on a job by job basis.  

Use the ASUM function to total labor costs by job, using a conditional formula based on the relevant period end dates and the parameters that define your definition of labor costs (cost type, category, etc). You can reference the period end dates by creating two "Prompt" fields for period end date from and to, and reference those prompt fields in the conditional part of the ASUM function you create.

Then apply a Conditional Print area to both the detail area of the report and the job number and description heading, so that your printing is suppressed unless the ASUM function returns something other than 0.00 for total labor costs for the respective job.

Hope this is helpful.

Thanks so much for your response - I have done what you suggested and it works (kinda).  It prints a blank page for the jobs that don't have labor costs for that current period.  Is there a way to eliminate the blank pages?  I have put many hours in this - this is the closest I've been to getting it running the way I need.  Thanks again so much for your help :)

Teresa, if you're printing one job per page, be sure to apply the conditional print area to everything that prints on the page. Also, be sure to check the box "Suppress Blank Lines if False" on the screen where you select the formula for the print condition.

Thank you SO VERY MUCH!!  This has almost driven me crazy!!!

Thank you SO VERY MUCH!!  This has almost driven me crazy!!!