reportdev

you need to create a server connection from the repository explorer first to publish. from the Window menu, show view -> other -> JasperReports -> Repository Explorerfrom the repository explorer, right click on servers and create jasper reports server connection with the url and credentials.After adding the connection, when clicked on below icon, it should ask where to publish the report.

http://jasperstudio.sourceforge.net/updates/ is working for me. I'm using eclipse neon.

please refer to this answer http://community.jaspersoft.com/questions/847579/how-increase-jvm-heap-space-studio-6

you can try creating groups and then in the footer, use line element to distinguish the groups.

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --><!-- 2017-01-03T13:52:17 --><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="nestedtable" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="575ddfe7-8d0d-46eb-896f-78ac6ff0cd35"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value=""/> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Dataset1" uuid="0f747fd4-950d-45e2-b317-731459ebe252"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PRODSUP-SRAVAN"/> <queryString> <![CDATA[select month from dummygroup by month]]> </queryString> <field name="MONTH" class="java.sql.Timestamp"/> </subDataset> <subDataset name="Dataset2" uuid="e082d350-530e-4df2-be0b-9cbc8594d1da"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PRODSUP-SRAVAN"/> <parameter name="month" class="java.sql.Timestamp"/> <queryString> <![CDATA[select * from dummywhere month = $P{month}]]> </queryString> <field name="MONTH" class="java.sql.Timestamp"/> <field name="ESTIMATE" class="java.math.BigDecimal"/> <field name="PLAN" class="java.math.BigDecimal"/> <field name="ACTUAL" class="java.math.BigDecimal"/> </subDataset> <queryString> <![CDATA[select * from dual]]> </queryString> <field name="DUMMY" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <detail> <band height="13" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="100" height="10" uuid="8eeea2ce-d4ea-42dc-9ff9-c788294e8f29"/> <textFieldExpression><![CDATA[$F{DUMMY}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="50" splitType="Stretch"> <componentElement> <reportElement x="0" y="0" width="410" height="50" uuid="14f1689d-8d2a-4235-9412-30e778753d0e"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Dataset1" uuid="ba11bb29-5f12-4c30-b8c0-afc49fea06e7"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="110" uuid="10a7f1fa-fc10-4969-a501-c50a7f9973ed"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="110" height="30" uuid="100b742b-76b7-4dd6-aff0-b485fe7332e0"/> <text><![CDATA[Month]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="20"> <textField> <reportElement x="0" y="0" width="110" height="20" uuid="70964673-59ca-48ff-ab7e-cf55e35b0248"/> <textFieldExpression><![CDATA[$F{MONTH}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="300" uuid="9a6c6fbb-36f8-4100-83b0-bc37a81fcd05"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:columnHeader style="Table_CH" height="30" rowSpan="1"/> <jr:detailCell style="Table_TD" height="20"> <componentElement> <reportElement x="0" y="0" width="300" height="20" uuid="b339ce4f-d5be-41c8-8836-9797547f1251"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> </reportElement> <jr:table> <datasetRun subDataset="Dataset2" uuid="8227b756-1f28-4e22-b997-6d8864c4783f"> <datasetParameter name="month"> <datasetParameterExpression><![CDATA[$F{MONTH}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="100" uuid="8f620a10-fd70-4d32-8d01-45cf171bd8f2"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:detailCell style="Table 1_TD" height="20"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> <textField> <reportElement x="0" y="0" width="100" height="20" uuid="f1dd7f2d-a56d-4156-aa55-695b9bd4d7b8"/> <textFieldExpression><![CDATA[$F{ESTIMATE}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="100" uuid="d43d6fc2-a560-4a16-acb6-9fd8b986ced7"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:detailCell style="Table 1_TD" height="20"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> <textField> <reportElement x="0" y="0" width="100" height="20" uuid="edaabbf4-2a67-4572-aa07-d832e7d9e313"/> <textFieldExpression><![CDATA[$F{PLAN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="100" uuid="a38e06ac-551a-454e-a690-8ef39e13acce"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:detailCell style="Table 1_TD" height="20"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> <textField> <reportElement x="0" y="0" width="100" height="20" uuid="f9bd2dbd-d3b8-4754-98f0-8dc00f2b2695"/> <textFieldExpression><![CDATA[$F{ACTUAL}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </summary></jasperReport>[/code]use this as a template... i have created first table element with the groupingin the first table element, i have inserted second table element andpassing the field value into the parameter of second table element, which will filter the second dataset.

try to create parameters and pass that parameter into the dataset sql or through the filter expressions.

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --><!-- 2017-01-03T12:45:54 --><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="chartd" pageWidth="1200" pageHeight="595" orientation="Landscape" columnWidth="1160" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="8d88c78f-93a4-4c56-8cf1-9bc3dce549ac"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value=""/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <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"/> <queryString> <![CDATA[select * from dummy]]> </queryString> <field name="MONTH" class="java.sql.Timestamp"/> <field name="ESTIMATE" class="java.math.BigDecimal"/> <field name="PLAN" class="java.math.BigDecimal"/> <field name="ACTUAL" class="java.math.BigDecimal"/> <variable name="PLAN1" class="java.math.BigDecimal" resetType="Column" calculation="Sum"> <variableExpression><![CDATA[$F{PLAN}]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="80" height="20" uuid="4339a91e-48fb-486a-ace5-10ea8e5b2141"/> <textElement verticalAlignment="Bottom"/> <text><![CDATA[MONTH]]></text> </staticText> <staticText> <reportElement x="80" y="0" width="100" height="20" uuid="66cddfa9-41fa-4f2f-a117-22e9ba12a312"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <text><![CDATA[ESTIMATE]]></text> </staticText> <staticText> <reportElement x="180" y="0" width="100" height="20" uuid="cf8d5d10-e59d-4f33-ba38-6cb3e2319694"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <text><![CDATA[PLAN]]></text> </staticText> <staticText> <reportElement x="280" y="0" width="100" height="20" uuid="30420eea-a4c8-40a4-bd2e-ef7d332ff7ff"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <text><![CDATA[ACTUAL]]></text> </staticText> </band> </columnHeader> <detail> <band height="20" splitType="Stretch"> <textField pattern="MM/dd/yyyy"> <reportElement x="0" y="0" width="80" height="20" uuid="8e696354-6ab4-4533-b597-2fccb5f4087f"/> <textElement verticalAlignment="Bottom"/> <textFieldExpression><![CDATA[$F{MONTH}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="80" y="0" width="100" height="20" uuid="87811c04-4a78-44ed-963b-952f4c532a8d"/> <box rightPadding="5"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <textFieldExpression><![CDATA[$F{ESTIMATE}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="180" y="0" width="100" height="20" uuid="0f37c778-e18a-4ece-b18e-f0fa16c46baf"/> <box rightPadding="5"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <textFieldExpression><![CDATA[$F{PLAN}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="280" y="0" width="100" height="20" uuid="aaa42169-f38c-4605-b7bb-66e9cd52e1ab"/> <box rightPadding="5"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <textFieldExpression><![CDATA[$F{ACTUAL}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="288" splitType="Stretch"> <barChart> <chart evaluationTime="Report"> <reportElement x="0" y="0" width="1160" height="288" uuid="e35b93e9-48f6-4eb3-ae13-8af0c2104613"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["MONTH-ESTIMATE"]]></seriesExpression> <categoryExpression><![CDATA[new SimpleDateFormat("MM/dd/yyyy").format($F{MONTH})]]></categoryExpression> <valueExpression><![CDATA[$F{ESTIMATE}]]></valueExpression> <labelExpression><![CDATA[$F{ESTIMATE}.toString()]]></labelExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["MONTH-PLAN"]]></seriesExpression> <categoryExpression><![CDATA[new SimpleDateFormat("MM/dd/yyyy").format($F{MONTH})]]></categoryExpression> <valueExpression><![CDATA[$F{PLAN}]]></valueExpression> <labelExpression><![CDATA[$F{PLAN}.toString()]]></labelExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["MONTH-ACTUAL"]]></seriesExpression> <categoryExpression><![CDATA[new SimpleDateFormat("MM/dd/yyyy").format($F{MONTH})]]></categoryExpression> <valueExpression><![CDATA[$F{ACTUAL}]]></valueExpression> <labelExpression><![CDATA[$F{ACTUAL}.toString()]]></labelExpression> </categorySeries> </categoryDataset> <barPlot> <plot/> <itemLabel/> <categoryAxisFormat> <axisFormat/> </categoryAxisFormat> <valueAxisFormat> <axisFormat/> </valueAxisFormat> </barPlot> </barChart> </band> </summary></jasperReport>[/code]Use this as a base for your report

we have asked for a enhancement request and it is in the waiting que i believe

check this wiki page http://community.jaspersoft.com/wiki/getting-previous-records-value-calculation-variables-etc

dates spanning across years would become complicated i believe. but its not impossible. in the conditional variables, the year should also be considered and check if its previous / current / next year and then add up.

you can achieve this in multiple ways try using a frametry using html markup textfields and <br> tag to space it properly

the below path works for me on eclipse neon. http://jasperstudio.sourceforge.net/updates/

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --><!-- 2016-12-21T15:52: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="dummy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="772106db-4d95-4301-b793-4344b38a1c77"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <import value="org.apache.commons.lang.time.*"/> <queryString> <![CDATA[select * from dummy]]> </queryString> <field name="NAME" class="java.lang.String"/> <field name="STARTDATE" class="java.sql.Timestamp"/> <field name="ENDDATE" class="java.sql.Timestamp"/> <variable name="January" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Jan", "").length()]]></variableExpression> </variable> <variable name="Febraury" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Feb", "").length()]]></variableExpression> </variable> <variable name="March" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Mar", "").length()]]></variableExpression> </variable> <variable name="April" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Apr", "").length()]]></variableExpression> </variable> <variable name="May" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("May", "").length()]]></variableExpression> </variable> <variable name="June" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Jun", "").length()]]></variableExpression> </variable> <variable name="July" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Jul", "").length()]]></variableExpression> </variable> <variable name="August" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Aug", "").length()]]></variableExpression> </variable> <variable name="September" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Sep", "").length()]]></variableExpression> </variable> <variable name="October" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Oct", "").length()]]></variableExpression> </variable> <variable name="November" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Nov", "").length()]]></variableExpression> </variable> <variable name="December" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Dec", "").length()]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="33" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="eea0aaab-e134-484e-a896-15bc5c4e833a"/> <text><![CDATA[NAME]]></text> </staticText> <staticText> <reportElement x="180" y="0" width="100" height="30" uuid="e14cedaf-633c-4c8f-9bee-141db2774e67"/> <text><![CDATA[sTARTDATE]]></text> </staticText> <staticText> <reportElement x="280" y="1" width="100" height="30" uuid="fd619151-ecd1-4daf-8213-4090638f910e"/> <text><![CDATA[ENDDATE]]></text> </staticText> </band> </columnHeader> <detail> <band height="31" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="180" height="30" uuid="242b10f7-5cef-4a74-934e-0086261467a4"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> <textField> <reportElement x="180" y="0" width="100" height="30" uuid="ba762574-e20f-464f-8f88-333200c7b41a"/> <textFieldExpression><![CDATA[$F{STARTDATE}]]></textFieldExpression> </textField> <textField> <reportElement x="280" y="1" width="100" height="30" uuid="6ba6919f-c95c-425c-879e-b511423c516a"/> <textFieldExpression><![CDATA[$F{ENDDATE}]]></textFieldExpression> </textField> <textField> <reportElement x="480" y="0" width="100" height="30" uuid="333aa204-ed9c-4627-8478-9a871c9b7b82"/> <textFieldExpression><![CDATA[MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :0]]></textFieldExpression> </textField> <textField> <reportElement x="580" y="1" width="100" height="30" uuid="2bb04ca5-7e56-4f6c-8153-c09c77030332"/> <textFieldExpression><![CDATA[CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).length()-CLEAN(MONTHS($F{STARTDATE},$F{ENDDATE}) == 1 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{ENDDATE},0)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 2 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) ) :MONTHS($F{STARTDATE},$F{ENDDATE}) == 3 ?(new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},0)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},1)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},2)) + ", " +new SimpleDateFormat("MMM").format(DateUtils.addMonths($F{STARTDATE},3)) ) :"Not found" ).replace("Feb", "").length()]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="283"> <textField> <reportElement x="80" y="29" width="100" height="19" uuid="56c67b6a-e234-41c5-aeae-ff2a21c91a6a"/> <textFieldExpression><![CDATA[$V{January}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="29" width="80" height="20" uuid="934c850e-37fe-4053-809f-27948930cea3"/> <text><![CDATA[January]]></text> </staticText> <textField> <reportElement x="80" y="50" width="100" height="19" uuid="39f4177d-4888-42c9-bab9-373b814d35eb"/> <textFieldExpression><![CDATA[$V{Febraury}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="50" width="80" height="20" uuid="3022385e-889f-470f-a7da-e09084913d73"/> <text><![CDATA[Febraury]]></text> </staticText> <textField> <reportElement x="80" y="70" width="100" height="19" uuid="face081b-f00b-4999-9e25-074779ded1d9"/> <textFieldExpression><![CDATA[$V{March}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="70" width="80" height="20" uuid="b3ad8e90-3869-49d3-a9a2-ff6914f81e44"/> <text><![CDATA[March]]></text> </staticText> <textField> <reportElement x="80" y="90" width="100" height="19" uuid="1d004f46-2113-45b8-b2a2-2375e5213b04"/> <textFieldExpression><![CDATA[$V{April}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="90" width="80" height="20" uuid="767e576d-e55e-4292-a494-6d769991bc10"/> <text><![CDATA[April]]></text> </staticText> <textField> <reportElement x="80" y="110" width="100" height="19" uuid="c0256799-43f8-4118-a0a7-d53e3a7f203d"/> <textFieldExpression><![CDATA[$V{May}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="110" width="80" height="20" uuid="99a35907-c3b1-40bc-9e05-900720818fc9"/> <text><![CDATA[May]]></text> </staticText> <textField> <reportElement x="80" y="130" width="100" height="19" uuid="c0ba9c5b-2cb8-47a2-bc96-c1cf314f10fd"/> <textFieldExpression><![CDATA[$V{June}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="130" width="80" height="20" uuid="178c5ac3-5960-4e1c-9921-d61e6b5b025e"/> <text><![CDATA[June]]></text> </staticText> <textField> <reportElement x="80" y="150" width="100" height="19" uuid="af0fa35f-dc55-4ad7-a37e-96f3a5c726ab"/> <textFieldExpression><![CDATA[$V{July}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="150" width="80" height="20" uuid="619260bc-9e82-49d1-86c3-ab9150fc49a6"/> <text><![CDATA[July]]></text> </staticText> <textField> <reportElement x="80" y="170" width="100" height="19" uuid="ab782222-f4b1-4b06-830c-586eb7adb289"/> <textFieldExpression><![CDATA[$V{August}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="170" width="80" height="20" uuid="b7440859-aae2-4e5f-85b2-7621401604a4"/> <text><![CDATA[August]]></text> </staticText> <textField> <reportElement x="80" y="190" width="100" height="19" uuid="90a46805-301d-4fb3-8c18-5a369349039c"/> <textFieldExpression><![CDATA[$V{September}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="190" width="80" height="20" uuid="cb07d1eb-77d0-43f9-8199-354183800c5a"/> <text><![CDATA[september]]></text> </staticText> <textField> <reportElement x="80" y="210" width="100" height="19" uuid="e3747477-5559-45dd-97a7-a660b30179ed"/> <textFieldExpression><![CDATA[$V{October}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="210" width="80" height="20" uuid="1501a206-cd24-4989-8b3f-cda00d271b47"/> <text><![CDATA[October]]></text> </staticText> <textField> <reportElement x="80" y="230" width="100" height="19" uuid="b3ff9717-e995-420b-9c98-edafd38f97e2"/> <textFieldExpression><![CDATA[$V{November}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="230" width="80" height="20" uuid="d5091a60-777d-478a-98be-0ad5672735e3"/> <text><![CDATA[November]]></text> </staticText> <textField> <reportElement x="80" y="250" width="100" height="19" uuid="45d11199-7465-4d2c-8bea-6d1107dc7487"/> <textFieldExpression><![CDATA[$V{December}/3]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="250" width="80" height="20" uuid="949fde09-cbf9-4c10-8461-137368166791"/> <text><![CDATA[December]]></text> </staticText> </band> </summary></jasperReport>[/code]Check this jrxml. it might not be accurate enough to your requirement, but i have tried my level best. Currently it considers upto 4 consequtive months between 2 dates. if you want more, then add more conditionals to all the variables.

try to use this link and see if it works https://sourceforge.net/projects/jasperstudio/files/updatesite/6.3.0/

I have also got this error. the resolution that worked for me is: backup this workspacedelete this workspacewhen you open the studio, it creates a new workspace again.copy over your workspace files in to the new workspace

The print when needs to return a boolean. For example, insert this expression into the print when expression ($P{Parameter}.equals("first")) == true In order to stop the unwanted queries hitting the database, you can create a parameter based on your main parameter and limit the no of rows on your sql in three datasets. I would write my 3 sqls as: 1) select * from dual where $P{Parameter} = 'first' 2) select * from dual where $P{Parameter} = 'Second' 3) select * from dual where $P{Parameter} = 'third' For example, i only want the first subreport to showup on the report, then i would pass 'first' into the parameter, which enables the first dataset and returns rows. the second and third dataset would not execute as the condition did not pass.

if i'm understanding your question correctly, do you want to hide the columns dynamically based on a parameter?

it looks like you are missing the report connection parameter. If no connection is passed, then the subreport wont run. Click the subreport from the main report and navigate to Subreport optionsin the Connection Expression -> select the $P{REPORT_CONNECTION}

i think you can use the conditional expressions and find out the length of a string field and assign font size to it. In the below style, I'm checking for the length of the field. Assign Font size 14 if length is less than 10 charactersAssign Font size 11/Bold if length is greater than 10 characters <style name="conditional"> <conditionalStyle> <conditionExpression><![CDATA[$F{ID}.length() < 10 ? true : false]]></conditionExpression> <style fontSize="14"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[$F{ID}.length() > 10 ? true : false]]></conditionExpression> <style fontSize="11" isBold="true"/> </conditionalStyle> </style>

you dont need a license for the community edition. check this page for differences between the editions https://www.jaspersoft.com/editions?_ga=1.181534628.2077368316.1480449217

its hard to guess without your jrxml. I would suggest use the jrxml that i have posted as the base and replace the list dataset with your own dataset.

this can be achieved with first variable to count the records in list datasetsecond variable to get the highest from the first variablereturn value from second list variable to a variable in the main datasetdisplay the return value on the main reportHere is a working sample. <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --> <!-- 2016-12-14T13:52:12 --> <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="list" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d9bbb141-8dfb-40aa-b09d-81140ea6a430"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PRODSUP"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <subDataset name="list" uuid="216b8ad6-195c-44d2-96e6-5c750d85f459"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <queryString> <![CDATA[select 1 as ID from dual union select 2 as ID from dual union select 3 as ID from dual]]> </queryString> <field name="ID" class="java.math.BigDecimal"/> <variable name="Count" class="java.lang.Integer" calculation="Count"> <variableExpression><![CDATA[$F{ID}]]></variableExpression> </variable> <variable name="max_count" class="java.lang.Integer" calculation="Highest"> <variableExpression><![CDATA[$V{Count}]]></variableExpression> </variable> </subDataset> <queryString> <![CDATA[select * from dual]]> </queryString> <field name="DUMMY" class="java.lang.String"/> <variable name="Variable_1" class="java.lang.Integer" resetType="None"/> <background> <band splitType="Stretch"/> </background> <detail> <band height="30" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="100" height="10" uuid="44f9fd26-6561-4926-a0af-b4f8f55152dd"/> <textFieldExpression><![CDATA[$F{DUMMY}]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="180" y="0" width="200" height="30" uuid="7d866c3c-1171-4b8f-b447-0a23b7660d01"/> <textElement> <font isBold="true"/> </textElement> <textFieldExpression><![CDATA["the list has " + $V{Variable_1} + " rows"]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="20" splitType="Stretch"> <componentElement> <reportElement x="180" y="0" width="200" height="20" uuid="2ebeeaba-1db8-4106-9444-59a926860a4f"> <property name="net.sf.jasperreports.export.headertoolbar.table.name" value=""/> </reportElement> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="list" uuid="4dd410cc-f8bf-447a-9014-8643d98c0233"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <returnValue fromVariable="Count" toVariable="Variable_1"/> </datasetRun> <jr:listContents height="20" width="200"> <textField> <reportElement x="0" y="0" width="100" height="20" uuid="fd84641d-4739-4134-b146-b2c664021a6d"/> <textFieldExpression><![CDATA[$F{ID}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </band> </summary> </jasperReport>

please refer to this page https://www.jaspersoft.com/editions

have you created groups for each subreport? if yes, then remove those groups and try putting all the subreports in the summary band.

use this expression on the print when expression of detail band: $P{PARAMX}.equals("Y") ? true : $F{FIEILDX}.equals("PrintMe") && $P{PARAMX}.equals("N")? true : false