dennis.dekker Posted January 17, 2019 Share Posted January 17, 2019 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 More sharing options...
dennis.dekker Posted January 17, 2019 Author Share Posted January 17, 2019 Additional information; it does this in everyband I place the Chart in, Title, Summary, Detail....Below the values in the SQLThe Query;select * from DATACOLLECTIONINSTRUCTIONSwhere PRODUCTIONORDER = '7xxz9'and PARAMETERNAME = 'MELTTEMP EXTRUDER'Trendlinechart properties Link to comment Share on other sites More sharing options...
andycolman Posted January 17, 2019 Share Posted January 17, 2019 Do you want to show us some JRXML ? Link to comment Share on other sites More sharing options...
dennis.dekker Posted January 17, 2019 Author Share Posted January 17, 2019 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 More sharing options...
andycolman Posted January 17, 2019 Share Posted January 17, 2019 Just go to your Source tab, select all, copy, paste ..I'm sure your English is much better than my Dutch ! Link to comment Share on other sites More sharing options...
elizam Posted January 17, 2019 Share Posted January 17, 2019 Have you put the chart in the Details band, by any chance? Aggregate elements, like charts, should go in the Summary band. Link to comment Share on other sites More sharing options...
dennis.dekker Posted January 18, 2019 Author Share Posted January 18, 2019 <?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 More sharing options...
dennis.dekker Posted January 18, 2019 Author Share Posted January 18, 2019 Yes I have tried all bands with the same results. so this does not seem to be the issue, however I might be missing somethingI am new to Jaspersoft so still learning Link to comment Share on other sites More sharing options...
andycolman Posted January 18, 2019 Share Posted January 18, 2019 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 More sharing options...
dennis.dekker Posted January 29, 2019 Author Share Posted January 29, 2019 Hi Andycolman,Sorry for the late response; I enjoyed my vacation.I will try to make the subdataset and report back with the results!Thanks for replying gr. Dennis Link to comment Share on other sites More sharing options...
dennis.dekker Posted January 29, 2019 Author Share Posted January 29, 2019 So your advice helped, creating a subdata set enabled me to just get one page.Sadly the trend line is now no long visible, however I will try and play with the Increment and Reset and see what happens Link to comment Share on other sites More sharing options...
dennis.dekker Posted January 29, 2019 Author Share Posted January 29, 2019 update; somehow the query was no longer in de the dataset, so put it back in. Now the trend line works, but only shows the first measured value, and nog the trend of all values... Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now