BusinessObjects Board

BO 6.5 - VBA: Initiate Connection and Filter

sdk development
#1

Hello,

i have to create a VBA Programm to filter Data out of my Report.
Im a Newby and have no Idea how to handle.

Also i need a button in the Report to start the Userform.

Thanks :smiley:

schnurzel (BOB member since 2008-11-18)

#2

There are numerous posts already present on BOB for what you are asking
Found this


Further keyword search : forecompute
You can have a menu item created which can invoke a userform too

.

haider :es: (BOB member since 2005-07-18)

#3

Hmm.
I really have no experience with using VBA and BO together.
First: How to start my Userform in my existing Reports by including and using a Button?
Second: How to get a connection to get Data out of my existing Report to fill into a Combobox in my Userform and use the Choice as the Filter on my Report?

Example: Report Data Name, Adress, Country
In My Userform exists a Textbox to fill in the Name.
Then the Programm has to use this Input to search in my existing Report.

My Question: How to realize it?

schnurzel (BOB member since 2008-11-18)

#4

I had already recommended you to search in the SDK forum where you will find all that is required
Start from here

.

haider :es: (BOB member since 2005-07-18)

#5

I just need the WAY I can get my Data out of the existing Report into my Userform --> How do I create the Connection?

I don’t want to convert my Reports to Excel or PDF.
I want to create another FILTER into the existing Reports in Business Objects using VBA (the VBA implemented in BO, not in Excel or Access).
Using another Programm is not possible here.

schnurzel (BOB member since 2008-11-18)

#6

Let me be clear here, though I can show you the WAY on how to create a userform and attach it to a menu item but the search functionality(I am not sure if you know the built-in search option from edit-find menu) which you are looking for may not be possible

.

haider :es: (BOB member since 2005-07-18)

#7

Please show me how to do it.

I want to use entries from a userform as a filter.
How can i get the Data i need out of the textbox?

I tried it the Access-Way, but i failed.
I have not found a solution to adress the explicit cell or row in my report.

Is there a solution to adress the seperate cells?

schnurzel (BOB member since 2008-11-18)

#8

Read this:
Reading data from report blocks
Where to Start - SDK?
loop through the cells of a report

.

haider :es: (BOB member since 2005-07-18)