mithani
Registered User.
- Local time
- Today, 09:14
- Joined
- May 11, 2007
- Messages
- 291
Hello,
Could you please have a look attached my database link in Crystal Report 2008.
I am using two databases:
MYOB Database
Table : Item : List of all items
Table : ItemPurchaseLines : all purchase transaction
My Access Database
Table : Project : List of projects
Table : Project_cost : Budgeting cost for individual expense_code
I want my result set from a Left Outer join includes all the records in which the linked field value in all tables are an exact match. I need also to includes a row for every record from table Project_Cost for which the linked field value has no match in the lookup table (which is ItemPurchaseLines).
Could anyone please help me.
Regards
mithani
Could you please have a look attached my database link in Crystal Report 2008.
I am using two databases:
MYOB Database
Table : Item : List of all items
Table : ItemPurchaseLines : all purchase transaction
My Access Database
Table : Project : List of projects
Table : Project_cost : Budgeting cost for individual expense_code
I want my result set from a Left Outer join includes all the records in which the linked field value in all tables are an exact match. I need also to includes a row for every record from table Project_Cost for which the linked field value has no match in the lookup table (which is ItemPurchaseLines).
Could anyone please help me.
Regards
mithani
