My report contains following tables,
TaskSheet_Details [Table_name]
--------------------------
Task_id
Emp_Id
Notes
Task_Date
Duration
Task_Details
-------------
Project_id
Task_id
Document_name
title
Allocated_hours
Project_Details
------------------
Project_id
Project_name
Employee_details
------------------
Emp_id
Emp_name
Now in my report i need to display as follows,
Report Should only the details of project which is selected in interface for a particular month, week respectively.Data should be grouped w.r.t document_name & title. Details displayed will be emp_name, notes, task_date, duration
Project_name:abc
Document_name - Title
Emp1 note_1 2011-05-02 12
Emp2 note_2 2011-05-03 10
Can anyone please help me on how to get create this kind of report?
Thank you
TaskSheet_Details [Table_name]
--------------------------
Task_id
Emp_Id
Notes
Task_Date
Duration
Task_Details
-------------
Project_id
Task_id
Document_name
title
Allocated_hours
Project_Details
------------------
Project_id
Project_name
Employee_details
------------------
Emp_id
Emp_name
Now in my report i need to display as follows,
Report Should only the details of project which is selected in interface for a particular month, week respectively.Data should be grouped w.r.t document_name & title. Details displayed will be emp_name, notes, task_date, duration
Project_name:abc
Document_name - Title
Emp1 note_1 2011-05-02 12
Emp2 note_2 2011-05-03 10
Can anyone please help me on how to get create this kind of report?
Thank you