Variable value changes in SUMMARY band

[jkeri]

My date table is like this:

RecordType Tons

01 15

01 20

02 25

03 30

03 40

04 50

 

there are multiple record types 01 and 03.  Record types 02 and 04 only have one data record each. What I want to do is to store the TONS value of each record type 02 and 04 into 2 seperate variables. Each RECORD TYPE is printed in its own DETAIL BAND. There is always the same number of records retrieved from  the database.

RECORD TYPE 02 stores into V1 and RECORD TYPE 04 V2. therefore V1 = 25 and V2 = 50

At the end of my report, in the SUMMARY band I want to do a calculation (V1 + V2). (25 + 50)

What is happening is that in the SUMMARY band V1 contains the same value as V2 for some reason. (50 + 50).

Any ideas?