COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: VicBA on 30 May 2012 07:32:33 PM

Title: Crosstab Conditional Formatting Based on Which Rows Appear
Post by: VicBA on 30 May 2012 07:32:33 PM
Hello,

I am fairly new to using Cognos so I may be going about this the wrong way. The problem I'm having is creating dynamic borders in my crosstab.

I have nested rows that appear like this:

<#Completion Group#> <#Description#>
                                <#Description#>
<#Completion Group#> <#Description#>
                                <#Description#>
<#Completion Group#> <#Description#>
                                <#Description#>

What I'm trying to do is have a border underline the whole row of the crosstab whenever it is the last 'Description' of a 'Completion Group' i.e. I want the borders to divide up the different completion groups.

At first I hardcoded the formatting so that for specific 'Descriptions' I would create a border using a conditional style but if there is no data returned for a particular 'Description' then that row will not appear on the report and so the Description that would appear at the bottom would not have that conditional formatting.

In case this is unclear here is an example of what is happening:

This is how it normally displays: http://i.imgur.com/65Ciw.jpg (http://i.imgur.com/65Ciw.jpg)

Notice in this image there is no 'Other' Description so there is no border underneath 'Ethnicity Grouping': http://i.imgur.com/0KsIB.jpg (http://i.imgur.com/0KsIB.jpg)

Thanks in advance
Title: Re: Crosstab Conditional Formatting Based on Which Rows Appear
Post by: pricter on 31 May 2012 08:34:44 AM
Did you try to place a crosstab space below the description.

With a little formating of the crosstab space you can achieve the desirable result
Title: Re: Crosstab Conditional Formatting Based on Which Rows Appear
Post by: VicBA on 31 May 2012 05:29:16 PM
Great thank you, that solved my problem nicely.  :D