Report execute and distribute parameters

Ignition
1

I have a report with multiple parameters. Some of the parameters are dependent on previously defined parameters.
For instance: Duration = minutesBetween({StartDate},{EndDate})
This works fine when running the report on a schedule. However, when running the report using system.report.executeAndDistribute() and passing the StartDate and EndDate parameters in, the calculated parameter “Duration” is not calculated.

2

Hmm… that’s certainly not what I expect.

What version are you running?

3

I am running 7.9.7 (need more characters before I can reply…)

4

Sorry it took me a couple of days to get back to this. I can’t replicate this in 7.9.9, and nothing in this code has changed since 7.9.7. You’ll need to double check your script, and perhaps contact support for help on this.

5

Did you ever solve this problem? I’m having the same exact problem on 8.0

6

I worked around it by querying my data for the StartDate and EndDate and then calculated the duration using:
system.date.minutesBetween(StartDate,EndDate)

1 Like