Jump to content
Changes to the Jaspersoft community edition download ×

How to make a single chart


dennis.dekker

Recommended Posts

Hello,

I want to make a chart based on machine data; let's say Machine temperature.

I know how to write the sql, all the data is there, it's a lot; 11.000 records of unique recorded data, but thats not the problem.

Making the chart is also not the problem, the chart makes a nice trend line for all the data points.

My problem is I have 5.500 pages due to 2 exact the same charts on every page, one for every record.

How can I create a single chart in a report?

 

Thanks,

Dennis

Link to comment
Share on other sites

  • Replies 11
  • Created
  • Last Reply

Top Posters In This Topic

I tried to put in some screenshots however just pasted it, that does not seem to work.

I'm not really sure if the screenshots help in any way.

 

Do you need some JRXML from the 'source' to help me? I don't use that myself, so not really sure what part you would like to see.

 

Maybe I do not understand the nature of your questoin, English is not my first language :)

Link to comment
Share on other sites

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.0.final using JasperReports Library version 6.1.0 --><!-- 2019-01-18T11:33:31 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"              xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"              name="TemplateReport" pageWidth="595" pageHeight="842"              whenNoDataType="NoDataSection" columnWidth="575"              leftMargin="10" rightMargin="10" topMargin="1" bottomMargin="20"              resourceBundle="dce.util.report.JRDummyResourceBundle"              whenResourceMissingType="Error"              uuid="d7df3712-9f23-4ad5-912d-6b79cb435936">    <property name="ireport.zoom" value="1.610510000000001"/>    <property name="ireport.x"    value="0"/>    <property name="ireport.y"    value="0"/>    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Live_datawarehouse"/>    <property name="com.jaspersoft.studio.unit."              value="pixel"/>    <property name="com.jaspersoft.studio.unit.pageHeight"    value="pixel"/>    <property name="com.jaspersoft.studio.unit.pageWidth"     value="pixel"/>    <property name="com.jaspersoft.studio.unit.topMargin"     value="pixel"/>    <property name="com.jaspersoft.studio.unit.bottomMargin"  value="pixel"/>    <property name="com.jaspersoft.studio.unit.leftMargin"    value="pixel"/>    <property name="com.jaspersoft.studio.unit.rightMargin"   value="pixel"/>    <property name="com.jaspersoft.studio.unit.columnWidth"   value="pixel"/>    <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>    <style name="Column Header" mode="Opaque"           forecolor="#000000" backcolor="#C3D4E8"           fill="Solid"           hTextAlign="Center" hImageAlign="Center"           vTextAlign="Middle" vImageAlign="Middle"           fontSize="8" isBold="true">        <box>            <topPen    lineWidth="1.0" lineColor="#000000"/>            <leftPen   lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>            <rightPen  lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="Report Title" fontSize="14" isBold="true"           isItalic="false" isUnderline="false"           isStrikeThrough="false"/>    <style name="Subreport Title"/>    <style name="Detail" forecolor="#000000" fontSize="8"           isBold="false" isItalic="false"           isUnderline="false"           isStrikeThrough="false"/>    <style name="Report Parameters" mode="Opaque"           forecolor="#000000" backcolor="#FFFFFF"           hTextAlign="Left" hImageAlign="Left"           fontName="SansSerif" fontSize="10"           isBold="true" isItalic="false"           isUnderline="false"           isStrikeThrough="false">        <box>            <pen       lineWidth="0.0"/>            <topPen    lineWidth="0.0"/>            <leftPen   lineWidth="0.0"/>            <bottomPen lineWidth="0.0"/>            <rightPen  lineWidth="0.0"/>        </box>    </style>    <style name="Page Footer"/>    <parameter name="DATABASE_VENDOR"               class="java.lang.String"               isForPrompting="false">        <defaultValueExpression>            <![CDATA["SQLSERVER"]]>        </defaultValueExpression>    </parameter>    <parameter name="PARAMETER"           class="java.lang.String"           isForPrompting="false">        <defaultValueExpression>            <![CDATA["Test"]]>        </defaultValueExpression>    </parameter>    <parameter name="MACHINE_NAME"               class="java.lang.String"               isForPrompting="false">        <parameterDescription>            <![CDATA[]]>        </parameterDescription>        <defaultValueExpression>            <![CDATA[]]>        </defaultValueExpression>    </parameter>    <parameter name="MACHINE_NAME_LIST"class="java.util.List" isForPrompting="false"/>    <parameter name="MACHINE_NAME_SQLFILTER"               class="java.lang.String"               isForPrompting="false">        <defaultValueExpression>            <![CDATA[dce.util.report.JRUtils.getInClause($P{DATABASE_VENDOR}, "machine.OID", (($P{MACHINE_NAME} != null) ? $P{MACHINE_NAME} : $P{MACHINE_NAME_LIST}))]]>        </defaultValueExpression>    </parameter>    <parameter name="FROM_DATE"               class="java.util.Date"               isForPrompting="false">        <defaultValueExpression>            <![CDATA[]]>        </defaultValueExpression>    </parameter>    <parameter name="FROM_DATE_SQLVALUE"               class="java.lang.String"               isForPrompting="false">        <defaultValueExpression>            <![CDATA[dce.util.report.JRUtils.getSQLValue($P{DATABASE_VENDOR}, $P{FROM_DATE})]]>        </defaultValueExpression>    </parameter>    <parameter name="TO_DATE" class="java.util.Date" isForPrompting="false"/>    <parameter name="TO_DATE_SQLVALUE"               class="java.util.Date"               isForPrompting="false">        <defaultValueExpression>            <![CDATA[dce.util.report.JRUtils.getSQLValue($P{DATABASE_VENDOR}, $P{TO_DATE})]]>        </defaultValueExpression>    </parameter>    <parameter name="BATCH" class="java.lang.String"/>    <parameter name="VALUE" class="java.lang.Double" isForPrompting="false"/>    <queryString>        <![CDATA[select * from DCEVIEW_DATACOLLECTIONINSTRUCTIONS                  where PRODUCTIONORDER = '723z9'                    and PARAMETERNAME   = 'MELTTEMPERATUUR EXTRUDER']]>    </queryString>    <field name="PRODUCTIONORDER"        class="java.lang.String"/>    field name="PRODUCTIONOPERATION"     class="java.lang.String"/>    <field name="PRODUCTIONDESCRIPTION"  class="java.lang.String"/>    <field name="PROCESSRESOURCE"        class="java.lang.String"/>    <field name="INSTRUCTIONNAME"        class="java.lang.String"/>    <field name="INSTRUCTIONDESCRIPTION" class="java.lang.String"/>    <field name="PARAMETERNAME"          class="java.lang.String"/>    <field name="PARAMETERDESCRIPTION"   class="java.lang.String"/>    <field name="VALUE"                  class="java.lang.Double"/>    <field name="TARGET"                 class="java.lang.Double"/>    <field name="UOM"                    class="java.lang.String"/>    <field name="DATE"                   class="java.lang.String"/>    <variable name="TIJD" class="java.lang.String"/>    <background>        <band splitType="Stretch"/>    </background>    <title>        <band height="281" splitType="Stretch">            <lineChart>                <chart evaluationTime="Report">                    <reportElement x="50" y="81" width="384" height="200"                                   uuid="142ad0c1-5fca-4196-9aa9-d6188f8dbd4d"/>                    <chartTitle/>                    <chartSubtitle/>                    <chartLegend/>                </chart>                <categoryDataset>                    <categorySeries>                        <seriesExpression><![CDATA["SERIES 1"]]></seriesExpression>                        <categoryExpression><![CDATA[$F{DATE}]]></categoryExpression>                        <valueExpression><![CDATA[$F{VALUE}]]></valueExpression>                        <labelExpression><![CDATA[$F{DATE}]]></labelExpression>                    </categorySeries>                </categoryDataset>                <linePlot>                    <plot/>                    <categoryAxisFormat>                        <axisFormat/>                    </categoryAxisFormat>                    <valueAxisFormat>                        <axisFormat/>                    </valueAxisFormat>                </linePlot>            </lineChart>        </band>    /title>    <pageHeader>        <band height="62">            <textField>                <reportElement style="Report Title" x="10" y="26"                               width="220" height="24"                               uuid="1a52e80e-2beb-416b-9728-ccec0acda242">                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="14" isBold="true"/>                </textElement>                <textFieldExpression>                    <![CDATA["OPERATOR AANWEZIGHEID"]]>                </textFieldExpression>            </textField>            <line>                <reportElement key="line-3" x="1" y="50"                               width="570" height="1"                               uuid="6d7d3e54-bb41-4cf7-bc29-616fbb6fd5d6"/>            </line>            <textField>                <reportElement x="350" y="26" width="114" height="24"                               uuid="88c57c9a-9afe-4d8c-9164-9d897a4301bf">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="12" isBold="true"/>                </textElement>                <textFieldExpression>                    <![CDATA["$F{PRODUCTIONORDER}"]]>                </textFieldExpression>            </textField>            <textField>                <reportElement x="220" y="26" width="132" height="24"                               uuid="dcdc1c70-fa8d-480b-b2c6-c76825e7f835">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                </reportElement>                <textElement verticalAlignment="Middle">                    <font size="12" isBold="false"/>                </textElement>                <textFieldExpression>                    <![CDATA["PRODUCTIEORDER;"]]>                </textFieldExpression>            </textField>        </band>    </pageHeader>    <columnHeader>        <band height="20" splitType="Stretch">            <textField>                <reportElement mode="Opaque" x="156" y="0" width="155"                               height="20" backcolor="#C3D4E8"                               uuid="4584a47e-dfb5-4ab0-99c5-f8acf6fa526c">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                </reportElement>                <box>                    <topPen    lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                    <leftPen   lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                    <rightPen  lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                </box>                <textElement textAlignment="Center" verticalAlignment="Middle"/>                <textFieldExpression>                    <![CDATA["PARAMETER"]]>                </textFieldExpression>            </textField>            <textField>                <reportElement mode="Opaque" x="423" y="0" width="73"                               height="20" backcolor="#C3D4E8"                               uuid="58c5cdeb-3630-4824-b162-cd6c4a3e72d3">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                </reportElement>                <box>                    <topPen    lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                    <leftPen   lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                    <rightPen  lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                </box>                <textElement textAlignment="Center" verticalAlignment="Middle"/>                <textFieldExpression><![CDATA["START"]]></textFieldExpression>            </textField>            <textField>                 <reportElement mode="Opaque" x="496" y="0" width="73"                                height="20" backcolor="#C3D4E8"                                uuid="41a67790-a020-45dd-9a84-6ebc0c57317c">                     <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                     <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                     <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                 </reportElement>                 <box>                     <topPen    lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <leftPen   lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <rightPen  lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                 </box>                 <textElement textAlignment="Center" verticalAlignment="Middle"/>                 <textFieldExpression>                     <![CDATA["STOP"]]>                 </textFieldExpression>             </textField>             <textField>                 <reportElement mode="Opaque" x="1" y="0" width="155"                                height="20" backcolor="#C3D4E8"                                uuid="ecff25db-3e09-47bc-9d8e-388194fde5e2">                      <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                 </reportElement>                 <box>                     <topPen    lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <leftPen   lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <rightPen  lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                 </box>                 <textElement textAlignment="Center" verticalAlignment="Middle"/>                 <textFieldExpression>                     <![CDATA["DATACOLLECTIE"]]>                 </textFieldExpression>             </textField>             <textField>                 <reportElement mode="Opaque" x="311" y="0" width="112"                                height="20" backcolor="#C3D4E8"                                uuid="bdd17002-54ba-4799-900d-07050f959f38">                     <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                     <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                 </reportElement>                 <box>                     <topPen    lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <leftPen   lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <rightPen  lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                 </box>                 <textElement textAlignment="Center" verticalAlignment="Middle"/>                 <textFieldExpression><![CDATA["RESOURCE"]]></textFieldExpression>            </textField>        </band>    </columnHeader>    <detail>        <band height="367" splitType="Stretch">            <textField>                 <reportElement mode="Opaque" x="1" y="10" width="155"                                height="20" backcolor="#C3D4E8"                                uuid="4f2b7785-96a9-4f1c-ae40-867cb36add7e">                     <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                     <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                 </reportElement>                 <box>                     <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                     <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>                 </box>                 <textElement textAlignment="Center" verticalAlignment="Middle"/>                 <textFieldExpression>                     <![CDATA[$F{PARAMETERNAME}]]>                 </textFieldExpression>             </textField>         </band>    </detail>    <columnFooter>        <band height="12"/>    </columnFooter>    <pageFooter>        <band height="19"/>    </pageFooter>    <lastPageFooter>        <band height="50"/>    </lastPageFooter>    <summary>        <band height="131"/>    </summary>    <no<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.0.final using JasperReports Library version 6.1.0 --><!-- 2019-01-18T11:33:31 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"              xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"              name="TemplateReport" pageWidth="595" pageHeight="842"              whenNoDataType="NoDataSection" columnWidth="575"              leftMargin="10" rightMargin="10" topMargin="1" bottomMargin="20"              resourceBundle="dce.util.report.JRDummyResourceBundle"              whenResourceMissingType="Error" uuid="d7df3712-9f23-4ad5-912d-6b79cb435936">    <property name="ireport.zoom" value="1.610510000000001"/>    <property name="ireport.x" value="0"/>    <property name="ireport.y" value="0"/>    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Live_datawarehouse"/>    <property name="com.jaspersoft.studio.unit." value="pixel"/>    <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>    <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>    <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>    <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>    <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>    <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>    <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>    <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>    <style name="Column Header" mode="Opaque" forecolor="#000000"           backcolor="#C3D4E8" fill="Solid" hTextAlign="Center"           hImageAlign="Center" vTextAlign="Middle" vImageAlign="Middle"           fontSize="8" isBold="true">        <box>            <topPen    lineWidth="1.0" lineColor="#000000"/>            <leftPen   lineWidth="1.0" lineColor="#000000"/>            <bottomPen lineWidth="1.0" lineColor="#000000"/>            <rightPen  lineWidth="1.0" lineColor="#000000"/>        </box>    </style>    <style name="Report Title" fontSize="14" isBold="true" isItalic="false"           isUnderline="false" isStrikeThrough="false"/>    <style name="Subreport Title"/>    <style name="Detail" forecolor="#000000" fontSize="8" isBold="false"           isItalic="false" isUnderline="false" isStrikeThrough="false"/>    <style name="Report Parameters" mode="Opaque" forecolor="#000000"           backcolor="#FFFFFF" hTextAlign="Left" hImageAlign="Left"           fontName="SansSerif" fontSize="10" isBold="true" isItalic="false"           isUnderline="false" isStrikeThrough="false">        <box>            <pen       lineWidth="0.0"/>            <topPen    lineWidth="0.0"/>            <leftPen   lineWidth="0.0"/>            <bottomPen lineWidth="0.0"/>            <rightPen  lineWidth="0.0"/>        </box>    </style>    <style name="Page Footer"/>    <parameter name="DATABASE_VENDOR" class="java.lang.String"               isForPrompting="false">        <defaultValueExpression><![CDATA["SQLSERVER"]]></defaultValueExpression>    </parameter>    <parameter name="PARAMETER" class="java.lang.String"               isForPrompting="false">        <defaultValueExpression><![CDATA["Test"]]></defaultValueExpression>    </parameter>    <parameter name="MACHINE_NAME" class="java.lang.String"               isForPrompting="false">        <parameterDescription><![CDATA[]]></parameterDescription>        <defaultValueExpression><![CDATA[]]></defaultValueExpression>    </parameter>    <parameter name="MACHINE_NAME_LIST" class="java.util.List"               isForPrompting="false"/>    <parameter name="MACHINE_NAME_SQLFILTER" class="java.lang.String"               isForPrompting="false">        <defaultValueExpression>            <![CDATA[dce.util.report.JRUtils.getInClause($P{DATABASE_VENDOR}, "machine.OID", (($P{MACHINE_NAME} != null) ? $P{MACHINE_NAME} : $P{MACHINE_NAME_LIST}))]]>        </defaultValueExpression>    </parameter>    <parameter name="FROM_DATE" class="java.util.Date" isForPrompting="false">        <defaultValueExpression><![CDATA[]]></defaultValueExpression>    </parameter><parameter name="FROM_DATE_SQLVALUE" class="java.lang.String" isForPrompting="false"><defaultValueExpression><![CDATA[dce.util.report.JRUtils.getSQLValue($P{DATABASE_VENDOR}, $P{FROM_DATE})]]></defaultValueExpression></parameter><parameter name="TO_DATE" class="java.util.Date" isForPrompting="false"/><parameter name="TO_DATE_SQLVALUE" class="java.util.Date" isForPrompting="false"><defaultValueExpression><![CDATA[dce.util.report.JRUtils.getSQLValue($P{DATABASE_VENDOR}, $P{TO_DATE})]]></defaultValueExpression></parameter><parameter name="BATCH" class="java.lang.String"/><parameter name="VALUE" class="java.lang.Double" isForPrompting="false"/><queryString><![CDATA[select * from DCEVIEW_DATACOLLECTIONINSTRUCTIONSwhere PRODUCTIONORDER = '723z9'and PARAMETERNAME = 'MELTTEMPERATUUR EXTRUDER']]></queryString><field name="PRODUCTIONORDER" class="java.lang.String"/><field name="PRODUCTIONOPERATION" class="java.lang.String"/><field name="PRODUCTIONDESCRIPTION" class="java.lang.String"/><field name="PROCESSRESOURCE" class="java.lang.String"/><field name="INSTRUCTIONNAME" class="java.lang.String"/><field name="INSTRUCTIONDESCRIPTION" class="java.lang.String"/><field name="PARAMETERNAME" class="java.lang.String"/><field name="PARAMETERDESCRIPTION" class="java.lang.String"/><field name="VALUE" class="java.lang.Double"/><field name="TARGET" class="java.lang.Double"/><field name="UOM" class="java.lang.String"/><field name="DATE" class="java.lang.String"/><variable name="TIJD" class="java.lang.String"/><background><band splitType="Stretch"/></background><title><band height="281" splitType="Stretch"><lineChart><chart evaluationTime="Report"><reportElement x="50" y="81" width="384" height="200" uuid="142ad0c1-5fca-4196-9aa9-d6188f8dbd4d"/><chartTitle/><chartSubtitle/><chartLegend/></chart><categoryDataset><categorySeries><seriesExpression><![CDATA["SERIES 1"]]></seriesExpression><categoryExpression><![CDATA[$F{DATE}]]></categoryExpression><valueExpression><![CDATA[$F{VALUE}]]></valueExpression><labelExpression><![CDATA[$F{DATE}]]></labelExpression></categorySeries></categoryDataset><linePlot><plot/><categoryAxisFormat><axisFormat/></categoryAxisFormat><valueAxisFormat><axisFormat/></valueAxisFormat></linePlot></lineChart></band></title><pageHeader><band height="62"><textField><reportElement style="Report Title" x="10" y="26" width="220" height="24" uuid="1a52e80e-2beb-416b-9728-ccec0acda242"><property name="com.jaspersoft.studio.unit.x" value="pixel"/></reportElement><textElement verticalAlignment="Middle"><font size="14" isBold="true"/></textElement><textFieldExpression><![CDATA["OPERATOR AANWEZIGHEID"]]></textFieldExpression></textField><line><reportElement key="line-3" x="1" y="50" width="570" height="1" uuid="6d7d3e54-bb41-4cf7-bc29-616fbb6fd5d6"/></line><textField><reportElement x="350" y="26" width="114" height="24" uuid="88c57c9a-9afe-4d8c-9164-9d897a4301bf"><property name="com.jaspersoft.studio.unit.height" value="pixel"/><property name="com.jaspersoft.studio.unit.y" value="pixel"/></reportElement><textElement verticalAlignment="Middle"><font size="12" isBold="true"/></textElement><textFieldExpression><![CDATA["$F{PRODUCTIONORDER}"]]></textFieldExpression></textField><textField><reportElement x="220" y="26" width="132" height="24" uuid="dcdc1c70-fa8d-480b-b2c6-c76825e7f835"><property name="com.jaspersoft.studio.unit.height" value="pixel"/><property name="com.jaspersoft.studio.unit.y" value="pixel"/></reportElement><textElement verticalAlignment="Middle"><font size="12" isBold="false"/></textElement><textFieldExpression><![CDATA["PRODUCTIEORDER;"]]></textFieldExpression></textField></band></pageHeader><columnHeader><band height="20" splitType="Stretch"><textField><reportElement mode="Opaque" x="156" y="0" width="155" height="20" backcolor="#C3D4E8" uuid="4584a47e-dfb5-4ab0-99c5-f8acf6fa526c"><property name="com.jaspersoft.studio.unit.height" value="pixel"/><property name="com.jaspersoft.studio.unit.width" value="pixel"/></reportElement><box><topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA["PARAMETER"]]></textFieldExpression></textField><textField><reportElement mode="Opaque" x="423" y="0" width="73" height="20" backcolor="#C3D4E8" uuid="58c5cdeb-3630-4824-b162-cd6c4a3e72d3"><property name="com.jaspersoft.studio.unit.height" value="pixel"/><property name="com.jaspersoft.studio.unit.width" value="pixel"/><property name="com.jaspersoft.studio.unit.x" value="pixel"/></reportElement><box><topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA["START"]]></textFieldExpression></textField><textField><reportElement mode="Opaque" x="496" y="0" width="73" height="20" backcolor="#C3D4E8" uuid="41a67790-a020-45dd-9a84-6ebc0c57317c"><property name="com.jaspersoft.studio.unit.height" value="pixel"/><property name="com.jaspersoft.studio.unit.width" value="pixel"/><property name="com.jaspersoft.studio.unit.x" value="pixel"/></reportElement><box><topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA["STOP"]]></textFieldExpression></textField><textField><reportElement mode="Opaque" x="1" y="0" width="155" height="20" backcolor="#C3D4E8" uuid="ecff25db-3e09-47bc-9d8e-388194fde5e2"><property name="com.jaspersoft.studio.unit.height" value="pixel"/></reportElement><box><topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA["DATACOLLECTIE"]]></textFieldExpression></textField><textField><reportElement mode="Opaque" x="311" y="0" width="112" height="20" backcolor="#C3D4E8" uuid="bdd17002-54ba-4799-900d-07050f959f38"><property name="com.jaspersoft.studio.unit.height" value="pixel"/><property name="com.jaspersoft.studio.unit.width" value="pixel"/></reportElement><box><topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA["RESOURCE"]]></textFieldExpression></textField></band></columnHeader><detail><band height="367" splitType="Stretch"><textField><reportElement mode="Opaque" x="1" y="10" width="155" height="20" backcolor="#C3D4E8" uuid="4f2b7785-96a9-4f1c-ae40-867cb36add7e"><property name="com.jaspersoft.studio.unit.height" value="pixel"/><property name="com.jaspersoft.studio.unit.width" value="pixel"/></reportElement><box><topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{PARAMETERNAME}]]></textFieldExpression></textField></band></detail><columnFooter><band height="12"/></columnFooter><pageFooter><band height="19"/></pageFooter><lastPageFooter><band height="50"/></lastPageFooter><summary><band height="131"/></summary><noData><band height="50"/></noData></jasperReport>Data><band height="50"/></noData></jasperReport>[/code]

 

Link to comment
Share on other sites

OK, I think the problem is that you are running the chart on the main dataset. From the Jasper Studio User Guide : The Detail band will repeat for every row in the query results ..

If you create a subDataset and base the chart on that you should get the result you're after . Right click at the top of the Outline, select 'Create Dataset' then follow the bouncing ball ..

 

Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...