SSRS- TextBox Border Width property reverting to 1pt after saving expression

misterManager picture misterManager · Jul 16, 2012 · Viewed 9.8k times · Source

I've been working on this for the last couple hours. I placed the following code into the textbox Border Width Property (this applies to a table not a matrix):

=IIF(Fields!SortOrder.Value = 2,"3pt","1pt")

Once I click OK on the expression editor and OK on the Text Box Properties editor, I can go back into the properties, and the Border Width property is again set to the default 1pt.

After playing around with it for a very long time I finally started getting the text box to behave the way I wanted, but the property was still set incorrectly. However the XML of the report showed it being set with the above expression. So SSRS wasn't properly parsing the XML until the run-time of the report (at least that's what I'm assuming). I have been able to set the Bold property on the same text box and all other text boxes within that row. However, all of the properties in the Border section of the TextBox property list seem to reset themselves. I've only had on occurrence of the report actually doing what I wanted (as mentioned above), but the property displayed through SSRS was still incorrect. I guess I need a way to trigger SSRS to reprocess the XML.

Things I have tried:

-closing and reopening report

-closing and reopening solution

-closing and reopening Visual Studio

-restarting computer

Answer

misterManager picture misterManager · Jul 16, 2012

I have found the answer!

I was getting to the properties by right-clicking on the Text-Box and selecting "Text Box Properties". However, if I open the properties side window (View->Properties Window... or press F4), I see all of the properties I was setting via XML.

Basically, there are two places to find the properties and you want to go with the side-bar one. The right-click menu appears to be a simplified set of properties.

I was able to set specifically the width of the top border for a set of text boxes and I got the look I wanted. Thanks for anyone who looked at this and I hope this helps anyone else who has a similar issue.