Planet Jaspersoft

Filter by tags:

June 12, 2019

Sample output





JRXML (Copy paste this below xml in your environment)


<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0  -->
<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="GAUGES_Chart" pageWidth="800" pageHeight="842" columnWidth="760" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="81251d9d-a3bb-4e53-83dc-72425b025624">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.report.resource" value="/Explore/GAUGES_Report_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/Explore/GAUGES_Report"/>
<subDataset name="Dataset1" uuid="dbf58f8c-bb29-4b1f-97db-7262c4f2aa8d">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<queryString language="SQL">
<![CDATA[SELECT 35 AS value1]]>
</queryString>
<field name="value1" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="value1"/>
</field>
</subDataset>
<subDataset name="Dataset2" uuid="3af570a8-707d-43e0-8e46-4a1ccae7f95c">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<queryString language="SQL">
<![CDATA[SELECT 56 AS value2]]>
</queryString>
<field name="value2" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="value2"/>
</field>
</subDataset>
<subDataset name="Dataset3" uuid="290f42ab-46fb-461d-9d52-b47439cce88b">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<queryString language="SQL">
<![CDATA[SELECT 67 AS value3]]>
</queryString>
<field name="value3" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="value3"/>
</field>
</subDataset>
<subDataset name="Dataset4" uuid="b0869fcd-44a9-4ee3-abe5-285a2ce32f3f">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<queryString language="SQL">
<![CDATA[SELECT 50 AS value4]]>
</queryString>
<field name="value4" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="value4"/>
</field>
</subDataset>
<queryString language="SQL">
<![CDATA[select 1 as One]]>
</queryString>
<field name="one" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="one"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="543" splitType="Stretch">
<componentElement>
<reportElement x="-20" y="140" width="220" height="220" uuid="5a913c09-961e-4e39-af73-3bc70bcc96da">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<fw:angularGauge xmlns:fw="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd">
<fw:widgetProperty name="gaugeStartAngle">
<fw:propertyExpression><![CDATA[225]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeEndAngle">
<fw:propertyExpression><![CDATA[-50]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeValuesInside">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeTicksInside">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(2)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="label">
<fw:propertyExpression><![CDATA["TEST"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(0)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotRadius">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillAngle">
<fw:propertyExpression><![CDATA[new Integer(5)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimit">
<fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="lowerLimitDisplay">
<fw:propertyExpression><![CDATA["0"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimitDisplay">
<fw:propertyExpression><![CDATA["100"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="bgColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="borderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMNumber">
<fw:propertyExpression><![CDATA[10]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickValues">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showLimits">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showValue">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showShadow">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="valueBelowPivot">
<fw:propertyExpression><![CDATA[1]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[2]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:colorRange color="#C50F01">
<fw:minValueExpression><![CDATA[new Integer(0)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(45)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["RED"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#F9AF02">
<fw:minValueExpression><![CDATA[new Integer(46)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(65)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["YELLOW"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#00B050">
<fw:minValueExpression><![CDATA[new Integer(66)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(100)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["GREEN"]]></fw:labelExpression>
</fw:colorRange>
<dataset>
<datasetRun subDataset="Dataset1" uuid="a25baec4-2880-4216-8857-35e666a6d7a6"/>
</dataset>
<fw:dial>
<fw:dialProperty name="showValue">
<fw:propertyExpression><![CDATA[$F{value1}]]></fw:propertyExpression>
</fw:dialProperty>
<fw:dialProperty name="bgColor">
<fw:propertyExpression><![CDATA["#cc0505"]]></fw:propertyExpression>
</fw:dialProperty>
<fw:valueExpression><![CDATA[$F{value1}]]></fw:valueExpression>
</fw:dial>
</fw:angularGauge>
</componentElement>
<textField>
<reportElement x="53" y="310" width="75" height="25" uuid="642fe559-da15-4142-9c03-490cd6c7ff09"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="9"/>
</textElement>
<textFieldExpression><![CDATA["LABEL"]]></textFieldExpression>
</textField>
<componentElement>
<reportElement x="250" y="0" width="220" height="220" uuid="44cb82b4-c3bf-4016-a4d1-15af0c631eae">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<fw:angularGauge xmlns:fw="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd">
<fw:widgetProperty name="gaugeStartAngle">
<fw:propertyExpression><![CDATA[225]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeEndAngle">
<fw:propertyExpression><![CDATA[-50]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeValuesInside">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeTicksInside">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(2)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="label">
<fw:propertyExpression><![CDATA["TEST"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(0)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotRadius">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillAngle">
<fw:propertyExpression><![CDATA[new Integer(5)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimit">
<fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="lowerLimitDisplay">
<fw:propertyExpression><![CDATA["0"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimitDisplay">
<fw:propertyExpression><![CDATA["100"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="bgColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="borderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMNumber">
<fw:propertyExpression><![CDATA[10]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickValues">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showLimits">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showValue">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showShadow">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="valueBelowPivot">
<fw:propertyExpression><![CDATA[1]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[2]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:colorRange color="#C50F01">
<fw:minValueExpression><![CDATA[new Integer(0)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(45)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["RED"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#F9AF02">
<fw:minValueExpression><![CDATA[new Integer(46)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(65)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["YELLOW"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#00B050">
<fw:minValueExpression><![CDATA[new Integer(66)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(100)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["GREEN"]]></fw:labelExpression>
</fw:colorRange>
<dataset>
<datasetRun subDataset="Dataset2" uuid="3c06cc6a-04f4-4122-b0e7-f501bd61dc14"/>
</dataset>
<fw:dial>
<fw:dialProperty name="showValue">
<fw:propertyExpression><![CDATA[$F{value2}]]></fw:propertyExpression>
</fw:dialProperty>
<fw:dialProperty name="bgColor">
<fw:propertyExpression><![CDATA["#cc0505"]]></fw:propertyExpression>
</fw:dialProperty>
<fw:valueExpression><![CDATA[$F{value2}]]></fw:valueExpression>
</fw:dial>
</fw:angularGauge>
</componentElement>
<textField>
<reportElement x="319" y="173" width="75" height="25" uuid="d49a634e-6096-4c31-bf3d-daf176d9978b"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="9"/>
</textElement>
<textFieldExpression><![CDATA["LABEL"]]></textFieldExpression>
</textField>
<componentElement>
<reportElement x="540" y="130" width="220" height="220" uuid="12e0bd2a-6708-43a3-92a9-b065054fbbd7">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
</reportElement>
<fw:angularGauge xmlns:fw="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd">
<fw:widgetProperty name="gaugeStartAngle">
<fw:propertyExpression><![CDATA[225]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeEndAngle">
<fw:propertyExpression><![CDATA[-50]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeValuesInside">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeTicksInside">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(2)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="label">
<fw:propertyExpression><![CDATA["TEST"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(0)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotRadius">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillAngle">
<fw:propertyExpression><![CDATA[new Integer(5)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimit">
<fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="lowerLimitDisplay">
<fw:propertyExpression><![CDATA["0"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimitDisplay">
<fw:propertyExpression><![CDATA["100"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="bgColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="borderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMNumber">
<fw:propertyExpression><![CDATA[10]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickValues">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showLimits">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showValue">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showShadow">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="valueBelowPivot">
<fw:propertyExpression><![CDATA[1]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[2]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:colorRange color="#C50F01">
<fw:minValueExpression><![CDATA[new Integer(0)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(45)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["RED"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#F9AF02">
<fw:minValueExpression><![CDATA[new Integer(46)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(65)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["YELLOW"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#00B050">
<fw:minValueExpression><![CDATA[new Integer(66)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(100)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["GREEN"]]></fw:labelExpression>
</fw:colorRange>
<dataset>
<datasetRun subDataset="Dataset3" uuid="afe8028c-a5fb-4f77-90e0-3b7fd5cb1041"/>
</dataset>
<fw:dial>
<fw:dialProperty name="showValue">
<fw:propertyExpression><![CDATA[$F{value3}]]></fw:propertyExpression>
</fw:dialProperty>
<fw:dialProperty name="bgColor">
<fw:propertyExpression><![CDATA["#cc0505"]]></fw:propertyExpression>
</fw:dialProperty>
<fw:valueExpression><![CDATA[$F{value3}]]></fw:valueExpression>
</fw:dial>
</fw:angularGauge>
</componentElement>
<textField>
<reportElement x="620" y="310" width="75" height="25" uuid="5b9a8b0a-54e2-4ade-bcc7-06afc4cc6587"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="9"/>
</textElement>
<textFieldExpression><![CDATA["LABEL"]]></textFieldExpression>
</textField>
<componentElement>
<reportElement x="210" y="223" width="300" height="320" uuid="97e64a44-6015-4215-b942-e3d0443aecbd">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<fw:angularGauge xmlns:fw="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd">
<fw:widgetProperty name="gaugeStartAngle">
<fw:propertyExpression><![CDATA[225]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeEndAngle">
<fw:propertyExpression><![CDATA[-50]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeValuesInside">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="placeTicksInside">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(2)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="gaugeBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="label">
<fw:propertyExpression><![CDATA["TEST"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotBorderThickness">
<fw:propertyExpression><![CDATA[new Integer(0)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotRadius">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="pivotFillAngle">
<fw:propertyExpression><![CDATA[new Integer(5)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimit">
<fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="lowerLimitDisplay">
<fw:propertyExpression><![CDATA["0"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="upperLimitDisplay">
<fw:propertyExpression><![CDATA["100"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="bgColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="borderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMNumber">
<fw:propertyExpression><![CDATA[10]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickValues">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showLimits">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showValue">
<fw:propertyExpression><![CDATA[Boolean.TRUE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showShadow">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="valueBelowPivot">
<fw:propertyExpression><![CDATA[1]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="majorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMHeight">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="minorTMThickness">
<fw:propertyExpression><![CDATA[0]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="tickValueDistance">
<fw:propertyExpression><![CDATA[2]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:colorRange color="#C50F01">
<fw:minValueExpression><![CDATA[new Integer(0)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(45)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["RED"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#F9AF02">
<fw:minValueExpression><![CDATA[new Integer(46)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(65)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["YELLOW"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#00B050">
<fw:minValueExpression><![CDATA[new Integer(66)]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[new Integer(100)]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["GREEN"]]></fw:labelExpression>
</fw:colorRange>
<dataset>
<datasetRun subDataset="Dataset4" uuid="c0182866-e95f-4e02-abc2-8e57441916be"/>
</dataset>
<fw:dial>
<fw:dialProperty name="showValue">
<fw:propertyExpression><![CDATA[$F{value4}]]></fw:propertyExpression>
</fw:dialProperty>
<fw:dialProperty name="bgColor">
<fw:propertyExpression><![CDATA["#cc0505"]]></fw:propertyExpression>
</fw:dialProperty>
<fw:valueExpression><![CDATA[$F{value4}]]></fw:valueExpression>
</fw:dial>
</fw:angularGauge>
</componentElement>
<textField>
<reportElement x="292" y="463" width="110" height="60" uuid="df95c80c-3337-407f-bc2a-17438c500313"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="10"/>
</textElement>
<textFieldExpression><![CDATA["LABEL"]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>

June 12, 2019

How to in scatter plot advanced properties ?




API property
 plotOptions: {
        series: {
            marker: {
                radius: 1
            }
        }


Refer this fiddle 

https://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/highcharts/plotoptions/series-marker-radius/

June 12, 2019

Sample output



SQL and data preparation 

create table scatterplot_jasper_highcarts(gender_series text, measure1 integer , measure2 float)

select * from scatterplot_jasper_highcarts

INSERT INTO scatterplot_jasper_highcarts (gender_series,measure1,measure2) VALUES
('f',35000.00,350.53)
,('m',35000.00,256.03)
,('f',45000.00,315.36)
,('m',45000.00,162.11)
,('f',50000.00,260.12)
,('f',50000.00,220.54)
,('f',50000.00,274.39)
,('f',50000.00,189.90)
,('m',50000.00,216.15)
,('m',50000.00,218.36)


INSERT INTO scatterplot_jasper_highcarts (gender_series,measure1,measure2) VALUES
('m',50000.00,214.47)
,('m',50000.00,172.80)
,('f',50000.00,183.29)
,('m',55000.00,323.93)
,('f',60000.00,219.95)
,('f',60000.00,204.66)
,('f',60000.00,208.88)
,('f',60000.00,216.76)
,('m',60000.00,239.10)
,('m',65000.00,208.76)
;



JRXML ( developed on 7.1.1 professional) 

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0  -->
<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="Benchmarking Avg. Deductible is &lt;450k" pageWidth="620" pageHeight="440" whenNoDataType="AllSectionsNoDetail" columnWidth="620" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true" uuid="ea6e0229-23a6-43f3-bec9-122a187df2a5">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="explore - postgres"/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.reportUnit" value="/Explore/Plot_All_data_points_explore"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.report.unit.description" value="IllustrativeRenewalPackage"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.jasperreports.highcharts.interactive" value="false"/>
<property name="ireport.jasperserver.report.resource" value="/Explore/Plot_All_data_points_explore_files/main_jrxml"/>
<queryString>
<![CDATA[select * from scatterplot_jasper_highcarts]]>
</queryString>
<field name="gender_series" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="gender_series"/>
<property name="com.jaspersoft.studio.field.tree.path" value="scatterplot_jasper_highcarts"/>
</field>
<field name="measure1" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="measure1"/>
<property name="com.jaspersoft.studio.field.tree.path" value="scatterplot_jasper_highcarts"/>
</field>
<field name="measure2" class="java.lang.Double">
<property name="com.jaspersoft.studio.field.label" value="measure2"/>
<property name="com.jaspersoft.studio.field.tree.path" value="scatterplot_jasper_highcarts"/>
</field>
<title>
<band height="440" splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<componentElement>
<reportElement x="0" y="0" width="620" height="440" uuid="61f9bb70-9738-4a8e-bb56-2be60b25ee72"/>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Scatter" evaluationTime="Report">
<hc:chartSetting name="default">
<hc:chartProperty name="credits.enabled" value="false"/>
<hc:chartProperty name="credits.href" value=""/>
<hc:chartProperty name="credits.text" value=""/>
<hc:chartProperty name="chart.zoomType" value="xy"/>
<hc:chartProperty name="legend.enabled_customSimpleMode" value="true"/>
<hc:chartProperty name="legend.enabled">
<hc:propertyExpression><![CDATA[true]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.series.marker.radius">
<hc:propertyExpression><![CDATA[6]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="title.text" value="Scatter plot demo"/>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset/>
<dataAxis axis="Rows">
<axisLevel name="Level1">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket class="java.lang.Comparable">
<bucketExpression><![CDATA[$V{REPORT_COUNT}]]></bucketExpression>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<dataAxis axis="Columns">
<axisLevel name="&quot;gender&quot;">
<labelExpression><![CDATA[]]></labelExpression>
<axisLevelBucket class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{gender_series}]]></bucketExpression>
<labelExpression><![CDATA["gender"]]></labelExpression>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<multiAxisMeasure name="measure1" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["measure1"]]></labelExpression>
<valueExpression><![CDATA[$F{measure1}]]></valueExpression>
</multiAxisMeasure>
<multiAxisMeasure name="measure2" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["measure2"]]></labelExpression>
<valueExpression><![CDATA[$F{measure2}]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
<hc:series name="measure1"/>
<hc:series name="measure2"/>
</hc:chart>
</componentElement>
</band>
</title>
</jasperReport>

June 12, 2019

November 20, 2018

Hi, 

Set below property in chart Advanced properties to get the back-ground image for a column chart. 


<hc:chartProperty name="chart.plotBackgroundImage">
<hc:propertyExpression><![CDATA["https://www.tibco.com/blog/wp-content/uploads/2016/03/rsz_bigstock-global-network-mesh-social-co-85856486.jpg"]]></hc:propertyExpression>
</hc:chartProperty>

JRXML(works from 7.2 pro or later)

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0  -->
<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="1 Bar Chart" pageWidth="900" pageHeight="842" columnWidth="860" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e3eaa82e-0ebf-4040-9ffa-69e6d8f80d09">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.report.resource" value="/public/HTML_5_Advanced_2018_19/Bar/3_Bar_Chart_Background_image_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/public/HTML_5_Advanced_2018_19/Bar/3_Bar_Chart_Background_image"/>
<queryString>
<![CDATA[SELECT
    p.brand_name,
    SUM(sf7.store_sales) store_sales
FROM product p
INNER JOIN sales_fact_1997 sf7
    ON p.product_id=sf7.product_id
GROUP BY p.brand_name
ORDER BY
SUM(sf7.store_sales)
limit 10]]>
</queryString>
<field name="brand_name" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="brand_name"/>
<property name="com.jaspersoft.studio.field.tree.path" value="product"/>
</field>
<field name="store_sales" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="store_sales"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="416" splitType="Stretch">
<componentElement>
<reportElement x="0" y="30" width="750" height="360" uuid="214b17e1-736c-4964-904a-3eb532865e08">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Column">
<hc:chartSetting name="default">
<hc:chartProperty name="title.text" value=""/>
<hc:chartProperty name="credits.enabled" value="false"/>
<hc:chartProperty name="credits.href" value=""/>
<hc:chartProperty name="credits.text" value=""/>
<hc:chartProperty name="yAxis.title.text" value=""/>
<hc:chartProperty name="chart.zoomType" value="xy"/>
<hc:chartProperty name="chart.options3d.enabled_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.alpha_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.beta_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.depth_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.viewDistance_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.borderWidth_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.borderRadius_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.plotBackgroundImage">
<hc:propertyExpression><![CDATA["https://www.tibco.com/blog/wp-content/uploads/2016/03/rsz_bigstock-global-network-mesh-social-co-85856486.jpg"]]></hc:propertyExpression>
</hc:chartProperty>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset/>
<dataAxis axis="Rows">
<axisLevel name="Level1">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket order="None" class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{brand_name}]]></bucketExpression>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<dataAxis axis="Columns"/>
<multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["sales"]]></labelExpression>
<valueExpression><![CDATA[$F{store_sales}]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
<hc:series name="Measure1"/>
</hc:chart>
</componentElement>
</band>
</summary>
</jasperReport>

November 20, 2018

November 19, 2018

This blog is to explain how I achieved scrolling text on 2 zone FC16 display module (MAX7219) with Big Font and customizable text using a web page. I have used Parola library and the example code provided in it. Click here to download the Library. For base of this project, I have merged two exmaple codes Parola_Scrolling_ESP8266 Parola_Double_Height_v2 The schematic of the […]

November 19, 2018

November 17, 2018

Hi,

Convert a basic HTML-5 pie chart to have HTML-5 3D look and feel by setting up below advanced properties for the graph.




API properties:

 chart: {
        type: 'pie',
        options3d: {
            enabled: true,
            alpha: 45,
            beta: 0
        }


plotOptions: {
        pie: {
            allowPointSelect: true,
            cursor: 'pointer',
            depth: 35,
            dataLabels: {
                enabled: true,
                format: '{point.name}'
            }
        }


How these are converted to pie chart advanced properties:


References: 
https://www.highcharts.com/demo/3d-pie
https://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/highcharts/demo/3d-pie/

JRXML (Supports in 7.2 pro or later)
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0  -->
<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="pieChart" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="9c2bb08a-3188-44e0-b308-9db8c18be066">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="306"/>
<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="687"/>
<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="361"/>
<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="625"/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.report.resource" value="/public/HTML_5_Advanced_2018_19/Pie/9_Pie_Chart_As_3D_Pie_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/public/HTML_5_Advanced_2018_19/Pie/9_Pie_Chart_As_3D_Pie"/>
<queryString>
<![CDATA[SELECT
occupation,
SUM(num_cars_owned) cars
FROM customer
GROUP BY occupation
ORDER BY occupation]]>
</queryString>
<field name="occupation" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="occupation"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="cars" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="cars"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="344" splitType="Stretch">
<componentElement>
<reportElement x="0" y="0" width="555" height="344" uuid="bece7be7-9c73-45cb-89f1-ca2552ecdf19"/>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Pie">
<hc:chartSetting name="default">
<hc:chartProperty name="title.text" value=""/>
<hc:chartProperty name="credits.enabled" value="false"/>
<hc:chartProperty name="credits.href" value=""/>
<hc:chartProperty name="credits.text" value=""/>
<hc:chartProperty name="yAxis.title.text" value=""/>
<hc:chartProperty name="chart.zoomType" value="xy"/>
<hc:chartProperty name="com.jaspersoft.studio.highcharts.dataconfiguration.simple" value="true"/>
<hc:chartProperty name="plotOptions.pie.showInLegend" value="true"/>
<hc:chartProperty name="chart.options3d.alpha_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.alpha">
<hc:propertyExpression><![CDATA[45]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="chart.options3d.enabled_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.enabled">
<hc:propertyExpression><![CDATA[true]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.pie.allowPointSelect_customSimpleMode" value="true"/>
<hc:chartProperty name="plotOptions.pie.allowPointSelect">
<hc:propertyExpression><![CDATA[true]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.pie.cursor" value="pointer"/>
<hc:chartProperty name="plotOptions.pie.depth_customSimpleMode" value="true"/>
<hc:chartProperty name="plotOptions.pie.depth">
<hc:propertyExpression><![CDATA[35]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.pie.dataLabels.format" value="{point.name}"/>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset/>
<dataAxis axis="Rows">
<axisLevel name="Level1">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{occupation}]]></bucketExpression>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["Cars"]]></labelExpression>
<valueExpression><![CDATA[$F{cars}]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
</hc:chart>
</componentElement>
</band>
</summary>
</jasperReport>

November 17, 2018

Hi,

Set below advanced properties to get the 3D look and feel of HTML-5 bar chart in jaspersoft studio reports.

In chart advanced settings navigate to chart --> options3d and set the values for the properties as shown in below.


Sample output:
References: 
1) https://community.jaspersoft.com/wiki/advanced-chart-formatting
2) https://www.highcharts.com/demo/3d-column-interactive


JRXML ( Supports : 7.2 professional or later)
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0  -->
<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="1 Bar Chart" pageWidth="900" pageHeight="842" columnWidth="860" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e3eaa82e-0ebf-4040-9ffa-69e6d8f80d09">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.report.resource" value="/public/HTML_5_Advanced_2018_19/Bar/1_Bar_Chart_options3d_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/public/HTML_5_Advanced_2018_19/Bar/1_Bar_Chart_options3d"/>
<queryString>
<![CDATA[SELECT
    p.brand_name,
    SUM(sf7.store_sales) store_sales
FROM product p
INNER JOIN sales_fact_1997 sf7
    ON p.product_id=sf7.product_id
GROUP BY p.brand_name
ORDER BY store_sales DESC ,
  p.brand_name LIMIT 10]]>
</queryString>
<field name="brand_name" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="brand_name"/>
<property name="com.jaspersoft.studio.field.tree.path" value="product"/>
</field>
<field name="store_sales" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="store_sales"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="300" splitType="Stretch">
<componentElement>
<reportElement x="0" y="30" width="680" height="270" uuid="214b17e1-736c-4964-904a-3eb532865e08"/>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Column">
<hc:chartSetting name="default">
<hc:chartProperty name="title.text" value=""/>
<hc:chartProperty name="credits.enabled" value="false"/>
<hc:chartProperty name="credits.href" value=""/>
<hc:chartProperty name="credits.text" value=""/>
<hc:chartProperty name="yAxis.title.text" value=""/>
<hc:chartProperty name="chart.zoomType" value="xy"/>
<hc:chartProperty name="chart.options3d.enabled_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.enabled">
<hc:propertyExpression><![CDATA[true]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="chart.options3d.alpha_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.alpha">
<hc:propertyExpression><![CDATA[15]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="chart.options3d.beta_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.beta">
<hc:propertyExpression><![CDATA[15]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="chart.options3d.depth_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.depth">
<hc:propertyExpression><![CDATA[50]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="chart.options3d.viewDistance_customSimpleMode" value="true"/>
<hc:chartProperty name="chart.options3d.viewDistance">
<hc:propertyExpression><![CDATA[25]]></hc:propertyExpression>
</hc:chartProperty>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset/>
<dataAxis axis="Rows">
<axisLevel name="Level1">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{brand_name}]]></bucketExpression>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<dataAxis axis="Columns"/>
<multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["sales"]]></labelExpression>
<valueExpression><![CDATA[$F{store_sales}]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
<hc:series name="Measure1"/>
</hc:chart>
</componentElement>
</band>
</summary>
</jasperReport>

November 17, 2018

July 17, 2018

Hi,

Composite element allow to create a new element in the palette starting from one or more basic elements, and reuse them whenever you want in any report.

As shown in below image you can take basic elements like Text Field and Ellipse from palette. Right click on the selection of these two to create composite element and give required details(name, description and an icon with position to keep it on the palette).

(NOTE : Click on image to get the best view of content placed)

(NOTE : Click on image to get the best view of content placed)


Composite element allows below actions(Edit, Export and Import)  in studio.

This way you can create a custom element in palette and use in a project if you have to re-use the code/design. i.e., this will give the flexibility of re-usability of design across reports. kinda a components based templates.

References: https://community.jaspersoft.com/wiki/composite-element

- Sadakar Pochampalli


JRXML:(Supports in 6.4.2 professional or later).
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.final using JasperReports Library version 6.4.1  -->
<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="CompositeElementExample" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ab08f6fe-e37c-42b7-8721-c46a41536ae3">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<queryString>
<![CDATA[]]>
</queryString>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="133" splitType="Stretch">
<textField>
<reportElement x="138" y="40" width="100" height="30" uuid="0035655a-100c-4dac-a8b8-a91e6a916b0d"/>
<textFieldExpression><![CDATA["Text Field"]]></textFieldExpression>
</textField>
<ellipse>
<reportElement x="240" y="10" width="100" height="79" uuid="3207973b-e49e-43cc-9611-6ed03ce5b3cd"/>
</ellipse>
</band>
</title>
<pageHeader>
<band height="35" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="61" splitType="Stretch"/>
</columnHeader>
<detail>
<band height="125" splitType="Stretch"/>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>

July 17, 2018

July 16, 2018

Are you tired of easily finding the components of palette to design reports in jaspersoft studio?

You can use the combination of "large icons" with "Layout" as "Columns" instead of routine look and feel. As shown in below image, right click on any empty space in the window, let's say in "Basic Elements" section, right click anywhere and select "Use Large Icons" with  the combination of "Layout" as "Columns" and have an easy access to the components when you write some complex reports. !  



Cheers! Small things sometimes saves a bit time. 

- Sadakar Pochampalli 

July 16, 2018

Hi, 

Expected output should be as shown in below image. 

Solution: (Read the image properties - outlined red in color)


Related article can be found here : 
http://jasper-bi-suite.blogspot.com/2016/03/tip-detail-overflow-vs-streach-with.html

JRXML(Supports in 6.4.2 professional version)

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.final using JasperReports Library version 6.4.1  -->
<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="Frames" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5ac4213c-a87a-46d0-bfd2-bfff11545590">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<property name="ireport.callouts" value="callouts.1.fg=0,0,0\ncallouts.1.text=sadakar 7/17/18 1\:20 AM\r\n\r\nAppearance section\r\n------------------------------\r\nPosition Type \= Float\r\nStretch Type \= Relative to Tallest Object\r\n\r\nText field section\r\n--------------------------\r\nCheck Streatch with Overflow\r\n\r\nOther references\r\nhttps\://community.jaspersoft.com/blog/tip-detail-overflow-vs-stretch-overflow-jasper-reports-when-use-how-avoid-repetaitonimages-or\ncallouts.1.bounds=50,60,360,250\ncallouts.1.bg=255,255,0\n"/>
<queryString>
<![CDATA[]]>
</queryString>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="30" splitType="Stretch">
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="30" uuid="eb1d8f3e-313a-469f-a4a9-6585d7c3388a"/>
<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>
<textFieldExpression><![CDATA["Hi"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="100" y="0" width="100" height="30" uuid="8bc5b479-d3d7-4f30-b77a-8d69f2da10e0"/>
<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>
<textFieldExpression><![CDATA["Yakuza Solo hopes his bamboo bicycle will make the world aware of his home state of Nagaland."]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>

July 16, 2018

Pages

Feedback
randomness