Export report data

Ignition
1

Hello, trying to export data from a report between 2 times. it produces data but not between the times I select.
the report displays data for each hour. the report always gets todays data even with a date range of a different day.
thanks

=============================================================================

overrides = {“event.source.parent.getComponent(‘Report Viewer’).StartDate”:“event.source.parent.StartDate”, “event.source.parent.getComponent(‘Report Viewer’).EndDate”:“event.source.parent.EndDate”}

csv = system.report.executeReport(path=event.source.parent.getComponent(‘Report Viewer’).reportPath, project=“MainSorter”, parameters=overrides, fileType=“csv”)

reportID = event.source.parent.getComponent(‘Report Viewer’).reportPath
filePath = system.file.saveFile(reportID, “csv”, “Comma Separated Values”)

if filePath:
system.file.writeFile(filePath, csv)

2 
overrides = {"StartDate":event.source.parent.StartDate, "EndDate":event.source.parent.EndDate}

csv = system.report.executeReport(path=event.source.parent.getComponent('Report Viewer').reportPath, project="MainSorter", parameters=overrides, fileType="csv")

reportID = event.source.parent.getComponent('Report Viewer').reportPath
filePath = system.file.saveFile(reportID, "csv", "Comma Separated Values")

if filePath:
	system.file.writeFile(filePath, csv)
3

Wow, that worked. So leaving off the entire path to the start/end properties was the key?
Thank you very much :slight_smile:

4

You also constructed your overrides with quoted strings. Quoted strings are constants–they don’t execute.