The grand total field is a running total (using whileprintingrecords) hence I'm looking to do this using conditional suppression. If I try to use the select expert I just get "this formula cannot be used because it must be evaluated later".

 

I've got the conditional suppression set using the following basic formula/criteria:

 

{@Total} < 0 so that it suppresses each section if the total is less than zero.  This works fine for most of the sections however in the Detail section it suppresses all apart from the first entry (see the screenshot below).

 

This has been baffling me for the last few hours.  Can anyone suggest a fix?