Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Group with No Values, Crystal IX

I have

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.

Former Member
Former Member 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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question