Hi,

Can anyone help me with Crystal Report formula?

I want to create a report like below layout:

Name:  Table.jpg
Views: 259
Size:  16.4 KB

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

So, here are the conditions:
- 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 I want to create, 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 formula for charge 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 place the Account ID is equal to 1,2 and 3.
2. The Select expert on Charge2, I place the Account ID is equal to 4,5 and 6
3. The Select expert on Charge3, I place the Account ID is equal to 7,8 and 9

but when I preview the report, the report returned blank. Anyone know how to do the formula so I can display the report as on this attachment?

Thank you so much for all the help