{"id":438,"date":"2013-01-11T09:00:04","date_gmt":"2013-01-11T16:00:04","guid":{"rendered":"http:\/\/www.sqldbpros.com\/?p=438"},"modified":"2013-01-11T14:47:33","modified_gmt":"2013-01-11T21:47:33","slug":"ssrs-a-hidden-tablix-that-wont-hide-and-wham","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2013\/01\/ssrs-a-hidden-tablix-that-wont-hide-and-wham\/","title":{"rendered":"SSRS: A Hidden Tablix That Won&#8217;t Hide And Wham!"},"content":{"rendered":"<p>Here's a real quick tip after banging my head against the desk for awhile. I had a tablix in SSRS that was supposed to be hidden if there were no rows. It was working fine until, wham, it stopped working. (Oh no. I said \"wham\". That obviously leads me to \"Wham!\". I had my mom blasting that cassette on the way to elementary school every day for months.)<\/p>\n<figure id=\"attachment_439\" aria-describedby=\"caption-attachment-439\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.amazon.com\/gp\/product\/B00000261P\/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&amp;tag=grocwine-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=B00000261P\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-439 \" alt=\"SSRS would be cooler if more developers had feathered hair...\" src=\"http:\/\/www.sqldbpros.com\/wordpress\/wp-content\/uploads\/2013\/01\/HiddenTablixTakesUpSpace.jpg\" width=\"300\" height=\"300\" srcset=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2013\/01\/HiddenTablixTakesUpSpace.jpg 300w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2013\/01\/HiddenTablixTakesUpSpace-150x150.jpg 150w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-439\" class=\"wp-caption-text\">SSRS would be cooler if more developers had feathered hair...<\/figcaption><\/figure>\n<p>Alright, so it was working great using the following technique:<\/p>\n<ol>\n<li>Select the tablix.<\/li>\n<li>Go to properties (F4).<\/li>\n<li>Under \"Visibility\" set \"Hidden\" to: \"=iif(CountRows(), False, True)\"<\/li>\n<\/ol>\n<p>That's it. Easy. Then tragedy struck. I made a small mod and the tablix remained hidden when there weren't any rows *but* it continued to take up space on the report, leaving a large blank section.<\/p>\n<p>Arrrgh! I felt as though I had given SSRS my heart and they very next day it gave it away... (yes, that was another Wham! reference).<\/p>\n<p>After wearing out Google with repeated searches I ended up having to roll back to a previous version, and incrementally make my changes until the problem reoccurred. With the help of our local SSRS wizard we were able to pinpoint the issue.<\/p>\n<p>One of my changes had increased the height of a row in the tablix. This had the effect of pushing the tablix down to the point it was slightly overlapping a text box below the tablix. In the words of our Reporting Services wizard: \"SSRS doesn't like it if you overlap things.\".<\/p>\n<p>Moving the text box down slightly so it was no longer being overlapped solved the problem.<\/p>\n<p>Now SQL Server Reporting Services is once again putting the boom boom into my heart. (Yes, that was <a href=\"http:\/\/www.amazon.com\/gp\/product\/B00000261P\/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&amp;tag=grocwine-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=B00000261P\" target=\"_blank\">Wham!<\/a> again and yes that was contrived).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here's a real quick tip after banging my head against the desk for awhile. I had a tablix in SSRS that was supposed to be hidden if there were no rows. It was working fine until, wham, it stopped working. (Oh no. I said \"wham\". That obviously leads me to \"Wham!\". I had my mom [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,43,58],"tags":[35,20,34,10,60,59,103,102],"class_list":["post-438","post","type-post","status-publish","format-standard","hentry","category-businss-intelligence","category-microsoft-sql-server","category-ssrs-reporting-services","tag-best-practice","tag-business-intelligence","tag-development","tag-ms-sql","tag-reporting-services","tag-ssrs","tag-tablix","tag-wham"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/438","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=438"}],"version-history":[{"count":4,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/438\/revisions"}],"predecessor-version":[{"id":443,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/438\/revisions\/443"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=438"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}