BusinessObjects Board

how to include data retrieved by VB macro?

general discussion
#1

hello all,
i want to know how to include data retrieved by VB macro?
as i retrived data from Database using VB code, so i have the Recordset that holds that table. so how can I use that table in the report? or make the BO see it
thanks

RobeirSamir (BOB member since 2005-06-21)

#2

Assuming you own the SDK…

One of the dataprovider types that you can use with full-client is a VBA procedure. It’s under the Other Types of data providers in the new DP wizard.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

There’s a sample of a VBA data provider in BOB’s Downloads.

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

#4

The guidance you’ve been given is good, but I have a bigger question. Why are you using VB (and I assume ADO) to get the data? Wouldn’t a universe, or at least Freehand SQL, be a lot easier?

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

#5

actually it would be a very very complicated Query using cursors and would use alot of time, so i thought about handling that issue by codeing that’s why i am using VBA macros:S

RobeirSamir (BOB member since 2005-06-21)