question

Mayank-Pandey avatar image
0 Votes"
Mayank-Pandey asked Mayank-Pandey edited

SSRS Horizontal and vertical tablix border line issue.

I have a requirement in SSRS, the report should have a table with a horizontal border color (Gray) and vertical border color (white) with 3pt border width.

The problem I have is that the white line is getting overlapped by the gray border of the table(and its cells) ,but what I need is white line should overwrite gray line or we can say white line should be in front.

The control used is a Tablix. The workaround we have is to make the whole report horizontally Gray and vertically white color, but I'm just asking this to see if there is a way to implement same in a proper way.

Please find attached images for reference, ssrs1.jpg is what I need to implement.


134880-ssrs.jpg


134907-ssrs1.jpg


sql-server-reporting-services
ssrs.jpg (27.4 KiB)
ssrs1.jpg (34.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @Mayank-7996 ,
Do you mean that the horizontal and vertical lines in Tablix cannot overlap? One of the colors is separated by the other.
This is by design, when you set the border width to a larger value, the performance becomes more obvious. The border color is presented in Tablix from left to right and top to bottom. The border on the right will cover the border on the left column, and the border on the next row will cover the border on the previous row.
If I misunderstand what you mean, please feel free to correct me.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Joyzhao-MSFT,
Thanks for reply, I edited my question for better understanding it was little confusing earlier.
Best Regards,
Mayank

0 Votes 0 ·

Hi @Mayank-Pandey
I think this is just the effect of different Rendering Extensions. The phenomenon you are currently experiencing is by design. You may not be able to make any settings to change this phenomenon. When I export the report to Excel and Word format, the rendering effect is different from the preview in the report designer. When I export to PDF format, the rendering effect is the same as when previewing in the report designer, that is, it is consistent with the rendering of your report.

Export to Excel:

134964-01.jpg

Export to Word:

134927-02.jpg
Best Regards,
Joy


0 Votes 0 ·
01.jpg (42.3 KiB)
02.jpg (13.7 KiB)