Count Null Column

[MaumeeScott]

What would be the best way to count and display the number of null fields on a record?

Thanks!

 

[johnberchmans]

You can use the following Actuate Basic functions or Component methods to count the number of NULL datarow variables.

1. GetVariableCount(DataRow) -- to find the number of datarow variables.
2. Function GetValue( index As Integer ) As Variant of the datarow.
3. IsNull(<expr>).

*****
Dim i as integer
Dim nulCount as Integer

For i = 1 to GetVariableCount(Fetch)
if IsNull(Fetch.GetValue(i)) then
nulCount = nulCount + 1
end if
Next I
*****

You can use the above code in the Fetch method of the datastream and save the nulCount value in a datarow variable to be used later.

I hope this helps.

-- JB

 

[MaumeeScott]

Thanks John. Very helpful.

Scott