-
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?
-
March 6th, 2015, 03:07 AM
#2
Re: Crystal Report formula
Please don't multi-post the same question http://forums.codeguru.com/showthrea...eports-formula.
Any member who is going to reply will for the first post.
All advice is offered in good faith only. All my code is tested (unless stated explicitly otherwise) with the latest version of Microsoft Visual Studio (using the supported features of the latest standard) and is offered as examples only - not as production quality. I cannot offer advice regarding any other c/c++ compiler/IDE or incompatibilities with VS. You are ultimately responsible for the effects of your programs and the integrity of the machines they run on. Anything I post, code snippets, advice, etc is licensed as Public Domain https://creativecommons.org/publicdomain/zero/1.0/ and can be used without reference or acknowledgement. Also note that I only provide advice and guidance via the forums - and not via private messages!
C++23 Compiler: Microsoft VS2022 (17.6.5)
-
March 6th, 2015, 04:23 AM
#3
Re: Crystal Report formula
You report file screenshot is looking good. What's more information you need?
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
|