SkipNull and Skip Zero in CrossTab?

rbuser

Folks,
firsts off - thanks to everyone who contributes, most posts help a whole lot
!;-)

Now on with my problem
I understand how the SkipNull works, but how can I skip rows of my CrossTab
of all records have a value of zero, or a mix of both '0' and null values.

I guess I could created a calculated field and add the values of records,
and if the total is 0 (or null) then don't display - but there *has* to be a
better way.

All thoughts ideas greatly received
Cheers
Mark

digitalmetaphors

Since zero is a valid number there is no way to tell the crosstab to skip
that number in particular. You will actually have to work with modifying the
dataset in this case. By this I mean either changing the zeros to nulls so
that the crosstab data traversal engine skips them, or actually selecting
only the non zero records in the first place.

--
Cheers,

Alexander Kramnik
Digital Metaphors