October 27, 2014 at 5:14 pm
`I have a report that I've built with absolutely nothing special about it. When it displays on screen the rows alternate colors. When I export it to Excel, the rows also alternate colors. But there are row/column junctures that remain white. There seems to be no pattern. A particular column is shaded on most rows but here and there the coloring is white. It happens when there is no data in the column for that row, but again, only on a few rows. Why would this happen when on screen its just fine, and why is it only some columns on a row that this happens on.
November 18, 2014 at 5:43 am
In our case going from 2005 to 2012 we noticed a number of exporting to Excel issues. Here is something one of my college's found out.
"A bug found with reports after migrating to 2012 reporting services is when you export to excel from report manager, any time you have a column with conditional color formatting using “Trasparent”, “No Color”, or “Nothing”, excel will not change to that color appropriately. If you use “White”, however, it will work as intended. This only showed when exporting to excel from report manager. Any exports from visual studio to excel, or viewing of the report in visual studio or report manager didn’t show the color issue."
November 18, 2014 at 9:00 am
Heh... and people ask me why I use T-SQL to build HTML for my morning reports. We're going through our first setup of SSRS 2012 at work. There are more caveats and bugs than Carter has pills.
Sorry for the minor rant. I'm just totally disgusted with the tool.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2014 at 9:07 am
Yep, Jeff, we are also finding with a number of reports that now the rectangle properties can be all jacked up when trying to align things vertically and horizontally with other objects. Excel really stretches them out. Ugly....
November 18, 2014 at 7:06 pm
Is it Excel or SSRS doing that? Or, maybe, both?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply