Knowledge Report Type Method: KnowledgeReportGeneration.Generate()

Example

let listRoots(List)
listRoots.Append(ProductRoot)

// Build date
let now(Date)
let nowString(String)
set now = BuildDate()
set nowString = DateFormat("%y%m%d_%H%M%S", now)

// Object creation
let generReport(KnowledgeReportGeneration)
generReport = new("KnowledgeReportGeneration", "name", NULL)

// Set mandatory inputs on object created
generReport.ReportName = "ReportNameSavedInDatabase"
generReport.Roots = listRoots
generReport.DocGeneratedName = "BaseName"

// to obtain an unique name: Add the date to the name of doc generated file
// generReport.DocGeneratedName = "BaseName" + "_" + nowString



// optional inputs
generReport.OverwriteDocGenerated = True

// to create an Excel sheet, attribute Format must be modified.
let formatEnum(KnowledgeReportFormatEnum)
formatEnum = "XLS"
generReport.Format = formatEnum

// Specify a sheet index to modify
generReport.SheetIndex = 4

generReport.DocGeneratedPath = "E:\\temp\\"

// Launch Generation
generReport.Generate()

// Popup to analyze outputs
Message("FullPath generated: #|ErrorCode: #|ErrorString: #|Format choosen: #", generReport.DocGeneratedFullPath,
generReport.ErrorCode, generReport.ErrorString, formatEnum)