-
March 5th, 2015, 09:59 PM
#1
Crystal Report formula
I want to create a report like below layout:

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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
On-Demand Webinars (sponsored)
|