VBA Business Objects: get report list

[BaseBallBatBoy]

Hi!

I'm new to VBA and also to BO in VBA. Now what I would like to do is get a list of all reports which are on a BO server instance (more precisely the path to the report and the report title itself). So, what do I need to do in order to achieve this if I have the following?

Dim BOobject As busobj.Application
Set BOobject = New busobj.Application
BOobject.Visible = False
BOobject.Interactive = False
' usr, pwd, cms, mode, ThreeTier, Offline are set elsewhere
BOobject.Logon(usr, pwd, cms, mode, ThreeTier, Offline)
' connection established, object ready for use

Also: Is there a handy website where I may look up all the methods of the BO specific objects?

Cheers
BBBB

 

[Hermanito]

Via this link:
http://help.sap.com/businessobject/product_guides/
you should be able to find lots of interesting stuff...

Can't help you with the server issue though, I have only used BO VBA for single document solutions...

 

[BaseBallBatBoy]

I found the solution. It doesn't work with objects but it does if we query the infostore directly.

Dim ceSessionManager As Object
Dim ceSession As Object
Dim ceInfoStore As Object
Dim report As Object
Dim reportsQuery As Object

Dim reportName As String

Set ceSessionManager = CreateObject("CrystalEnterprise.SessionMgr")
Set ceSession = ceSessionManager.Logon(usr, pwd, cms, mode)
Set ceInfoStore = ceSession.Service("", "InfoStore")

Set reportsQuery = ceInfoStore.query("SELECT top 1000000 SI_ID, SI_NAME, SI_PARENTID FROM CI_INFOOBJECTS WHERE SI_KIND ='FullClient'")

For Each report In reportsQuery
reportName = report.Properties("SI_NAME") + ".rep"
.... do more stuff in here....
Next