Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Session Execution Time On Cached/Snapshotted Reports Expand / Collapse
Author
Message
Posted Monday, June 17, 2013 9:35 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:21 AM
Points: 55, Visits: 300
I am currently using the following in the footer of all reports.

="Execution Time: " +
IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).TotalSeconds < 1, "0 seconds",
(
IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours & " hour(s), ", "") +
IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes & " minute(s), ", "") +
IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds & " second(s)", ""))
)

Unfortunatly, this only show the cached time. We want to be able to show the user's session runtime in the report. Although this is captured in the executionlogview3 of the report server, there is not global variable to present this information.

Has anyone found a workaround to show the runtime of the user exection?
Post #1464220
Posted Wednesday, June 26, 2013 11:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 11, 2013 12:12 PM
Points: 2, Visits: 109
Beginning with SSRS 2008 R2, you can create a report variable and assign the execution time to the variable. That value will remain constant as long as the report is open - use a reference to the variable in your footer and you should get what you're after.
Post #1467795
Posted Wednesday, July 3, 2013 3:29 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:21 AM
Points: 55, Visits: 300
Stacia,
I tried what you suggested, but sadly the results are the same.
I created a variable call varExecutionTime, set it as read only and the value as Globals!ExecutionTime
Assigned the expression in the report footer to Variables!varExecutionTime.Value and the result is the same.
Are variables in report footers treated differently?
Post #1470252
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse