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.