sql server reporting services: compare row with previous row value in RDL -- sql server reporting services

compare row with previous row value in RDL

BALAJI K via SQLMonster.com
9/26/2005 12:40:40 PM

sql server reporting services: Hi All,

I have a table, which displays the rows binded, now I need to compare a
textbox value in the table with the previous value and if matches then I need
to display the text box values with paranthesis [value].

How do I compare values in the RDL

Thanks in advance
Balaji

--
Message posted via SQLMonster.com

Re: compare row with previous row value in RDL

Robert Bruckner [MSFT]
9/26/2005 4:20:43 PM

Not sure if this works in your case, but if you just need to get the
previous value in a table detail row, you could use the Previous(...)
aggregate function.
E.g. =iif(Fields!A.Value = Previous(Fields!A.Value), "(" & Fields!A.Value &
")", Fields!A.Value)

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

[quoted text, click to view]