Reportbook Export via Application Engine Process

grobe

Hopefully a easy question, as v12 doesn't have the scheduler function for reportbooks we are exporting reports using application engine routines ran by windows task scheduler.  The processes are working fine but one issue we have is when reportbooks are exported to excel they are showing live with formulas, I assume there will be some additional code that is required for the reportbook to be exported as values only?

Below is an example of the app engine script:

VariantDictionary attachment = CreateVariantDictionary();
        BookExportProfile profile=CreateBookExportProfile(BookExportProfileType.Diff);

        //profile.SetSelection("XiF_BudgettoActual2",0,"lv_CC",BookExportSelectionType.Member,UID);

        BookExportResult beResult = ExportReportBook(APP_NAME,Report_Book, BookExportOutputType.Excel,profile);

siegfried-fleig

You can use "BookExportOutputType.ExcelValue"

Here an example:

    BookExportResult berResult = ExportReportBook("Mips06", "ReportBook_Sales_0001", BookExportOutputType.ExcelValue, bepProfile1);

Regards Siggi