<p>Hello,</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>I have a report with some pie charts. Right now I use a script in order to determine the color of the charts</p>
<p> </p>
<blockquote class="ipsBlockquote">
<p><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">function</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> beforeDrawDataPoint( dph, fill, icsc )</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">{</span></span></span></p>
<p><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">if</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> (dph.getBaseDisplayValue() == </span></span></span><span style="color:#2a00ff;"><span style="font-family:consolas;"><span style="font-size:10pt;">"done"</span></span></span><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">){</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> fill.set(0,204,0);</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">}</span></span></span></p>
<p><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">else</span></span></span></strong> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">if</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> (dph.getBaseDisplayValue() == </span></span></span><span style="color:#2a00ff;"><span style="font-family:consolas;"><span style="font-size:10pt;">"open"</span></span></span><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">){</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> fill.set(getValueAt(status, color));</span></span></span></p>
<p> <span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">}</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">and </span></span></span></p>
<p><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">function</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> beforeDrawLegendItem( lerh, bounds, icsc )</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">{</span></span></span></p>
<p><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">if</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> (lerh.getLabel().getCaption().getValue() == </span></span></span><span style="color:#2a00ff;"><span style="font-family:consolas;"><span style="font-size:10pt;">"done"</span></span></span><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">){</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> lerh.getFill().set(0,204,0);</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">}</span></span></span></p>
<p><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">else</span></span></span></strong> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">if</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> (lerh.getLabel().getCaption().getValue() == </span></span></span><span style="color:#2a00ff;"><span style="font-family:consolas;"><span style="font-size:10pt;">"open"</span></span></span><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">){</span></span></span></p>
<p> <span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">lerh.getFill().set(240,107,19);</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> }</span></span></span></p>
<p> </p>
</blockquote>
<p> </p>
<p>And so on</p>
<p> </p>
<p>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?</p>
<p> </p>
<p>Thanks in advance</p>
