Post reply

Calculating Average Time Expression for Reporting Services 2005

  • October 30, 2009 at 8:37 am

    #211579

    Hello,

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

    The following formula is not working

    [font="Arial Narrow"]

    =AVG(

    TimeSerial(

    Cint(LEFT(Fields!StrRunDuration.Value,2)),

    Cint(MID(Fields!StrRunDuration.Value,4,2)),

    Cint(RIGHT(Fields!StrRunDuration.Value,2))

    )

    )

    [/font]

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

    can anyone help?

    Kindest Regards,

    egpotus DBA

  • October 17, 2013 at 6:45 am

    #1659290

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply