Sunday, February 19, 2012

Chart Colours

Hi,

I have a problem relating to customising colours in SQL reporting services 2000. On one of my reports i have managed this no problem. This report however used series which were stored on individual fields in the data base. i.e.

Chanrt Type : Stacked column chart

Xaxis : dates

Yaxis : counts of various status' (Known, Unknown, Understood, Designed, Verified)

each of the status types has a seperate field in the database to store the count on a given date.

The new version changes the structure of the database. I now hav a date field as before, but now a Status field (stores whatever status for that date), and a Statuscount field (storing the count for that status on the given date).

My chart now has an X axis of dates and Y axis of the value of the status field. The difference here is that there are not individual series from which i can change the colour.

Does anyone know of a way to customise the colour of this chart? I appreciate i may not have explained myself too well so apologies if this post makes no sense.

Many thanks in advance

Grant

Hi again,

Nevermind. I have managed to resolve the problem. It seems that i needed to put a function into the code section of the report properties which selects a colour depending on the value of the series filed. I can then call this function from the series style fill attribute. Seems to work just perfect.

Cheers

Grant

No comments:

Post a Comment