sql server reporting services: Expression for Running Total -- sql server reporting services

You're in the

sql server reporting services

group:

Expression for Running Total

bak
5/26/2005 11:41:32 AM

sql server reporting services: I want to write an expression where the running total should be
calculated if the previous value for a column(invoice code) is not
equal to the current value for the invoice code.

The expression should be something like this:

iif( current invoice code is not equal to the previous invoice
code,sum(payment),0)

How can I compare the current and previous value of a column in the
expression?

In Crystal we can say calculate running total with the change of
Invoice Code in the Edit Running Total Field Box. Trying to do the same
concept in RS where the running total should be calculated with the
change of invoice code.

Please help!
Thanks

Re: Expression for Running Total

Robert Bruckner [MSFT]
5/26/2005 12:42:36 PM

I think you just need to add a (table) grouping to your data (based on
InvoiceCode). In the group header you would do the calculation of the total
payment. In the group details you can show the invoice detail rows.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Expression for Running Total

bak
5/27/2005 6:14:41 AM

This did not help. The solution to my problem is to write an
expression where if the current invoice code is not equal to the
previous invoice code then calculate sum. I am unable to find a VB.NET
function which helps me do this.

Can anyone tell me some good sites where I can get information about
all the VB.NET functions that can be used in Reporting Services. I
have been looking for the function in VS.NET documentation but unable
to find something that could help me compare the current and previous
value of a column.

Thanks.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn