See the following menu page: <[login to view URL]>
On that page are links to pages for the following 5 reports in the section: Monthly Reporting Tools. These pages are only to show the filter and field selections for these reports. All reports are to be written in MS Access (97, 2000 or 2003). See notes under each report (below) for additional info.
Access database file is attached.
These reports are to run from the form: zPrintDialog_PAS using the buttons provided.
Reports 2 thru 5 should filter by using the existing Start and End Date fields on the form.
See the <Worker Follow-up> button for code examples: cmdWorkerFollowUp_Click()
Most of the fields come from the table: tblJobOrders.
How do you think we should handle getting the data Report 5, which requires logon data that will be extracted directly from the server?
## Deliverables
Monthly Reporting Tools
1. YTD Result Report: <[login to view URL]>
tblJobOrders
Counts by Month
2. List of consumers served by time period: <[login to view URL]>
tblJobOrders
Start & End Date range
3. Count of consumers served by age and disability <[login to view URL]>
tblJobOrders
Start & End Date range
4. Satisfaction Survey Results <[login to view URL]>
Join tblJobOrders with tblJobOrdersSatisfaction on JobID
Start & End Date range
5. QM user tracking Report <[login to view URL]>
from <[login to view URL]> joined with tblJobOrders on ContactEmail
Start and End Date range
## Platform
ASP, ASP.net and Access