BusinessObjects Board

Export data from report to rdms

HI,

I’m working on BOXI version of BO.

I need to export data from the table of one of the BO reports ,which is based on several dataproviders to the table of Access.

I know that it possible to define loop in VBA which is running on the cells of the table and exports it’s values to Access. I’ve done something like that several years ago and now I don’t succeed to recover this code.
:hb:

Any help or code sample will be appreciate.


Farhad (BOB member since 2007-08-24)

Assuming you are talking about full client documents, that would be extremely valuable code indeed, because it is not possible with VBA to get directly at the data in a report block (table). From the data provider yes, but not from the report itself.

Another alternative is discussed here … Using BusObj Reporter/DeskI as data source for Excel/Access


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

and what about a WEBI reports ? Do you think we can find a script to do this ?.. hum, I think thats more complicated with WEBI reports…

:wah:
cheers


kenny :fr: (BOB member since 2007-01-02)