I want to create a report like below layout:

Name:  Capture.JPG
Views: 344
Size:  25.0 KB

So basically I want to display those charges to a specific table: Charge #1, Charge #2 and Charge#3 with conditions stated below

- Charge #1: Account ID is in (1,2 and 3)
- Charge # 2: Account ID is in (4,5 and 6)
- Charge # 3: Account ID is in(7,8 and 9)

So, there are three fields that involve on the report, Account Description (A,B,C,D,E and F), Charges, and Account ID (1,2,3,4,5,6,7,8 and 9)

So what I did, I created three formulas for charges field. Charge1, Charge2 and Charge3. I placed them on the detail fields and do the select expert on each charge.

1. The Select expert on Charge1, I placed the Account ID is equal to 1,2 and 3.
2. The Select expert on Charge2, I placed the Account ID is equal to 4,5 and 6
3. The Select expert on Charge3, I placed the Account ID is equal to 7,8 and 9

The report returned blank when I previewed it. I am wondering if you know how to write the formula to handle this case?

I am using Crystal Report V 11.

Anyone can help?