Hi!

I have the following problem.

On A report The user has headers in the
Page Header and rows in the detail band...

Here is an example

measrep.head4 - Page Header
-----------------------
measrep.extra4 -detail

The header has the following print when on it...
IIF( NOT EMPTY(measrep.extra4),'Header1','Header2')

The problem is the data could look like

extra4
-----
0
0
65
0
0
0

What is happening now is the header is shifting between header1 and header2
and ends up (i guess) with the value on the last line.

What I need is a way to say if there are any values in this column take header1
otherwise take header2. How can I do this with the limitation
that I can only use functions.

I could of course make a program but I am trying to avoid this.
I don't want to use seek() becuase then I need an index on each column..

I hope this makes sense...

Thanx!