Creating a formula field

[nigelot]

I have a report that contains the following groups, sorted by #-

#1: Contact.Address 2 - A
#2: @Pcode - A
#3: @Spring () - A
#4: Contact.Crewman - A

@Spring string is-

if '/' in {Contact.SPRING} [1 to 3]
then Cdate(left({Contact.SPRING},8))

I would like to add a running total field which would tell me the total App Cost (Contact. App Cost) for the #4: Contact.Crewman - A who is in the Address 2 area on a particular day.

I think this would envolve creating a formula field sometime like-

Show the total Contact. App Cost for the Crewman for the date that appears in
#3: @Spring () - A

then inserting a running total field.

Hope I make sense
thanks

Nigel

 

[HowardHammerman]

Close, but no cigar.

Create a running total like this:

In the summary section:
Field to summarize: App_Cost
Type of summary: sum

in the evaluate section:
Click on "on change of group"
Pick: Group #4

In the reset section
Click on "on change of group"
pick: Group #3

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269