SSRS 2005 Matrix and border styles when exporting to XLS
Posted
by Mufasa
on Stack Overflow
See other posts from Stack Overflow
or by Mufasa
Published on 2008-09-16T22:42:41Z
Indexed on
2010/06/01
6:43 UTC
Read the original article
Hit count: 709
The Matrix in SSRS (SQL Server Reporting Services 2005) seems to have issues with certain the border styles when exporting to XLS (but not PDF or web view; maybe other formats, not sure?).
For example: Create a matrix and set the Matrix border style to Black Solid 1px, but all 4 of the cells to have a border style of Black None 1px. When viewed via the ASP.NET control, it looks correct. But after export to XLS, it creates borders around all of the header cells (column and row headers, and the top left cell), and even the right most data column. But all the cells in the middle of the report correctly have no border set.
Update:
If the Matrix borders are set to None, then the borders on the cells don't show up in XLS. So, how do you set an outer border around the Matrix, but not have it apply the 'all sides' border to every cell that touches the edge of the Matrix when exported to Excel?
© Stack Overflow or respective owner