I have a crystal report with 2 tables. The first table is a General Ledger transactional table (view table), from which I want to see all trxns. The second table is a Job Cost sub ledgertable that has a number of the trxns also in the GL table. I only want to see the Job Number from this table. So effectively a report that gives me all GL trxns and indicates a job number if the trxn related to a Job cost trxn.
GL table fields
Open Year
Journal Entry No.
Trxn Date
Debit amount
credit amount
Account Index (Account Number)
Job Table
Journal Entry No.
Account Index (Account Number)
Job Number
The Job table has more fields but these are the main ones I want to use. I am joining on the Account Index (Account Number) and the Journal Entry No. The problem I have is if I use a left join I don't get the Job number from the Job Table but get all the GL trxns listed correctly. If I use an outer join I get the job number but get the GL trxns duplicated. I can understand why this happens on both types of joins but am unsure how I can get what I want in the report, being the trxns with the Job number where applicable? Hope some of you smarties can help me
IP Logged
