Problem suppressing empty rows with Crosstab object

[ebutter]

V10
xml data with ADO.NET driver

I am using Crosstab objects to build some reports. I need to be able to conditionally suppress rows. The following doesn't work:

Year1 Year2 Year3
Row Label 1 20,000 21,000 22,000
Row Label 2 0 0 0
Row Label 3 30,000 31,000 32,000

1) Suppress Empty Rows is selected in the Crosstab expert.
2) Row Label 2 has a conditional suppression formula that check for 0's in the values field.
3) The values fields have Suppress if Zero selected on the number tab of the Custom Style dialog.

The result is that the whole row is blank, but it won't shrink up (disappear) like happens when you suppress a Section.

What am I doing wrong?

Thank you.

 

[hneal98]

you need to do that before it becomes part of the crosstab. Do it in the record selection. Go to Report|Edit Selection Formula|Record, and then enter the formula that would eliminate the values of 0 and a specific field.