I have a report that is grouped by account number and each account having two events in the details, I want to calculate the difference in time between event 1 and event 2.
I have the Start and End times of these events and I know that it should be:
event1.EndTime minus even2.StartTime = my difference in minutes.
But I am not sure how to build this into my ssrs report . Any suggestions?