January 9, 2008 at 6:49 pm
Hi
I am trying to format a report so that a cell has either left aligned or right aligned data based on a given value from another cell. I have been successful in making the cell changed font wight and padding but I can't seem to get some cells left aligned and some right aligned.
I have tried the following below:
=iif(right(Fields!RowOrder.Value,1) = 0, "Right","Left")
I have used similar code above to set the font weight for the cell and it works fine.
Can anyone help me?
Thanks in advance.
March 17, 2008 at 11:04 am
The only thing I can see wrong with this is the part that says Right(Fields!RowValue.Value,1)=0.
The question is, what is the data type for the field RowValue.........
If its an NVARCHAR data type then your comparison should be ="0"
If its an INT or other number value then I'm not sure that the Right(... function will work at all !!
More information needed i'm afraid.
Nigel.
Nigel West
UK
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply