AX 2012 SSRS Report Export To File

    Args                    Args;
    SrsReportRunController  controller;
    Common                  _record;
    SRSPrintDestinationSettings        printSettings;
    ;
    controller= new SrsReportRunController();
    controller.parmReportName("SysDataBaseLog.Report");
    Args = new Args();
    args.record(_record);
    controller.parmArgs(args);

    printSettings = controller.parmReportContract().parmPrintSettings();
    // set print medium 
    printSettings.printMediumType(SRSPrintMediumType::File); 
    printSettings.fileFormat(SRSReportFileFormat::Excel); 
    printSettings.overwriteFile(true); 
    printSettings.fileName("tempfilename.xlsx");

    // suppress the parameter dialog 
    controller.parmShowDialog(false);
    controller.parmLoadFromSysLastValue(false);
    // start operation 
    controller.startOperation();

 

posted @ 2016-03-02 11:40  Sprite.z  Views(241)  Comments(0Edit  收藏  举报