Double underline a field SSRS 2008 R2 matrix

Question

i have an ssrs 2008 R2 matrix with Accounts on Rows, Months on Columns and Sales in the data section. I need to “double underline” the sales numbers but I can’t figure out how to do this.

i tried using “double border” but that would create one giant line across instead of just underlining the sales numbers - in other words, the display would be a single long line across.

any idea how to achieve this? i am willing to use custom code in the report code. Thanks in advance for your help.

Edit: Adding a screen shot to show the desired output:

Answer 1

For some reason the Double text box BorderStyle property seems to be rather temperamental.

This MSDN thread suggests a few requirements to get this running:

Double Line border turn to be single in Reporting Service

1. The border width must be 3pt at least.
2. There must be at least one row beneath the Double border text box.

Let's test this out. A simple tablix:

And let's set the bottom text box to be Double at the bottom:

In Preview this is unsuccessful:

Let's test out the suggestions. First, set the width to 3pt:

Same result:

Let's add an extra row below:

It works:

What's going on here? It seems like if the width is too low, the two lines will squash together. Also, it seems like the border actually spills to an adjacent text box, so if this doesn't exist the bottom line is not displayed.

Put them together and it works.

One more note - this is not required for Excel - just add a 1pt Double border and it will be fine. The above series of steps are only required for Web, PDF, etc.