Create a Sage 50 Intellegnce Report similar to the Job Work in Progress report

Create a Job Work in Progress report in Sage 50 Intellegence Reporting that can be updated by period, sorted by Active/Inactive status. I generate the canned job report into excel every month and then modify it. I want an Intellegence Report that will eliminate me having to do this manually every month. Should be a pretty simple report.

Would like to get an estimate on cost of the job.
I can email the end result Excel report if needed.