{"id":777,"date":"2014-07-11T02:15:33","date_gmt":"2014-07-11T02:15:33","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=777"},"modified":"2022-02-03T11:25:01","modified_gmt":"2022-02-03T17:25:01","slug":"report-services-export-to-excel-tips-ssrs-rs","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/","title":{"rendered":"Report Services Export to Excel Tips"},"content":{"rendered":"<p>First, I am using RS 2008 &#8211; not SP1 or anything. This is quite frustrating but I know 2014 is coming soon (many old bugs fixed), but alas, here are some tips of things that I am struggling with and others have too.<\/p>\n<h2>Use Consistent Units<\/h2>\n<p>First, if you are getting extra columns and\/or rows and you want contiguous (no hidden ones) in between &#8211; make sure ALL YOUR UNITS ARE THE SAME. Use inches with inches and cm with cm&#8217;s. Also align the &#8220;top&#8221; and &#8220;left&#8221; numbers to 0&#8217;s when possible. The main point is use numbers like 1.7in or 3.5cm and not 1.45235in. If you get numbers like that AND you did align (snap) to other objects, most likely something is in another unit that you are snapping to &#8211; or that IT is aligned to.<\/p>\n<h2>Headers not consistent when exporting to Excel<\/h2>\n<p><a href=\"http:\/\/social.msdn.microsoft.com\/Forums\/sqlserver\/en-US\/52722c38-a767-470f-8a12-dd3bc417d1eb\/row-height-not-preserved-when-exporting-to-excel?forum=sqlreportingservices\" target=\"_blank\" rel=\"noopener noreferrer\">This guy has the key<\/a>. Use Can Grow and Can Shrink to &#8220;False&#8221;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First, I am using RS 2008 &#8211; not SP1 or anything. This is quite frustrating but I know 2014 is coming soon (many old bugs fixed), but alas, here are some tips of things that I am struggling with and others have too. Use Consistent Units First, if you are getting extra columns and\/or rows [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-777","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Report Services Export to Excel Tips - ELB Solutions.com Inc.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Report Services Export to Excel Tips - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"First, I am using RS 2008 &#8211; not SP1 or anything. This is quite frustrating but I know 2014 is coming soon (many old bugs fixed), but alas, here are some tips of things that I am struggling with and others have too. Use Consistent Units First, if you are getting extra columns and\/or rows [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-11T02:15:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:25:01+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"Report Services Export to Excel Tips\",\"datePublished\":\"2014-07-11T02:15:33+00:00\",\"dateModified\":\"2022-02-03T17:25:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/\"},\"wordCount\":164,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/\",\"name\":\"Report Services Export to Excel Tips - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2014-07-11T02:15:33+00:00\",\"dateModified\":\"2022-02-03T17:25:01+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/report-services-export-to-excel-tips-ssrs-rs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Report Services Export to Excel Tips\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Report Services Export to Excel Tips - ELB Solutions.com Inc.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/","og_locale":"en_US","og_type":"article","og_title":"Report Services Export to Excel Tips - ELB Solutions.com Inc.","og_description":"First, I am using RS 2008 &#8211; not SP1 or anything. This is quite frustrating but I know 2014 is coming soon (many old bugs fixed), but alas, here are some tips of things that I am struggling with and others have too. Use Consistent Units First, if you are getting extra columns and\/or rows [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2014-07-11T02:15:33+00:00","article_modified_time":"2022-02-03T17:25:01+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"Report Services Export to Excel Tips","datePublished":"2014-07-11T02:15:33+00:00","dateModified":"2022-02-03T17:25:01+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/"},"wordCount":164,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/","url":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/","name":"Report Services Export to Excel Tips - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2014-07-11T02:15:33+00:00","dateModified":"2022-02-03T17:25:01+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/report-services-export-to-excel-tips-ssrs-rs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"Report Services Export to Excel Tips"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=777"}],"version-history":[{"count":4,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/777\/revisions"}],"predecessor-version":[{"id":2800,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/777\/revisions\/2800"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}