How to create a .REA file and how do I use it in the BO

sdk development
1

Hi,

I have a VBA function to convert amount to words. I would appreciate if someone can help me on how to create a .REA file (the add-in) and how to use the function in Business Objects Report.

Thanks & Regards

M. Amjad

M.Amjad (BOB member since 2005-07-31)

2

In BO FC Reporter there is an option on the top toolbar that will open up the vb panel.

MikeD :south_africa: (BOB member since 2002-06-18)

3

To save your VBA code as an REA, simply do the “Save As” option. However, you cannot call VBA functions from within a report. In order to create custom functions that you can use in variables you have to write your code in C and link your object file with the BusinessObjects libraries.

Dave Rathbun :us: (BOB member since 2002-06-06)

4

Dave,

Still i am not getting a clear picture of Macro, *.rea files, add-in and finally how i can use them in a report.

Please advise

KhoushikTTT :us: (BOB member since 2005-02-24)

5

You cannot use VBA (via add-in or otherwise) to create custom functions for use in Reporter formulas. You have to write a .dll using a “real” programming tool, place the file in a certain directory on the workstation, etc. Very cumbersome to implement and distribute.

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

6

I have a working custom function in VB that converts amount (a numeric value passed as parameter) to words. How can I use this in BO Report where I need to show the amount in words. I would really appreciate if someone can help me getting this thing done.
Cant I use like this =NumToWord(). Is there any workaround solution. Waiting for replies. Pls Pls this is stopping the show.

Thanks & Regards to All

M.Amjad (BOB member since 2005-07-31)

7

As I already said, you must write your code in “C” (I’m not even user that VB - as opposed to VBA - would work) and compile your library and link it to the BusinessObjects code. The file you link to changes based on the version…

Dave Rathbun :us: (BOB member since 2002-06-06)

8

On the other hand, you can use the AfterRefresh function to call your VBA function, stepping through the data and setting the values in a bocube.

Cheers
Scruffy

scruffy :australia: (BOB member since 2005-01-19)

9

Thanks a lot Scruffy,
Could you please explain me in more detail about the AfterRefresh function and how can I call my function by passing a parameter. Also pls tell me about stepping through the data and setting the values in a bocube.

Best Regards,
Amjad

M.Amjad (BOB member since 2005-07-31)

10

Here’s a quick example of a BO Cube using the Beach Resort universe. The revenue is passed to a VBA function which increases it by 200, and then stores it in a BO Cube. This is then linked to the existing data provider, to display the increased revenue.

Cheers
Scruffy
Quick dynacube.rep (68.0 KB)

scruffy :australia: (BOB member since 2005-01-19)