2

How do you create banded columns in Cognos Report Studio?

Here is an example of banded columns taken from this link:

enter image description here

EDIT:

Maybe this search string will help find this page?

"Cognos Report Studio, how to create column band"

Soenhay
  • 3,628
  • 4
  • 29
  • 53
  • 1
    Are you using a list or crosstab? You can do this in both but the procedure differs depending on the data container. – Johnsonium May 13 '17 at 21:23
  • @Johnsonium I am just dropping fields on the report so I think it is a List but I am not sure... Maybe I should specifically put a List on the report? – Soenhay May 15 '17 at 15:00
  • @Johnsonium I confirmed that I am using a list and that a list is what is automatically created when you drop fields onto an empty spot on the report. – Soenhay May 15 '17 at 15:18

1 Answers1

3

Here is the procedure for a list:

  1. Select the list object
  2. In the Structure menu, select Headers & Footers and then List Headers & Footers
  3. Check the box next to List Page Header and click OK
  4. In the List object properties set the Column Titles property to At start of details
  5. Select the new header
  6. In the Structure menu, select Headers & Footers and then Insert List Row Cells Above...
  7. Enter the number of header rows you want above the standard detail header and click OK
  8. Delete the List Page Header row with 1 cell that was created in step 3
  9. Select multiple horizontally-adjacent cells that you want to merge into one
  10. In the Structure menu, select Headers & Footers and then Merge List Row Cells

Add some styling to the new header rows and end up with something like this:

enter image description here

Note that I couldn't vertically merge cells to produce the tall 'Sales Person' header in your mock-up. There may be a way to do this but that goes beyond the scope of this question.

Soenhay
  • 3,628
  • 4
  • 29
  • 53
Johnsonium
  • 1,985
  • 1
  • 10
  • 15