referencecode colour is not used correctly in chart

Hello,

I use the option to define a colour in a referencecode to color the bars in a chart I am building.

It is a report showing values for a hospital (ziekenhuis in Dutch) and a benchmark. I have in a referencecode defined two colours.

Then I made a report in which I set this referencecode on a field that is showing just those 2 options.

In the vertical bar chart I set the colour to use the Niveau field mentioned above and then I select to use the reference colour.

In the background of the previous image you already see that the colours do not match as defined in the reference code in the first image.

The ziekenhuis colour looks fine but the benchmark colour is totally wrong.

There is another referencecode for a different customer with the same possible values but that is a french customer. So the values are Hôpital and Benchmark while for the reference code I use the possible values are Ziekenhuis and Benchmark.

It looks like when adding colour to the chart it searches for a defined value to colorize but over all referencecodes instead of only in the reference code you applied to the field in the data section of the report. And if it finds multiple values as in my case then it takes the last so it seems.

The color in the second reference code matches the color I see in the report. I changed the colour in the second referencecode (that I am not using in my report) and the changed colour is now visible in my report.

I use the vertial bar chart en horizontal bar charts in my report and those have this issue. The autochart does show the correct colour so there is no problem there but I do not have all the options I have when using vertial bar chart so using autochart is not a solution for me.

This is a rather urgent issue as we have different end-user demandig the use of differenct colour for there charts.

Please include a fix for this in the next patch update.

Kind regards,

JeRoen