If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditional formatting of chart category labels

Started by vebjornwa, 20 Oct 2009 08:41:36 AM

Previous topic - Next topic

vebjornwa

We have a set of reports showing time series data in charts, e.g. column charts showing sales per month, with month labels as categories (x-axis) and revenue as the default measure (y-axis).

In such charts, we want to apply conditional formatting on the chart category labels (i.e. the labels on the x-axis, such as 200901, 200902, 200903 etc.). More specifically, we want the x-axis label for e.g. the current month to display in red font, while the others are displayed in standard black font. To achieve this, we have calculated a data item for the current month (based on oracle sysdate), and defined a boolean report variable as [Month label] = [Month label current].

Now, the plan was to use this variable as the style variable for the chart (or some sub-component of it, such as the x-axis), and set the font to red for value Yes. That doesn't work; all category labels, including the one representing the current month, display in black. As an alternative, we tried to use conditional style on the chart (or sub-components of it, such as the x-axis) by defining an advanced conditional style based on the expression given above ([Month label] = [Month label current]), but that doesn't work either; all labels are still rendered in black.

Is this at all possible? Any suggestions on how to achieve this?

billylodz

use trick.

delete all descriptions in char, below chart create crosstab based on the same query. put months as columns, hide rows and fact cels. use fixed size for chart and crosstab and use conditional formating in crostab columns.