I have a report that is configured in a script. The report is generated to a PDF via the system.report.executeAndDistribute() function. This report works in Reports Preview in the Designer:
But when the report is triggered in script, the final PDF has the correct data but the span of the chart doesn’t match the times as the preview does:
I’ve checked everywhere in this forum, and elsewhere online, but I can’t seem to figure out why this happens. I expect it is the difference between the actual report and creating it using executeAndDistribute(). I hope someone here can help.
Below is the script that generates the PDF report:
#Get parameters for the report
kilnNum = event.source.parent.KilnNum
chargeNum = event.source.parent.ChargeNum
startDate = event.source.parent.getComponent('ChargeGraph').startDate
endDate = event.source.parent.getComponent('ChargeGraph').endDate
endDateStr = system.date.format(endDate, "yyyy-MM-dd")
#Configure report name & location
path = "C:\KilnReports\K" + str(kilnNum)
fileName = endDateStr + "_" + str(chargeNum) + "_" + "K" + str(kilnNum)
#Create report
settings = {"path":path, "fileName":fileName, "format":"pdf"}
params = {"KilnNum":kilnNum, "ChargeNum":chargeNum, "StartDate":startDate, "EndDate":endDate}
system.report.executeAndDistribute(path="KilnChargeReport", project="BDK_Kilns", parameters=params, action="save", actionSettings=settings)
Thanks in advance.