# Report Scripting

**URL:** <https://forum.inductiveautomation.com/t/report-scripting/17705>\
**Category:** Ignition\
**Tags:** ignition79, scripting\
**Created:** [April 13, 2018, 2:40pm UTC](https://forum.inductiveautomation.com/t/report-scripting/17705 "2018-04-13T14:40:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bprice](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bprice/32/83520_2.png) [@bprice](https://forum.inductiveautomation.com/u/bprice)\
**Post date:** [April 13, 2018, 2:40pm UTC](https://forum.inductiveautomation.com/t/report-scripting/17705/1 "2018-04-13T14:40:59Z")

</div>

I’m drawing a blank on writing a script in a report and can’t seem to find anything online. I’m trying filter downtimes that are greater than 2.0 minutes with a checkbox. I have the parameter for the checkbox in the report as Notes. When the checkbox is selected on the window, I am wanting the report to show all the downtimes. When the checkbox is unchecked I am wanting only the downtimes that are greater than 2.0 minutes to appear.

```
line = data["Line"]
area = data["Area"]
site = data["Site"]
settings = system.production.createAnalysisSettings()
settings.setAnalysisProvider("Downtime")
settings.addFilter("StartDate", system.db.dateFormat(data["StartDate"], "yyyy-MM-dd HH:mm:ss"))
settings.addFilter("EndDate", system.db.dateFormat(data["EndDate"], "yyyy-MM-dd HH:mm:ss"))
settings.addFilter("Line", line)
settings.addFilter("Area", area)
settings.addFilter("Site", site)
settings.addCompareBy("Line")
settings.addCompareBy("Area")
settings.addCompareBy("Site")
settings.addDataPoint("Line")
settings.addDataPoint("Area")

resultData = []
results = system.production.getAnalysisResults(settings)
for row in system.dataset.toPyDataSet(results.getTableResults()):
	line = row["Line"]
	area = row["Area"]
	
	settings = system.production.createAnalysisSettings()
	settings.setAnalysisProvider("Downtime")
	settings.addFilter("StartDate", system.db.dateFormat(data["StartDate"], "yyyy-MM-dd HH:mm:ss"))
	settings.addFilter("EndDate", system.db.dateFormat(data["EndDate"], "yyyy-MM-dd HH:mm:ss"))
	settings.addFilter("Line", line)
	settings.addFilter("Area", area)
	settings.addCompareBy("Downtime Event")
	settings.addCompareBy("Factor:Shift Rotation")
	settings.addCompareBy("Cell Name")
	settings.addCompareBy("Reason")
	settings.addCompareBy("Area")

	if data["Notes"]:
		settings.addFilter("Note", "Include")
			
	else:
		settings.addFilter("Note", "Exclude Default")

	settings.addDataPoint("Note")
	settings.addDataPoint("Downtime Minutes (Time Format)")
	settings.addDataPoint("Downtime Minutes")
	settings.addDataPoint("End Time")
	tableData = system.production.getAnalysisResults(settings).getTableResults()

	
	resultData.append([line, tableData])
	
	

	data['RunData'] = system.dataset.toDataSet(["Line", "TableData"], resultData)
```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 13, 2018, 3:18pm UTC](https://forum.inductiveautomation.com/t/report-scripting/17705/2 "2018-04-13T15:18:15Z")

</div>

A couple notes, without diving in deep:

- Your final assignment to `data['RunData']` is indented, making it part of your loop. Only the last iteration will be kept.

- You’ve re-used the `line` and the `area` variable names for different purposes. I didn’t look further to see what that breaks.