SQL Server Performance

create account balance

Discussion in 'SQL Server 2005 Reporting Services' started by okboy, Aug 15, 2007.

  1. okboy New Member

    how to use SRSS to create account balance?
    example :
    DEBIT CREDIT Balance
    500 500
    200 700
    300 400
    the depit and credit i already use sql query to display it, now just the balance dont know how to use SRSS to do.
    so somebody can help?
    okboy, Aug 15, 2007
    #2

  2. satya Moderator

    satya, Aug 16, 2007
    #3

  3. dineshasanka Moderator

    you can create a data set with running total. Following is an example.
    select
    SalesOrderId, OrderDate=convert(char(10),OrderDate,111), TotalDue,[Running Total]from
    Sales.SalesOrderHeader sohCROSS APPLY
    (
    select [Running Total]=sum(TotalDue) from Sales.SalesOrderHeaderwhere
    SalesOrderID <= soh.SalesOrderIDand
    year(OrderDate)=2001 and month(OrderDate)=7) as RTwhere
    year(OrderDate)=2001 and month(OrderDate)=7order
    by OrderDate;
    dineshasanka, Aug 17, 2007
    #4

  4. okboy New Member

    thank you all your reply....[:)]
    this is my writing methods, it can run successfully...!!RunningValue(Fields!Debit.Value, sum, nothing) - RunningValue(Fields!Credit.Value, sum, nothing)
    okboy, Aug 27, 2007
    #5

  5. dineshasanka Moderator

    oh yes I forgot the RunningValue function in SSRS
    dineshasanka, Aug 28, 2007
    #6

Share This Page