I have 4 tablix in this report. This particular column appears in 3 of the tables. If I set the TextAlign property to left alignment, it works fine. But if I set it to Right alignment then it become centered. This data field is from a dataset and it's a char(10) field. I then set the Format property to Trim(field) and that didn't make any difference either. I then set Direction property to RightToLeft and that didn't work either. Can anyone suggest something to fix this. Thanks.Lapucca

Well, Do a ltrim(rtrim(Field)) in your SQL and see if it works...Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Modify sp to rtrim (ltrim(r.EmpAccountNo)) and that didn't make a difference either. Very frustrating becuase all the other textboxes in all 4 tables formats to the right alignment except this textbox. I've also tried deleting the column and then insert the new column and add the data field to it and that doesn't work either. Thanks.Lapucca

Wait wait, Please do this ,i think its in char so wont get trimed Convert to Nvarchar first and on this put ltrim,rtim. rtrim (ltrim( CONVERT(nvarchar(10), r.EmpAccountNo))) My Money is on this, This should work :) Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Yeah, that column is char(10), I modified sp to rtrim (ltrim( CONVERT(nvarchar(10), r.EmpAccountNo))) as EmpAccountNo And still it's centered. (sigh....) Very frustrating. Thank you. Lapucca

Not sure what we are missing, lets cehck again - 1. You have right align propert set after nvarchar casting and triming 2. you dont have text box inside a text box 3. You dont have format expression in your value expression. 4.Your padding option are set properly, default its 2pt. i hope its not more than that, try making it zeroGaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi, this is a textbox that is in a cell of a tablix. The TextAlign property of the textbox is set to "Right". The triming and convert is done on the sp side. I had a formt expression to trim the field blank spaces but now I removed it. The padding to left and right was 6 ,now I set it to 2. With all that, the column text is still "Center". Thank you.Lapucca

Finally fixed the problem. I had to put Trim() in the value property of the textbox.I don't have to do this for other textboxes and why this one? Btw, I'm developing this report in B.I. .net 3.5. And, also, that I have already apply trim to my sp select statement. Very odd! rtrim (ltrim( CONVERT(nvarchar(10), r.EmpAccountNo))) as EmpAccountNo Thanks for your help though.Lapucca