Check for an empy numeric field

[TonyFoo]

Hi All,

I have a numeric field in my report ("CurrentQuantity"), is there a way to check if the field is empty?

Also, Is there a way to suppress the first row in the details section?

Thanks,

 

[kskid]

If isnull({table.field}) then
"do this"
else
"do that"

Not sure about the second part but you can try this.

You could put a running total (#runtot) to reset with each group. From the section expert, check suppress the detail section and in the x-2, add the following

if #runtot = 1 then
true
else
false
if runtot

 

[lbass]

You could also suppress the detail section using:

onfirstrecord or
{table.groupfield} <> previous({table.groupfield})

-LB