Skip to Content
0
Former Member
Sep 24, 2008 at 06:57 PM

Group with No Values, Crystal IX

46 Views

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.