Border settings not saving in SSRS

This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer.

My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would show for empty spaces.

I wasn't getting very far because I'd even ask the border to be grey and save the project but when I come back to the setting, it's still black.

I found that you have to select a color or expression first, then define which border (top, right, bottom, left) the settings apply to...

Mad. 1. Type your expressions/specify color first:

2. Specify which border of the cell this applies to:

Category: SQL Server Reporting Services :: Article: 331

Comments

Not rated
TonyH
0
TonyH
3 months ago
Great tip !
I have been fighting this for hours.
Bravo Zulu
Like Like
Reply | Reply with quote | Quote
Saravanapandian
0
Saravanapandian
12 years ago
Open that report file in notepad and give your condition and save. Now the condition will save and report also will work.
Ex :

=iif(Parameters!ReportParameter1.Value = 2,"Solid","None")
Like Like
Reply | Reply with quote | Quote
yuval
0
yuval
12 years ago
not silly at all... very helpfull! thanks!
Like Like
Reply | Reply with quote | Quote
Mike
1
Mike
14 years ago
I tried following your instructions but my expressions still are not getting saved.
Like Like
Reply | Reply with quote | Quote
View replies
WebmasterLegacy
2
WebmasterLegacy
14 years ago
Hi Mike,

Thank you for your message.

The border settings only save per object and not well if these are all expressions. Set the borders for something else and your report builder/BIDS will not remember what style you wanted.

Another thing is that it isn't obvious if the border settings have saved. Usually if you just click on the border buttons it will remember what style you specified originally but it doesn't display what this style is (whether expressions or colors).

The point of this article is saying how border settings have to be specified before applying these (perhaps obvious to some) and that you have 1 preset setting available: the one you just set.

Hope that helps!

Joe
Like Like
Reply | Reply with quote | Quote

Add comment

Your rating:

Submit

Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Accreditation

Badge - Zoho Creator Certified Developer Associate
Badge - Zoho Deluge Certified Developer
Badge - Certified Zoho CRM Developer

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.