BusinessObjects Board

VB Functions called from BO

sdk development
#1

Is it possible to call vb code from business objects something like this.

My function would be;


Public Function Trial(strDesc as String) as String

   Set Trial = SubStr(strDesc,1,3)

End Function

My function is more complex than that, but it will suffice as an example.

So in Business Objects, I would want the formula of a cell to be;


=Trial(<Long Description>)

Is something like this possible???

stuartgmilton :uk: (BOB member since 2003-01-30)

Statistical function
#2

Sure.

Public Function Trial(strDesc as String) as String 

   Trial = Mid(strDesc,1,3) 

End Function

dirmiger :us: (BOB member since 2002-08-28)

#3

With all due respect to Don, it simply doesn’t work that way. You can create a VBA function and call it from VBA, but it’s not usable in report-level formulas. The only way is to create a separately compiled dll and distribute it to all your users. Follow these links to previous discussions:

https://bobj-board.org/t/21751
https://bobj-board.org/t/26453
https://bobj-board.org/t/24705
https://bobj-board.org/t/21185

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#4

Dwayne is right. I thought this was a syntax question…

dirmiger :us: (BOB member since 2002-08-28)