I need to summarize at the page footer of m report how many changes are one week overdue, two weeks over due, three weeks overduew and so on.
plannned start planned-end weeks overdue
11/28/11 12/05/11 1
11/29/11 12/06/11 1
11/21/11 11/25/11 2
10/30/2011 11/05/2011 5
So if I have 5 changes that are 3 weeks overdues, 2 changes that are 2 weeks overdue, and 3 changes that are 1 week over due, I need to display the data as follow:
2- weeks 2
this needs to be calculated based on the end-date of the report from the current running date.
I tried using charts, but I am having a hard time changing the end date to display week1 week2 weeks.