January 21, 2011 at 1:43 pm
I am building a report that currently has one dataset ordered by ID that gives these results
ID Start Time End Time
1 1/17/2011 9:00 AM 1/17/2011 9:52 AM
2 1/17/2011 10:00 AM 1/17/2011 10:50 AM
This is all fine, but I am wanting to calculate the time between the End of the previous ID and the start of the Current ID
So it needs to look like this:
ID Start Time End Time Time Between ID
10 1/17/2011 9:00 AM 1/17/2011 9:52 AM =ID10 StartTime - ID9 EndTime
11 1/17/2011 10:00 AM 1/17/2011 10:50 AM =ID11 StartTime - ID10 EndTime
What is the best way to go about this? A second Dataset? Custom Code? I am farily new to SSRS. Any help is appreciated!
May 10, 2011 at 4:41 pm
sethmo38 (1/21/2011)
I am building a report that currently has one dataset ordered by ID that gives these results
ID Start Time End Time1 1/17/2011 9:00 AM 1/17/2011 9:52 AM
2 1/17/2011 10:00 AM 1/17/2011 10:50 AM
This is all fine, but I am wanting to calculate the time between the End of the previous ID and the start of the Current ID
So it needs to look like this:
ID Start Time End Time Time Between ID
10 1/17/2011 9:00 AM 1/17/2011 9:52 AM =ID10 StartTime - ID9 EndTime
11 1/17/2011 10:00 AM 1/17/2011 10:50 AM =ID11 StartTime - ID10 EndTime
What is the best way to go about this? A second Dataset? Custom Code? I am farily new to SSRS. Any help is appreciated!
In the textbox with the Time Between ID, you would have a formula similar to this:
= Fields!StartTime.Value - Previous(Fields!EndTime.Value)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply