11

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

Cœur
  • 37,241
  • 25
  • 195
  • 267
misterManager
  • 1,174
  • 4
  • 12
  • 33
  • 1
    For anybody looking at this... I've been able to go in and directly edit the XML to get the desired results. But I would still like to know how I can get SSRS to actually work properly. I would like to know if it is just me or if anybody else has noticed this type of a situation. – misterManager Jul 16 '12 at 17:58

1 Answers1

20

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.

misterManager
  • 1,174
  • 4
  • 12
  • 33
  • 1
    Unbelievable. I had this problem 6 years later. I know little about this terrible report designer (that I have no choice but to use) and I was tearing my hair out. Thanks! – Rob3C Aug 24 '18 at 20:00
  • 1
    haha. glad it could help. sorry you've found yourself working on it. i am mercifully working in other areas now-a-days – misterManager Aug 24 '18 at 20:24
  • 2
    7 years later this is still the solution, and Microsoft has yet to fix the bug. – MPJ567 Jul 08 '19 at 15:51