cybeh
asked on
Status Report by using CR.
Hi,
May I know how can I get this report by using crystal Report. (VB + MySQL Database)
Data:
No. File Status Completed Date
========================== ========== ========== ==========
1 File1 Task A 2-Jan-2007
2 File1 Task B 3-Jan-2007
3 File1 Task C NULL
1 File2 Task A 1-Jan-2007
2 File2 Task D NULL
1 File3 Task A NULL
The Report I need
===============
No. File Last Completed Task Completed Date Pending Task
========================== ========== ========== ========== ========== ========== ==========
1 File1 Task B 3-Jan-2007 Task C
1 File2 Task A 1-Jan-2007 Task D
1 File3 - Task A
I guess I need to play around with grouping...but i didn't have a clear image on how to solve this. Please advice.
May I know how can I get this report by using crystal Report. (VB + MySQL Database)
Data:
No. File Status Completed Date
==========================
1 File1 Task A 2-Jan-2007
2 File1 Task B 3-Jan-2007
3 File1 Task C NULL
1 File2 Task A 1-Jan-2007
2 File2 Task D NULL
1 File3 Task A NULL
The Report I need
===============
No. File Last Completed Task Completed Date Pending Task
==========================
1 File1 Task B 3-Jan-2007 Task C
1 File2 Task A 1-Jan-2007 Task D
1 File3 - Task A
I guess I need to play around with grouping...but i didn't have a clear image on how to solve this. Please advice.
ASKER
I am using CR XI + SQL string @ the data expert.
Actually in our database, the incomplete task will have a completion date of "1601-01-01", maybe we can make use of that?
Actually in our database, the incomplete task will have a completion date of "1601-01-01", maybe we can make use of that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the reply. But this will not show the report is all task are completed.
I think i didn't give a good test case in my previous post
Data:
No. File Status Completed Date
========================== ========== ========== ==========
1 File1 Task A 2-Jan-2007
2 File1 Task B 3-Jan-2007
3 File1 Task C NULL
1 File2 Task A 1-Jan-2007
1 File3 Task A NULL
The Report I need
===============
File Last Completed Task Completed Date Pending Task
========================== ========== ========== ========== ========== =======
File1 Task B 3-Jan-2007 Task C
File2 Task A 1-Jan-2007 -
File3 - - Task A
Please advice. Thanks !!!
I think i didn't give a good test case in my previous post
Data:
No. File Status Completed Date
==========================
1 File1 Task A 2-Jan-2007
2 File1 Task B 3-Jan-2007
3 File1 Task C NULL
1 File2 Task A 1-Jan-2007
1 File3 Task A NULL
The Report I need
===============
File Last Completed Task Completed Date Pending Task
==========================
File1 Task B 3-Jan-2007 Task C
File2 Task A 1-Jan-2007 -
File3 - - Task A
Please advice. Thanks !!!
ASKER
Manage to do it by using the 2nd method. Thanks !!!
Glad i could help
mlmcc
mlmcc
Create a group on the FILE field.
Add a sort on the date - Descending
You should be able to put the FIle, Status, and Completed date in the grouip header to get that part.
To get the pending task will be a little more difficult.
How are you selecting the database/table?
What version of Crystal?
mlmcc