Consultor Eletrônico

Actuate, how to eliminate NULL records.


HOW TO FLUSH OUT UNWANTED OR NULL RECORDS

The aggregate functions in Actuate donÆt work if one
of the items in the databases is null.
Also if one would want only logical elements of the
database and eliminate any null occurances,
the way to do is include a single input filter in
the report design.
the single input filter takes a datastream as its
input ,to include a single input filter drag the
single input filter from the data pallete in to
the place holder where it says datastream.
then drag the actual datastream from the data
pallete into or over the single input filter.
the code to check the null records in the field
is written in fetch() method of the single input
filter.


Function Fetch() as AcDataRow

'declare arow as the actual data row
Dim arow as NewReportApp::drDataRow

'Loop to read rows until there are no more rows
Do while true
Set arow = InputAdapter.Fetch()
if arow is Nothing then
Exit Function
End If
If Arow.RequiredFiled <> "" then
Set fetch = arow
Exit Function
End If
loop
End Function


Progress Software Technical Support Note # 17543