{"id":3369,"date":"2023-04-12T15:32:53","date_gmt":"2023-04-12T15:32:53","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/"},"modified":"2026-01-16T14:56:17","modified_gmt":"2026-01-16T14:56:17","slug":"what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/","title":{"rendered":"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11?"},"content":{"rendered":"

What Can a List Header and Footer Do for you in Cognos Analytics 11+<\/strong><\/p>\n

Just make your report look and read great!<\/em><\/strong><\/p>\n

I recently had a client who wanted to see summary cost information on Sales Orders at the header of the page, with details available in a list report.\u00a0 I tried using singleton\u2019s and groupings, but all the totals were buried within the report and it was difficult to read.\u00a0 A colleague suggested I use a \u201cList Header and Footer\u201d.\u00a0 Wow, was I impressed with the results.\u00a0 It was so easy to implement, and the report looked great.<\/p>\n

Business Case:\u00a0 <\/strong><\/p>\n

The City of Boston currently utilizes a \u201c311 System\u201d, which enables city residents or city workers to easily report non-emergency issues.\u00a0 Items such as broken streetlights or graffiti can be reported to the proper city services department via mobile phone applications, online, social media or a phone call.\u00a0 For this example, we would like to create a list report which will show the total count of issues and the average days to resolution by neighborhood.<\/p>\n

Here is how the data looks when we first start the report.\u00a0 As you can see, we have a very simple list report with no summations.\u00a0 As a consumer of this report, I cannot easily determine total count of issues or the average days to resolution by neighborhood.<\/p>\n

\"\"<\/p>\n

Here is the report when we get done.\u00a0 As you can see, we have the total count and average days to resolution at the top of the list as we desired.<\/p>\n

\"\"<\/p>\n

Procedure:<\/strong><\/p>\n

    \n
  1. Create a list report with the fields you will want to show. I suggest you leave the items you want to include in the list header to your left as shown below.\u00a0 Please note, I am making these changes while in page preview mode.<\/li>\n<\/ol>\n

    \"\"<\/p>\n

      \n
    1. Highlight the Neighborhood column and click the group icon on the tool bar.<\/li>\n<\/ol>\n

      \"\"<\/p>\n

      You will now see the Neighborhood column has moved to the left and is grouped.<\/p>\n

      \"\"<\/p>\n

        \n
      1. Again, highlight neighborhood and choose the more icon ( ) on the tool bar. Choose \u201cHeaders & Footers\u201d and then \u201cList headers and footers\u201d<\/li>\n<\/ol>\n

        \"\"<\/p>\n

          \n
        1. For this example, we only want to choose header, as we do not need a footer. Only check the box next to Neighborhood (header) and press OK.<\/li>\n<\/ol>\n

          \"\"<\/p>\n

            \n
          1. You will now see a header row has been created within the list.<\/li>\n<\/ol>\n

            \"\"<\/p>\n

              \n
            1. It\u2019s now time to format the header row to hold our totals. The first step is to split the cells in the header by clicking on the header and then choose \u201cSplit Cell\u201d from the tool bar.<\/li>\n<\/ol>\n

              \"\"<\/p>\n

              You will now see your header line has split into cells.<\/p>\n

              \"\"<\/p>\n

                \n
              1. Unlock the cells in the list by going to the upper righthand corner of the page and pressing the more icon ( ). Then click on \u201cLocked\u201d and you will see the option will now show unlocked.<\/li>\n<\/ol>\n

                \"\"<\/p>\n

                  \n
                1. Under the Count column, highlight the item. You will notice the item itself is highlighted not the column.\u00a0 Drag and drop this to the header row as shown below.\u00a0 Do the same with the \u201cDays to Resolution\u201d item.<\/li>\n<\/ol>\n

                  \"\"<\/p>\n

                  You will now notice the summaries are in the header row.<\/p>\n

                  \"\"<\/p>\n

                    \n
                  1. The final step is to format your dates and numbers, and you have the new report as shown below.<\/li>\n<\/ol>\n

                    \"\"<\/p>\n

                    ** Tune in for the next KB where I\u2019ll show you how to hide\/show the detail on your list!!!<\/p>\n","protected":false},"excerpt":{"rendered":"

                    What Can a List Header and Footer Do for you in Cognos Analytics 11+ Just make your report look and read great! I recently had a client who wanted to see summary cost information on Sales Orders at the header of the page, with details available in a list report.\u00a0 I tried using singleton\u2019s and…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[39,47,38],"class_list":["post-3369","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-cognos-analytics","tag-cognos-analytics-how-tos","tag-how-tos"],"acf":[],"yoast_head":"\nHow Do List Headers and Footers Improve Your Reports in Cognos Analytics 11? - QueBIT<\/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:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"What Can a List Header and Footer Do for you in Cognos Analytics 11+ Just make your report look and read great! I recently had a client who wanted to see summary cost information on Sales Orders at the header of the page, with details available in a list report.\u00a0 I tried using singleton\u2019s and…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T14:56:17+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11?\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T14:56:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/\"},\"wordCount\":573,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/CA11HF-min-1024x500.jpg\",\"keywords\":[\"Cognos Analytics\",\"Cognos Analytics How To's\",\"How To\u2019s\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/\",\"name\":\"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/CA11HF-min-1024x500.jpg\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T14:56:17+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/CA11HF-min-1024x500.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/CA11HF-min-1024x500.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11? - QueBIT","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:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/","og_locale":"en_US","og_type":"article","og_title":"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11? - QueBIT","og_description":"What Can a List Header and Footer Do for you in Cognos Analytics 11+ Just make your report look and read great! I recently had a client who wanted to see summary cost information on Sales Orders at the header of the page, with details available in a list report.\u00a0 I tried using singleton\u2019s and…","og_url":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:53+00:00","article_modified_time":"2026-01-16T14:56:17+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11?","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T14:56:17+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/"},"wordCount":573,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/11\/CA11HF-min-1024x500.jpg","keywords":["Cognos Analytics","Cognos Analytics How To's","How To\u2019s"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/","url":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/","name":"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/11\/CA11HF-min-1024x500.jpg","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T14:56:17+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/11\/CA11HF-min-1024x500.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/11\/CA11HF-min-1024x500.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/what-can-a-list-header-and-footer-do-for-you-in-cognos-analytics-11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do List Headers and Footers Improve Your Reports in Cognos Analytics 11?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3369"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3369\/revisions"}],"predecessor-version":[{"id":4930,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3369\/revisions\/4930"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}