SQLTeam.com | Weblogs | Forums

Row Wise Balance


#1

Hi

I have below query and i want to display row wise Balance in SSRS 2008

Select A.[No_],
(select sum([Amount]) from [D $Detailed Cust_] where [Posting Date] < @frDate and [Customer No_] = @Cust) as OpgAmount,
B.[Document No_],B.[Posting Date],B.[Debit Amount] as DbAmount,(B.[Credit Amount]) as CrAmount FROM [D $Customer] as A inner join
[D $Detailed Cust_] As B on A.[No_] = B.[Customer No_]
where A.[No_] = @Cust and [Posting Date] between @frDate and @toDate

Thanks