Calculate and Display Time Interval in Report Studio

[bryan1230]

Hi there,

In Report Studio 10, I have two date fields that I'm comparing in order to determine the interval between - looking to display how much time elapsed between two events. One event date/time is from a "master" record; the second is from a "child" record, identified using the "minimum" function to determine the earliest created child record.

The expression is pretty basic:  [ChildDateTime] - [MasterDateTime]    note:  child will always be after master

When I run the query to view tabular data, I get this output:

4 days 0 hours 59 minutes 24 seconds
7 hours 56 minutes

This is perfect; exactly what I want, and what needs to be displayed on report. When I place into a report, and run it natively within Report Studio, it displays as expected/desired.

However, when I save the report and run it in batch from outside RS, I get different values:

4 milliseconds
0 days

I've tried changing the data format of the column in the report layout, and a number of other ways to try and force it to preserve the original interval format. It seems as though the days/hours/minutes/seconds portion of the interval is getting lost, but I can't, for the life of me, determine why. I did try explicitly displaying hours/days/minutes/seconds in interval format in the report, but they all displayed a value of 0; only milliseconds displayed a value. I've searched this forum a lot and in general, but cannot find any similar examples.

Any ideas? Your assistance is greatly appreciated. Thank you.

Bryan