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

Calculating Average Time Expression for Reporting Services 2005 Expand / Collapse
Author
Message
Posted Friday, October 30, 2009 8:37 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:11 AM
Points: 128, Visits: 1,135
Hello,

I am looking for a SSRS formula to compute average time.

The following formula is not working


=AVG(
TimeSerial(
Cint(LEFT(Fields!StrRunDuration.Value,2)),
Cint(MID(Fields!StrRunDuration.Value,4,2)),
Cint(RIGHT(Fields!StrRunDuration.Value,2))
)
)



Fields!StrRunDuration is like 'HH:MM:SS'

can anyone help?



Kindest Regards,

egpotus DBA

Post #811641
Posted Thursday, October 17, 2013 6:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, Visits: 215
Hi,

I am looking for the same thing. I saw a blog where a developer said that this is a limitation of SSRS e.g. SSRS is incapable of this. It looks like we will have to do this in T-Sql. I am continuing my research however.
Post #1505675
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse