{"id":35,"date":"2010-05-05T14:47:15","date_gmt":"2010-05-05T19:47:15","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=35"},"modified":"2010-05-05T14:47:15","modified_gmt":"2010-05-05T19:47:15","slug":"hiding-crosstab-row-titles-in-cognos-8-4","status":"publish","type":"post","link":"https:\/\/cognitiveinfo.com\/?p=35","title":{"rendered":"Hiding Crosstab row titles in Cognos 8.4"},"content":{"rendered":"<p>Since 8.3, the (Don&#8217;t Print) global class still reserves a full width space for the title object, even if the text is not displayed.  One method is to set &#8216;Box Type&#8217; to &#8216;None&#8217; but that can mess up alignment with the column headers if you have nested row levels to hide.   Hopefully this will be fixed in the next version of Cognos. <\/p>\n<p>Workaround:<\/p>\n<p>1.  Click the column\/row header and set the &#8216;Source Type&#8217; property to &#8216;Text&#8217;.  This creates a null string so it measures zero length of space to reserve.<\/p>\n<p>2.  In Page Explorer, go to the &#8216;Classes&#8217;<\/p>\n<p>3.  Create a new local class and name it.  I named mine &#8216;Cloak of Invisibility&#8217;.<\/p>\n<p>4.  Highlight that class and set the Properties as follows:<br \/>\n\tBorder:  ? None ?<br \/>\n\t\tSet by going into another dialog box, choosing None and applying.<br \/>\n\tPadding:  0px 0px 0px 0px<br \/>\n\tSize &#038; Overflow:<br \/>\n\t\t\t\tHeight: 0px<br \/>\n\t\t\t\tWidth: 0px<br \/>\n\t\t\t\tContent is clipped: Selected<br \/>\n\tVisible: No<\/p>\n<p>5.  SAVE NOW!  I save as &#8216;reportname_before_hiding&#8217;  Once you proceed, headers will be hidden in the report &#8216;Page Design&#8217; view and can only be edited in the &#8216;Page Structure&#8217; view.<\/p>\n<p>6.  Remove the Crosstab corner.<\/p>\n<p>7.  Go back to page view and select all row headers to be hidden.<\/p>\n<p>8.  Apply the &#8216;(Don&#8217;t Print)&#8217; class and &#8216;Cloak of Invisibility&#8217; class.<\/p>\n<p>9.  Save a final version of the report.<\/p>\n<p>Run as HTML and the header is hidden but still takes up a small amount of space.<br \/>\nRun as PDF and the header is removed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A workaround to hide row titles in Cognos 8.x crosstab reports.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[21,37,42,55,77,106],"class_list":["post-35","post","type-post","status-publish","format-standard","hentry","category-cognos","tag-8-4","tag-cognos","tag-crosstab","tag-formatting","tag-report-studio","tag-titles"],"_links":{"self":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/35","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=35"}],"version-history":[{"count":0,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/35\/revisions"}],"wp:attachment":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}