COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Robl on 04 Mar 2015 10:23:15 AM

Title: Crosstab Column Headers
Post by: Robl on 04 Mar 2015 10:23:15 AM

oes anyone know a decent method of adding column headers to the grouped items in a crosstab report.

My current method involves adding a table and text items into the crosstab corner and then formatting all the columns and cells to the same size.
I'm just wondering if there's been an enhancement to Report Studio that I've missed that allows this to be done in a simpler way.
Thanks.
Title: Re: Crosstab Column Headers
Post by: rockytopmark on 04 Mar 2015 12:04:13 PM
Do you mean headings for the ROW edge(s)?

If so add Crosstab Space(s), and put text items with the desired heading texts in them.

So, if 3 nested row edge members, add 3 crosstab spaces, on a single row to match the layout of the row edge members.
Title: Re: Crosstab Column Headers
Post by: Michael75 on 04 Mar 2015 12:31:03 PM
I'm not aware of any enhancement to RS in this regard. Others here could give a more informed answer to your question.

If I understand your requirement correctly, and supposing that rockytopmark's assumption in this respect is correct, some references I've noted in the past should help you to do just this:

https://www.youtube.com/watch?v=15J6wSv-wo8 (https://www.youtube.com/watch?v=15J6wSv-wo8)

http://cognoswithhari.wordpress.com/2011/10/28/crosstab-as-a-list/ (http://cognoswithhari.wordpress.com/2011/10/28/crosstab-as-a-list/)

http://cognosknowhow.blogspot.de/2012/07/how-to-make-crosstab-look-like-list.html (http://cognosknowhow.blogspot.de/2012/07/how-to-make-crosstab-look-like-list.html)

http://mybyeexperience.blogspot.de/2012/12/cognos-cross-tab-report-studio-report.html (http://mybyeexperience.blogspot.de/2012/12/cognos-cross-tab-report-studio-report.html)

I believe that there's quite a lot of duplication between those references, but one or the other of them should hopefully get you started :)
Title: Re: Crosstab Column Headers
Post by: Robl on 05 Mar 2015 02:29:50 AM
Thanks.
It's not exactly what I was after, but I can work woth it.