Blogs

.NET to SQL to Project Server and everything in between
Welcome to Blogs Sign in | Join | Help
in Search

Strate SQL

SSRS Exporting to Excel

Exporting from SSRS to EXCEL is not as seamless as one would hope.  I've run into a few issues that have been spicing up my life.
  1. The EXCEL renderer has a footer limitation of 255 characters.  So any nifty footer on the report with instructions and such most likely will not get exported.
  2. Some web safe colors don't export properly.  For instance Pink (#FFCCFF) exports as Yellow (#FFFFCC).
  3. In some cases tables and textboxes don't play nice and even when sized to the same size through properties EXCEL will throw in an extra zero-lengthed column or three.  Fortunately this little goodness is a always favorite to the end-user.
Oh, well... can't win them all.
Published Friday, August 04, 2006 11:19 AM by Jason
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server, by Telligent Systems