Prev: Remove/hide Navigation-Search menu
Next: SSRS not Initialized and not sure why
From: greenmtnsun on 8 Mar 2010 16:04
In SSRS2005, the was a way to calculate how long a report took to run. I got
the formula here:
(http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx#UsefulFooter).
The formula works flaulessly in 2005, however in 2008 the formula changes
its behavior characteristics because of the way the rendering engine was
changed in 2008.

In 2005, when the report finished the calculation showed you how long it
took for the report to run.

In 2008, it does the same thing, but then it gets all messed up when you
interact with the report by things like hitting the next page, drill
throughs, etc.. In 2008, it basically tells you how long its been since the
report was first executed.

So if the report started to run at noon in 2008, and finished its processing
at 12:05, the formula says 5 minutes. When the user drills through the
report 5 minutes later, because they forgot to look at the window sooner, the
formula recalculates and shows you 10 minutes.

Does anyone know how to get the same result in 2008 as we did in 2005?

Thanks,
Keith

Execution Time ="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)",
""))
)

 | 
Pages: 1
Prev: Remove/hide Navigation-Search menu
Next: SSRS not Initialized and not sure why