To make it simple, there are a number of records, each with a 'Code' Field, and also a value field. One of the codes is 'DOOR' and records containing these are present throughout the data, EG

 

DOOR    2

XXXX     3

yyyy      4

aaaa     1

DOOR    2

SSSS     3

YYYY      2

DOOR    2

qqqq     4

 

 

etc....

 

WHat I need to do is show a sub total for each set of records starting with DOOR - so in effect it show;

 

 

Not sure if I understand you correctly though. I've created a formula called RESETRT containing;

 

If {sicsp_SOP_Documents;1.Detail Product Reference} = 'DOORS'
then {#RTotal0} = 0

 

and have put this onto a new Detail Section....ir shows up as a 'false' if printed but doesnt reset the RTotal

 

 

 

 

BUT - I need to show the total just before its reset..as in a sub total like above....

.if I show the extra Detail line it shows after every other detail line..

If i Suppress on all except when it is DOOR then it has reset the value before it prints so always shows 0

 

 

Except - the last sub total doesnt show. ANy magic for this ?  

 

Thanks for your help - i've learnt something new.

 

Phil