BusinessObjects Board

Creating specific DLL or VBA function to use in BO

building reports desktopintelligence
#1

hello !!

How ?
Where ?
With which tool ?

I’m interrested in a way to add special functions in BO as a module in Access or Excel.

But i didn’t know how to proceed …

I added a VBA function in my report in order to check the IBAN Key.

But I didn’t know the way to call this function in variable definition or else…

Any answer will be very appreciated :slight_smile:

Regards

bertrand_campina :fr: (BOB member since 2003-09-09)

user defined functions in designer
VB Functions called from BO
#2

You could create a menu in business objects by doing something like this:

    Dim BO_CmdbarControl As busobj.CmdBarControl

    On Error Resume Next
      
    Set BO_CmdbarControl = Application.CmdBars.Item(2).Controls.Item("&Insert").Controls.Item("&Duplicate Report...")
    If Err.Number <> 0 Then ' if error then the menu doesn't exist. Create it.
        Set BO_CmdbarControl = Application.CmdBars.Item(2).Controls.Item("&amp;Insert").Controls.Add(1, , 15)
        BO_CmdbarControl.Caption = "&amp;Duplicate Report..."
        BO_CmdbarControl.DescriptionText = "Duplicates a report"
        BO_CmdbarControl.OnAction = ThisDocument.Name &amp; Right(ThisDocument.FullName, 4) &amp; "!ShowForm"
    End If

Note: this was taken from one of the business objects add-ins that I use, developed by Glenn Fredericks (glenn_fredericks@aal.org).

peetpio (BOB member since 2003-06-24)

#3

You misunderstood me.

My goal is to call a function (written in VBA or else) in the variable déclaration, when you create a new variable like.

I wonder if it’s possible to call it like the others functions ( Average, Abs …)

I still not have any solution :confused:
If someone can help :slight_smile: ?

bye

bertrand_campina :fr: (BOB member since 2003-09-09)

#4

Try a search here on BOB for “create custom function” or “function dll” (without quotes). You will probably find these two topics particularly interesting:

Create and use external/custom functions
Can I create a Variable, and use a Function?

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

#5

compilation Tool : Visual C++ 6.0
Just add the 2 libs ( Sample.lib and External.lib ) to the link librairy files.

Those files are in the BO folder

Start by a DLL project, add the H files and the C file

After the building process, put the DLL made in the UserLibs Folder under BO Folder

By this adding, when you start BO and create a new report, the developped functions will be avaiable under the “Misc Functions” Folder when you creating a variable :lol: :mrgreen:

Thx all for the help.

Bertrand

bertrand_campina :fr: (BOB member since 2003-09-09)