Use query color

[macaxrc]

Hi every body, 

I need help to change the color of the line chart, in my database have 3 field, type, color and sales.
 

I'm use jasper studio 5.5

I make this query:

Select type, color, sales

from table

I need use the color value of my data base to use in the lines of the chart.

How I can do this?

 

Thanks

[Tom C]

Please take a look at this wiki posting for a sample report:

http://community.jaspersoft.com/wiki/sample-report-setting-same-color-data-label-and-series-html5-charts

[macaxrc]

Thanks I'm try this and works perfectly

[macaxrc]

I'm try to use this with different chart, in a bubble but not works.
 

I'm try this

 

<dataAxis axis="Rows">       <axisLevel name="Competidor">        <labelExpression><![CDATA["Level Label expression"]]></labelExpression>        <axisLevelBucket class="java.lang.String">         <bucketExpression><![CDATA[$F{Competidor}]]></bucketExpression>         <bucketProperty name="color"><![CDATA[$F{color}]]></bucketProperty>        </axisLevelBucket>       </axisLevel>      </dataAxis>      <dataAxis axis="Columns"/>      <multiAxisMeasure name="Actividad" class="java.lang.Integer" calculation="Nothing">       <labelExpression><![CDATA["Actividad"]]></labelExpression>       <valueExpression><![CDATA[$F{actoriginal}]]></valueExpression>      </multiAxisMeasure>      <multiAxisMeasure name="Interactividad" class="java.lang.Integer" calculation="Nothing">       <labelExpression><![CDATA["Interactividad"]]></labelExpression>       <valueExpression><![CDATA[$F{interactividad}]]></valueExpression>      </multiAxisMeasure>     </multiAxisData>     <hc:series name="Actividad">      <hc:contributor name="SeriesProperty">       <hc:contributorProperty name="color" valueType="Bucket" value="Competidor.color"/>       <hc:contributorProperty name="dataLabels.color" valueType="Bucket" value="Competidor.color"/>      </hc:contributor>     </hc:series>     <hc:series name="Interactividad">      <hc:contributor name="SeriesProperty">       <hc:contributorProperty name="color" valueType="Bucket" value="Competidor.color"/>       <hc:contributorProperty name="dataLabels.color" valueType="Bucket" value="Competidor.color"/>      </hc:contributor>     </hc:series>[/code]

 

[Tom C]

Please read this wiki posting for a wokring sample of HTML5 bubble chart

http://community.jaspersoft.com/wiki/sample-report-showing-bubble-color-setting-html5-charts