compare row with previous row value in RDL

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
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1Not 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.
"BALAJI K via SQLMonster.com" <u5178@.uwe> wrote in message
news:54f11b486df84@.uwe...
> 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
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1