Zero suppress total in Grid Column summary?

BLOMASKY

I have a grid column with a total on the bottom. It is an error condition if it is > 0. So, I would like to display the total in BOLD and RED. However, I can't make the 0 go away. (I thought <<SUM OrderTally.CADBalance, ##>>) would work, but I still get the zero.

Any of you smarties know of a way to suppress or conditionally have the sum run?

Thanks
Bruce

tford

I've never tried this on a total line, but for V6 detail grid lines I suppress zeros with a conditional format that has the same color background as the font. The zero is still really showing on the screen, but you can't see it.

BLOMASKY

not sure how to change the formatting conditionally in a grid.

tford

not sure how to change the formatting conditionally in a grid.

In each attribute, you can define conditional Styles (in Presentation dialog).

Then in each attribute shown in a grid, you can check a box which indicates that Styles should be used.

Unfortunately the styles have no impact on the summary section that you are trying to zero suppress. Not sure how to accomplish that.