Hi experts,
I have a table "TitleMaster" which storing ID and Title, which is to display the title for each row.
For Eg:
ID | Title
--------------------------------------------------------
1 | Total of Employee
2 | Total Sales
3 | Total of Customer
Another table "BranchData" storing data by branch.
For Eg:
TitleID | Branch Code | Data
1 | BR01 | 600
1 | BR02 | 500
2 | BR01 | 100000
In crystal report, user can select branch code. The report will left outer join TitleMaster table with BranchData table on TitleMaster.ID = BranchData.TitleID.
If there is some titleID not found in table BranchData, i would like to show all the title as well. Hence i try to use left outer join.
Expected Result (for Branch BR01)
Title | Data
--------------------------------------------------------
Total of Employee | 600
Total Sales | 100000
Total of Customer | <empty>
But I found that even I set the left outer join in Database Expert, the report will only show the title ID that have record in BranchData.
Title | Data
--------------------------------------------------------
Total of Employee | 600
Total Sales | 100000
Any idea on this or any workaround way?
Thank you.
& Happy New Year to all of you :)
Edited by crstar - 03 Jan 2013 at 8:04pm
IP Logged
