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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy