Re: Crystal Reports' formula
Try to avoid using record selector. Sometimes record selector displays blank data on the report (for me...). You can create a formula to accomplish what the record selector does (for the most part).
To my understanding, you want to use a specific charge number for accounts.
You can accomplish your need using logic formulas.
The first step will be to create a formula to group charge numbers.
1. Create a formula and call it "Charge"
2. In the formula, create a Crystal Syntax logic statement:
If [Account ID Field] in ["1","2","3"] then [Charge#1 Field] else
If [Account ID Field] in ["4","5","6"] then [Charge#2 Field] else
If [Account ID Field] in ["7","8","9"] then [Charge#1 Field]
Note:: If your Account ID's are numbers and not text, then take out quotes [1,2,3] . If your data is text, then you will need to create another formula to convert your text to number (for totaling purposes)
Add the following fields to your report to obtain what you wanted. If needed, you can add a running subtotal.
[Account ID Field] [Charge]