Scheduled tasks with no data

[funkmonsteruk]

I currently have several BO reports running as scheduled tasks on my PC. This has so far proved an easy process with autoopen routines taking care of the process of actually refreshing, exporting and saving the data. However i have encountered my first minor problem, one of the reports i ran this weekend and Saturdays had no data in it so the no data dialogue box appeared and stopped the report from running on Sunday.

Can i add a VBA routine to deal with reports with no data in them.

 

[ainkca]

Check out "promero"s response to thread393-87598 (Sept 8) about BO Command lines. There is code to make the application not interactive. Have not tried it, but it sounds like it could work for you.

 

[MikeMcErlain]

In a macro you can indicate that the application is not interactive with the following code;

    Dim myAppl As Application
    myAppl.Interactive = False

    '* Refresh the current report
    Dim myDoc As Document
    Set myDoc = ActiveDocument
    myDoc.Refresh     'Refresh the document
    myDoc.Save        'Save the refreshed document

This will eliminate pop-ups and continue to process the remainder of the macro.

Mike McErlain
Cypress eBI, Inc.
MieMcErlain@hotmail.com