BusinessObjects Board

VB code to capture No Data to fetch message while refreshing

Hi,

I need to refresh a set of reports(about 800) and save them back into the folder. I am writing a maco to do it, meanwhile I also want to capture the reports list which does not have any data int hem after refrshing. Can anyone help me out with the VB code to capture this message!

Thanks.


Siddharth :india: (BOB member since 2005-12-16)

After each document is refreshed, the following code (assuming only one data provider) will check to see if any rows were returned:

If Doc.DataProviders(1).NbRowsFetched = 0 Then
    'do your "capture" logic
End If

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

Thanks Dwayne! this has worked for me.

Regards,
Siddharth.


Siddharth :india: (BOB member since 2005-12-16)