Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The Difference in Time between two Events in same Group

Status
Not open for further replies.
Petilucas

Petilucas

MIS
May 1, 2017
2
US
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?

Capture_gnwaok.jpg
 
Status
Not open for further replies.

Similar threads

Tom_2023
  • Locked
  • Question
SSRS wrapping text in Excel
Replies
0
Views
330
Tom_2023
Tom_2023
nomi_ssrs
  • Locked
  • Question
xml column from sql server - used in ssrs
Replies
0
Views
315
nomi_ssrs
nomi_ssrs
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
300
Theresajn
Theresajn
arunaramana
  • Locked
  • Question
difference ways of creatin
Replies
1
Views
310
MarkSweetland
MarkSweetland
Priya Hari
  • Locked
  • Question
Row Grouping in Table of content
Replies
0
Views
312
Priya Hari
Priya Hari

Part and Inventory Search

Sponsor

Back
Top