...
var reportID = 'I4028818a015bcd86cd86884a015be7213d090a5e';var reportParamSetting = [];var openReportOutput = execute('openResource', { connector: connector, reportId: reportID});var enumerateParamValuesOutput = execute('enumerateParamValues', { resourceHandle: openReportOutput.resourceHandle, byEveryParam: false, paramsSetting: reportParamSetting});var exportReportOutput = execute('exportResource', { connector: connector, resourceHandle: openReportOutput.resourceHandle, paramSettingIterator: enumerateParamValuesOutput.getParamValues(), exportSetting: {"delimiter":"","pathId":"","fileNameSufParams":true}, taskName: taskName, exportType: "EXCEL2007"});openReportOutput.resourceHandle.close();var outputFile = exportReportOutput.file;importPackage(Packages.java.text);importPackage(Packages.java.util);var cDate = new SimpleDateFormat("yyyyMMdd").format(new Date());var fileName = outputFile.getName();var subfixIndex = fileName.lastIndexOf(".");fileName = fileName.substring(0,subfixIndex) + cDate + fileName.substring(subfixIndex);var sendToFileOutput = execute('sendToFile', {file: outputFile,sendSetting: {path: 'c:/', filename:fileName}});var ret = { openReportOutput:openReportOutput, enumerateParamValuesOutput:enumerateParamValuesOutput, exportReportOutput:exportReportOutput};ret; |
