Gaps in borders between columns...

I have a row in my report that has 6 columns. I want to outline the row with a border, but not the column lines in between. So, I went into BorderColor, changed the Default to white and my Top and Bottom colors as Black. The problem is that where the "white" column lines are, they are displaying 1pt gaps in my outline. I tried changing the BorderStyle to Zero, but it wouldn't take it.

See sample of the report here.

Any ideas?

Thanks,

James H.

I always had problems in formatting these kind of things. You will have to try different possibilities to get this right. Sometimes, It looks different on preview when compared to the ones when deployed. Try changing the Border style, and try chaning the border color of the columns, Good Luck|||

Hii

For this you can merge the cells in the row,then put one rectangle over there. then according to the width of each column put the text boxes inside the rectangle without giving any border style for the text boxes.finally give the top and bottom border for the whole rectangle.

Hope this works fine

Thanks

Mahasweta

|||

>> I tried changing the BorderStyle to Zero but it wouldn't take it

I assume you mean BorderWidth here...

You're right, you can't put in 0. But you can do this:

=IIF(false,1,0)

This, plus a BorderStyle of None, for each column, seems to do what you want... not 100% positive but it looks right, check it out...

>L<

|||This would work, but gets jacked up when exporting out to excel.|||

I ended up getting some help on this from a thread on sqlservercentral.com.

This is what I had to do to get a top and bottom border (no left or right borders) without the gaps in the top and bottom borders...

BorderColor

Default = White Left = White Right = White Top = Black Bottom = Blacksql