Exception Reporting

Exception Reporting is a concept in Projector used to track when things are exceptions to a rule. The idea is create a report, run it on a schedule, and only get notified about that report if a rule is broken. For example, my exception report might implement the rule - "Contractors in India cannot submit time to G&A projects. If this should happen, please email me a report of who submitted the time, the project, and the expense details."

To model this I use four parts of the report wizard.

1. Data/Row Fields
   
   1. Resource Display Name
   2. Expense Type
   3. Incurred Date
   4. Total Amount Disbursed Currency
2. Filters
   
   1. Resource Type = Contractor
   2. Engagement Type = G&A
   3. Resource Location = India
3. Scheduling
   
   1. Runs nightly at 2am and notifies me on success
4. Distribution
   1. Distributes to me

If nobody breaks my rule, then the report returns no data and no email is sent out. However, if someone does break the rule, the report does have data and it gets sent to me.