Project Mgr
I need help translating this IIF statement
=IIf(Previous(Fields!DIMENSION.Value) = Fields!DIMENSION.Value, Space(1), Fields!DIMENSION.Value)
March 23rd, 2011 7:55pm
If Previous(Fields!DIMENSION.Value) = Fields!DIMENSION.Value -- previouse row, column DIMENSION value = current row DIMENSION value
Then Space(1) ---- if true, then put a space
Else Fields!DIMENSION.Value --- if not match, then put current value
If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
http://twitter.com/7Kn1ghts
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 8:02pm