Hi
i have master table called "pending_List" .
ID Pending Name
1 Reason1
2 Reason2
3 Reason3
in Page i will select the any of the data from pending_list and i ll save it my histoty table
now my requirment is wants to show the past 9 days pendinglist count in Report. see the below sample.
-----------------------------------------------------
Pending Name 25/06 24/06 23/06 22/06
-----------------------------------------------------
Reason1 1 3 NULL 2
Reason2 NULL 10 5 1
Reason3 4 NULL 3 1
Please find the attachement for more clarifications and help me for this..