Group with No Values, Crystal IX
tried to achieve something on both regular reports and on cross-tab
reports, and have the same problem on both reports. I have field for loan ID, loan amount, and loan officer. I want to show the
count of the loan ID and the sum of the loan amounts for each loan officer during
a specific date range. The
problem is, if the loan officer doesn't have any applications during the
chosen date range, the loan officer doesn't appear on the report at all.
I want all the loan officers to be on the report, and if they don't have
any loans during that date range, I want it to show 0 for the count and
0 for the sum.
I am on Crystal IX and the data is sequal.
Can anyone help? Thanks.
M Kotzabassi replied
Yes, it looks like the linking is the problem because of ""MVData"."dbo"."company_file" "company_file" INNER JOIN "MVData"."dbo"."TRACKING_FILE"". I believe this needs to be a left outer join. Since you can't seem to access the link options between company_file and TRACKING_FILE maybe it would be best to replace company_file with a new table that contains 1 record for each of your loan officers with the loan_officer_code as the single field (as you mentioned in a previous post). Then see if you can do a left outer join between that new table and TRACKING_FILE. Hope this helps.