Sunday, March 11, 2012

Change value displayed in last row in table?

I have a table which displays years (2007, 2006, 2005, etc.) as one of its fields. I need to have it display Year + " and prior" for the last row. Any thoughts on how I might do this? Thanks!

Hello,

Try this in your expression:

=Iif(CountRows("DataSetName") = RunningValue(1=1, Count, "DataSetName"), cStr(Fields!Year.Value) & " and prior", cStr(Fields!Year.Value))

Hope this helps.

Jarret

|||Great, that did it!

No comments:

Post a Comment