Birt equivalent to actuate "OnRead" scripting??

kilo316

Hello,

I am migrating from actuate to birt reports 3.2.17 (for maximo). Everything was going along smoothly until I hit a report in actuate that had "OnRead()" method with some scripting. Apparently, this is a standard "hook" into which you can place some scripting that can manufacture data based on values in the fetched datarow.

Does BIRT have something equivalent? For every datarow fetched, can some "method" or script be executed?

Here is a sample from actuate:

Dim sSite as String
Dim sLocation as String
Dim sItemNum as String
Dim sItemSetID as String
Dim sIssueType1 as String
Dim sIssueType2 as String

sSite = SITEID
sLocation = LOCATION
sItemNum = ITEMNUM
sItemSetID = ITEMSETID
sIssueType1 = GetUseIssueType(sSite, sLocation, sItemNum, sItemSetID, useTransDate)
sIssueType2 = GetRecIssueType(sSite, sLocation, sItemNum, sItemSetID, recTransDate)

If (DICOST = "AVGCOST") Then
COST = Format(ACOST, "0.00")
ElseIf (DICOST = "STDCOST") Then
COST = Format(SCOST, "0.00")
ElseIf (DICOST = "LASTCOST") Then
COST = Format(LCOST, "0.00")
End If

If IsNull(CBAL) Then
CBAL = 0
End If
CBAL = Format(CBAL, "0.00")

mwilliams

There is an onFetch method for each dataSet that would allow you to do something for each row fetched. You could also create a computed column to be able to execute some script on another field withing the dataSet to return or calculate a value. Maybe I'm misunderstanding. Let me know.