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