Conditional suppressing a Running total in Detail 2

[varadha72]

Hi

I have a running total for a field {price} placed in Detail section. I have group my report based on customer ID. I have set the RT to sum every record and reset on change of group.
Requirement- I have to keep the RT suppressed for every row entry and display only the last row entry for that group. Kindly help me understand how to achieve this.

Eg-
GH-
Customer 1
Detail- Name Amount Running Total
A 10 (RT is suppressed)
B 5 (RT is suppressed)
C 5 20 (RT is displayed becos its the last record for this group)
Customer 2
A 5
B 20 25
Customer C

 

[Charliy]

Put the RT in the Group Footer and then go to the Section Expert and check Underlay Following Section on the Detail.

 

[varadha72]

Hi Charliy,

I had placed the RT in the GF, and rest of the fields in Details. Then I selected Underlay option in Section Expert , to underlay the detail section. This did not work. The RT is coming in a separate line and not along the last line of the Detail section - group.
OUTPUT-
GH-
Customer 1
Detail- Name Amount Running Total
A 10 (RT is suppressed)
B 5 (RT is suppressed)
C 5
Group Footer
20 (RT is displayed becos its the last record for this group)
Customer 2
A 5
B 20
Group Footer
25
Customer C

 

[Charliy]

Okay, let's try i this way.

create a suppress formula for the RT that is like: not(onlastrecord) and {customerid} = next({customerid})

 

[varadha72]

Hey Charliy, thanks that works. Exactly what I was looking for.
I was wondering, like OnLastRecord, dont we have anything similar for OnFirstRecord or PreviousRecord? Just asking.

Thanks

 

[Charliy]

There is also Onfirstrecord, and there are fucntions for Next({table.field}) and Previous({table.field})