Hi All,
I have three fields Job, Tasks, Tasks.Closed Date.
eg.
JobID, Tasks, Tasks.Closeddate
A,1, 9/8/2011
A, 2, 15/8/2011
A,3, 20/8/2011
This table is connected to anaother table Table2 through JobID. Table 2 contains ManagerName for any date. Table2 is connected to master calender.
So each job has many tasks and each tasks has its tasks.closeddate. I want my user to select any task (eg. A) and then I want to display the managers on each closed date.
So, there is master calender where i can connect as, task.closeddate=Calender. MasterDate. So that I can get the manager name on that corresponding date.
How to write an expression in a straight table, where I can give my dimensions as JobID, Tasks, Task.Closed date and it will display a manager name correspoding to each task.closeddate.?
Thanks. Any help would be appreciated.