Export to excel row colors

Question

Export to excel row colors

briantallon

SSC Enthusiast

Points: 152
More actions
October 27, 2014 at 5:14 pm

#291861

`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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 1

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."

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 2

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 3

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....

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 4

Is it Excel or SSRS doing that? Or, maybe, both?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)