I have projects with 3 milestones, call them A, B, C
C is dependent on B which is dependent on A.
C is a critical completion date.
If either A or B is late, C is automatically late and that is very bad.
If A or B is late by X number of days, C automatically is now going to be late by that same number of days.
I'm looking to design a report or alert that says -
A has not been completed. It should have been completed X days ago, the new completion date for C will now be Y. (same thing for milestone 
Any thoughts on where to begin?