Crosstab Headers Unaligned After Conditional Style - Header Too Long Leaving Gap

[Eric.Seitz]

Running Cognos 11R7
I've been having a bit of trouble with programmatically showing only the current quarter's data in a crosstab set up similar to this:

[          Year         ] | [YTD Total]
[ Month]   [ Month] |
[ Dollars] [ Dollars] | [ Dollars]

I made a custom conditional style to hide any months not in the current quarter but when I run the report the "year" header is too long leaving a blank space between the final month and YTD Total. This causes the YTD total's data to be shifted out from the proper header misaligning everything. Sort of like this:
[---------------------2023------------------------] | [YTD Total]
[ July ] [ August] [ September] *empty space*|
$100       $200        $300             | $600  <-- This is supposed to be under YTD Total

Right now the conditional style sets "Visible" to no  and "box type" to none.

Does anyone have any hints or tips to try? It's a bit baffling that the headers won't auto-resize when using conditional styles like this.

[dougp]

Sample data would be helpful.  Assuming you have numbers in October, the total would not work out to $600 the way you have done this.  The style should hide the elements, not change the numbers.

I think what you really want is a filter, not conditional styles.

[Eric.Seitz]

Sample data would be helpful.  Assuming you have numbers in October, the total would not work out to $600 the way you have done this.  The style should hide the elements, not change the numbers.

I think what you really want is a filter, not conditional styles.

I agree completely that a filter would be easier, problem is this is just one chunk of a much larger (and much more complex) crosstab. Though maybe you have a point, splitting it up into prior quarters and current quarter may yield better results...

[dougp]

So, maybe describe the entire problem..?

Better yet, can you reproduce the problem using the GO Sales (query) package and paste the report spec to pastebin?