on 04-01-2015 5:13 PM
Hi,
I need your help and assistant in getting the record no. or sequence no. in the details for each displayed record. My report looks like below:
GH1: {Instrument.Name}
Details: {Deal_No} {@Sum_Formula}
GF1: {Instrument.Name}
I need the record no. to be shown before the {Deal_No} in the details section and I want use it in my formula. Currently, I tried to use a running total to get the count for the {Deal_No} and to be reset on changing of group GH1: {Instrument.Name}, but unfortunately it gave me wrong record no. because there are suppressed {Deal_No} and sometimes the record number will start from 28 or 120 in some groups where I want for each group to start by showing no.1 and the next record should have no.2 ...etc.
In the {@Sum_Formula}, I need to apply the following condition:
If it is the first record in each group then
total= {@OB}+{@DR}+{@CR}
else
total=total+{@DR}+{@CR}
So please help me getting the first record in each group and to apply the formula.
The easiest way to do this will still be to use a running total. However, instead of evaluating "for every record", you'll set it to evaluate on a formula. In the formula you'll use not(suppression formula). This will then only count the records that are not suppressed.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You said:
"I tried to use a running total to get the count for the {Deal_No} and to be reset on changing of group GH1: {Instrument.Name}, but unfortunately it gave me wrong record no. because there are suppressed {Deal_No}..."
It is the formula you are using to suppress {Deal_No} on your report. Since you're talking about Details sections, I assume it's in the Suppression Formula in the Section Expert for your Details section. Copy that formula and then use it in the Evaluate section of the Running Total expert - type "Not(", paste the formula, and then type ")" (don't include the quotes).
-Dell
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.