nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get chart color from a database

Niox.79 · 2015-03-31T20:24:13+00:00

Hello, first I want to apologize for my bad english. Unfortunately, it's not my native language. but I'll try to describe my problem anyway. I have a report with some pie charts. Right now I use a script in order to determine the color of the charts <blockquote…

Niox.79

Hello,
 
first I want to apologize for my bad english. Unfortunately, it's not my native language. but I'll try to describe my problem anyway.
 
I have a report with some pie charts. Right now I use a script in order to determine the color of the charts
 
<blockquote class="ipsBlockquote">
function beforeDrawDataPoint( dph, fill, icsc )
{
if (dph.getBaseDisplayValue() == "done"){
 fill.set(0,204,0);
}
else if (dph.getBaseDisplayValue() == "open"){
 fill.set(getValueAt(status, color));
 }
and 
function beforeDrawLegendItem( lerh, bounds, icsc )
{
if (lerh.getLabel().getCaption().getValue() == "done"){
 lerh.getFill().set(0,204,0);
}
else if (lerh.getLabel().getCaption().getValue() == "open"){
 lerh.getFill().set(240,107,19);
 }
 
</blockquote>
 
And so on
 
What I would like to know is whether it is possible to take the color from a database. For example: Take the color for value W from database X, table Y and column Z. The Colors are stored as Hex. Do I have to convert them in RGB first?
 
Thanks in advance

Find more posts tagged with

Comments

JFreeman

From what I can tell you will need to convert to colors into RGB before they can be applied.
 
As for obtaining the values from your database, there are a few ways this could be done. You could create a data set in your report to pull in the desired column from your database.
 
Alternatively, you could use javascript to connect to your database directly to obtain those values.

Niox

Hi Jesse,
 
i am a beginner and I do not know if I can do it. But I'll try. Thank you for your help.

JFreeman

You're welcome.
 
Let us know if you have any additional questions.

Matthew L.

Niox,
 
I wrote up a quick function that will do the conversion from Hex to RGB and set the value.
I also modified your code to use the example function.
See function comments for more details.
Hopefully this helps out.
<pre class="_prettyXprint _lang-js">
function beforeDrawDataPoint( dph, fill, icsc ){
if (dph.getBaseDisplayValue() == "done"){
//fill.set(0,204,0);
hexSet(fill,"#00CC00");
}else if (dph.getBaseDisplayValue() == "open"){
//fill.set(getValueAt(status, color));
hexSet(fill,getValueAt(status, color)); //Assuming that getValueAt() returns a hex string
}
}
function beforeDrawLegendItem( lerh, bounds, icsc ){
if (lerh.getLabel().getCaption().getValue() == "done"){
//lerh.getFill().set(0,204,0);
hexSet(lerh.getFill(),"#00CC00");
}else if (lerh.getLabel().getCaption().getValue() == "open"){
//lerh.getFill().set(240,107,19);
hexSet(lerh.getFill(),"#F06B13");
}
}

//

//Please note that all custom code received from Actuate Support is officially untested and unsupported.
//This is meant for guidance purposes only and should not be implemented in a production environment without proper testing.
//This custom code is provided to you "AS IS", It is your own responsibility to maintain it if changes are required.
//

//The following function sets a RGB color from a Hex value.
//Parameters:
// obj (object) = Object to set value to.
// hex (string) = Hex value of color to set object to.
//
//Examples:
// hexSet(fill,"#484847");
// hexSet(lerh.getFill(),"#484847");
//

function hexSet(obj,hex){
var tmpHex = hex.charAt(0)=="#"?hex.substring(1,7):hex; //Remove # if exists
var r = parseInt(tmpHex.substring(0,2),16); //Get Red value, use radix 16 for hexadecimal conversion
var g = parseInt(tmpHex.substring(2,4),16); //Get Green value, use radix 16 for hexadecimal conversion
var b = parseInt(tmpHex.substring(4,6),16); //Get Blue value, use radix 16 for hexadecimal conversion
obj.set(r,g,b); //Set color
}
//

</pre>

Niox

this is great. many thanks for your effort. currently I have no time for the project. but I will test it as soon as possible. I'll let you guys know if it worked.