Is it possible to change the time zone when generating a report? I'm going to be generating reports for multiple sites in different time zones and I'd like the report to display times in the time zone appropriate for the site, not necessarily that the gateway generating the report.
For example, if I fetch data from the historian, the t_stamp column uses the project's Timezone Behavior property when previewing in the Designer. I assume if the report is triggered by a schedule or a script, it will use that of the gateway.
I'd like to avoid having to figure out the difference in time zone offsets for two sites and applying that myself any time there is a t_stamp column. Also, if that's not possible, the X and Z date format elements can't be used.