Planet Jaspersoft

Filter by tags:

February 4, 2020


Wrong : "<style forecolor='#ffffff' size='14'>Sadakar & Rohit </style>"

Correct : "<style forecolor='#ffffff' size='14'>Sadakar &amp; Rohit </style>"

Reason: Styled Markup takes XML symbols\syntax's

Sample output: 


February 4, 2020

In J.Design  Studio: Drag a text field (not static text) and in the properties give Markup=Styled


Expression inside text field :
"<style forecolor='#ffffff' size='14'> Hi,I am red in color..!</style>"

Sample output: 

References: 
https://community.jaspersoft.com/blog/tip-half-colored-text-static-text-field-or-text-field-jasper-reports-or-basic-usage-markup

https://infosys.ars.usda.gov/svn/code/third_party/Jasper_Reports/jasperreports-4.6.0-project/jasperreports-4.6.0/dist/docs/sample.reference/styledtext/index.html

attributes supported by the <style isBold="true">style</style> 
tag used to format the text content inside a styled text element:

fontName
<style size="32">size</style>
<style isBold="true">isBold</style>
<style isItalic="true">isItalic</style>
<style isUnderline="true">isUnderline</style>
<style isStrikeThrough="true">isStrikeThrough</style>
pdfFontName
pdfEncoding
isPdfEmbedded
<style forecolor="red">forecolor</style>
<style backcolor="blue" forecolor="white" isBold="true">backcolor</style>

February 4, 2020

June 21, 2019

Load Data

rajeshsirsikar
Rajesh Sirsikar )

In this final section we look at the data load. Here we will use the same tUnpivot row component to transpose the actual row data into columns and assign the column values […]

June 21, 2019

Manage Order

rajeshsirsikar
Rajesh Sirsikar )

This section is direct extraction from Bekwam Blog Here we will assign the value of primary columns to a HashMap object called fieldname. Input file is the same input file from tFileList […]

June 21, 2019

Unpivot

rajeshsirsikar
Rajesh Sirsikar )

This section is where we need to transpose the row structure of the config file to columns so that we can use it as a lookup table later. We use tFile delimited […]

June 21, 2019

In this section we will use the Limit property of tInputFileDelimited component and fetch only the column headers. then will load this into a file Set up of input file is as […]

June 21, 2019

June 20, 2019

This week got a request from one of my client to process over 100 csv files into one master file with a unique schema using TOS. There were multiple challenges. The schema […]

June 20, 2019

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

Pages

Feedback