Crosstab Conditional Formatting Based on Which Rows Appear

[VicBA]

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

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

Thanks in advance

[pricter]

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

[VicBA]

Great thank you, that solved my problem nicely.  :D