How Can I call a vba function in bussiness objects

building reports desktopintelligence
1

Hello:

I have a doubt . I want to call a vba function which order months, but I don´t know how to do it. When I use the Visual Basic Macro Editor of Business Object, only I can program four events. And I need to order months in my report without using the filter that has a bug.

Thanks

anderg (BOB member since 2004-08-04)

2

Can you give us more information to go on?

As far as I know, (from previous posts), you can only call a vb procedure from a business objects object if you have the code in an addon.

Please expand on your problem.

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

3

You can’t. :?

You can use a vba procedure to process your data and provide a new data provider. But you cannot call a vba function in a variable definition. And you can’t call a vba procedure as a custom sort procedure.

What is the “bug” that you are seeing? I’m not aware of any bug in sorting.

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

4

It seems to be a bug when sorting by months, and then using the sorted data with an aggregation function like add, at least at the Spanish version.

miguelb (BOB member since 2004-07-23)

5

Are you using a custom sort?

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

6

Yes, that’s the month sort i meant, by month names. So someone told me I should find another way to sort months without using the customized sort, and I can’t find any solution…

miguelb (BOB member since 2004-07-23)

7

So, just to be clear, you are trying to use the Custom Sort and it is not working. I assume because of the different language in use. Have you tried simply custom sorting the month names manually, by using the Move Up and Move Down buttons?

Another option, from the “old days”… :slight_smile:

Add month number to your document. Sort it, and then hide it. Your data should remain sorted by number, which I assume there would be no problem with.

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

8

Hi
Thank your very much Dave for your solution is very practical and in addition it works very well

anderg (BOB member since 2004-08-04)

9

Really? :roll_eyes: :reallymad:

Can you call use a BO variable definition to call a VBA function in 6.5.1 ?

shic1103 :us: (BOB member since 2003-10-31)

10

While I haven’t tested it, there really is very little new in Reporter in v6. I doubt this functionality was added. I don’t remember reading it in any of the v6 series of release notes.

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