SSRS 2008 Running Value Function

  • Hi,

    I am trying to calculate running total by order using SSRS 2008. When i pass following code to SSRS reports getting errror.

    I am using simple program to calculate running total (RTTL fieldname)by order.

    Calculated fieldname is RTTL

    = RunningValue(Field!Orderamt.value,Sum,Nothing)

    getting errro.

    When i am using Dataset

    = RunningValue(Field!Orderamt.value,"Dataset1") getting the same error

    When i am using groupname getting the same error.

    Can somebody provide the details how to resolve this issue in SSRS 2008.

    Thanks

    A S

  • Hi,

    ur expression

    = RunningValue(Field!Orderamt.value,Sum,Nothing)

    is correct.. confirm me about your calculated field RTTP?? i couldnt understand ur point..

    Regards,
    Gayathri 🙂

  • Hi Gayatri,

    RTTL is calulated field associate with Dataset and having expression defined to calculate the running total using formula =Runningvalue(field.value,Sum,nothing)

    When i am running my report getttng the error.

    Please provide the solution.

    Thanks

    AS

  • gayathridevi.msit (7/15/2010)


    Hi,

    ur expression

    = RunningValue(Field!Orderamt.value,Sum,Nothing)

    is correct.. confirm me about your calculated field RTTP?? i couldnt understand ur point..

    you are right... thats correct:-):cool:

  • mbsquery (7/15/2010)


    Hi Gayatri,

    RTTL is calulated field associate with Dataset and having expression defined to calculate the running total using formula =Runningvalue(field.value,Sum,nothing)

    When i am running my report getttng the error.

    Please provide the solution.

    Thanks

    AS

    is above issue solved?

    if not please let me know the error may i can help

    as i have done a lot RND on Runningvalue as it was required in one of the reports for me.:w00t:

Viewing 5 posts - 1 through 4 (of 4 total)

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