Modifying a field value

[ziggs]

I'm new Actuate and have only created some reports for our users. Due to the database, I can't pull out an address the way the user wants.

I created a computed field like:

[Zetos.digits] & [Zetos.street] & [Zetos.type]

Unfortunately, my user says that his application looks at two address fields to determine one address (exact address versus a bad address that's not geovalidate).

So, Here's what another application does:

Dim strLocation as string
Dim strDigits as string
Dim strStreet as string
Dim strType as string

If strDigits <> " " then location = strDigits + " "
if strStreet <> " " then location = location + strStreet + " "

etc.

Anyway, in the computed field area, I can't figure out how to define a variable, ie strLocation etc.

How is this done? From there I think I can manage.

 

[bcaslow]

If you can't do this is the SQL -- as in using textual query -- I would opt to create a new variable on the datarow. Then, in the datarow's OnRead( ) method, perform the same logic that you showed here in the posting, setting the new datarow variable to equal the values of the other fields.


Bill