shanmugaraj7029

Hi Everyone, Please look the following link, Which shown a Highchart with a vertical line is plotted on X axis. http://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/highcharts/xaxis/plotlines-color/ We are trying to do the same (adding vertical line in a line chart) in a JRXML based chart. I have added the following a property to show the vertical line as mentioned in the above link, <hc:chartProperty name="xAxis.plotLines.value"> <hc:propertyExpression><![CDATA[$F{PERIOD_END}]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.plotLines.width"> <hc:propertyExpression><![CDATA[2]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.plotLines.color"> <hc:propertyExpression><![CDATA["#FF0000"]]></hc:propertyExpression> </hc:chartProperty> Here the "$F{PERIOD_END}" is a Date field only. But, When I add this property into the jrxml, the report was not worked. The entire JRXML file content as follows, <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1 --> <!-- 2017-02-10T15:05:34 --> <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="CumulativeElementPerformance_LockheedAeronautics" pageWidth="1040" pageHeight="600" whenNoDataType="AllSectionsNoDetail" columnWidth="1000" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" whenResourceMissingType="Empty" uuid="ece8adba-64f5-439d-b3f8-a0050ef02f4b"> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.jasperreports.highcharts.function.properties.allowed" value="true"/> <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"/> <parameter name="PROJECT_NAME" class="java.lang.String"/> <parameter name="CATEGORIES" class="java.lang.String"/> <parameter name="ELEMENTS" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[sELECT PERIOD_END "PERIOD_END", PV_CUM_TTL_COST "BCWS", EV_CUM_TTL_COST "BCWP", AC_CUM_TTL_COST "ACWP", ETC_STD_TTL_COST "ETC", EAC_STD_TTL_COST "LRE", ETC_STD_TTL_COST "ETC_AFTER_TIMENOW" FROM AV_EV_SUMMARY WHERE PROJ_ID = $P{PROJECT_NAME} AND TYPE = (SELECT TYPE FROM AV_CATEGORY WHERE CATEGORY = $P{CATEGORIES}) AND ELEMENT = $P{ELEMENTS} AND TRIM(CSACT) IS NULL ORDER BY PERIOD_END]]> </queryString> <field name="PERIOD_END" class="java.util.Date"/> <field name="BCWS" class="java.lang.Double"/> <field name="BCWP" class="java.lang.Double"/> <field name="ACWP" class="java.lang.Double"/> <field name="ETC" class="java.lang.Double"/> <field name="LRE" class="java.lang.Double"/> <field name="ETC_AFTER_TIMENOW" class="java.lang.Double"/> <pageHeader> <band height="50"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="0" y="0" width="1000" height="30" forecolor="#315F85" uuid="4f649a45-77cc-4b1d-b2c9-3d2f25cfd086"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="18" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Cumulative Element Performance"]]></textFieldExpression> </textField> </band> </pageHeader> <summary> <band height="500" splitType="Stretch"> <componentElement> <reportElement x="0" y="0" width="1000" height="500" uuid="064ccd5e-96f5-4033-977c-774111663ffc"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="TimeSeriesSpline"> <hc:chartSetting name="default"> <hc:chartProperty name="chart.plotBorderColor"> <hc:propertyExpression><![CDATA["#F0FFF0"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.plotBorderWidth"> <hc:propertyExpression><![CDATA[new Integer(1)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.plotShadow"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.shadow"> <hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.showAxes"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.zoomType"> <hc:propertyExpression><![CDATA["xy"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="colors"> <hc:propertyExpression><![CDATA[java.util.Arrays.asList("#D070D0","#D0A020","#F08080","#A47D7C","#20B0A0","#708890","#FFA070","#0000E0","#A0B0E0","#80D0F0")]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.enabled"> <hc:propertyExpression><![CDATA[false]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.align"> <hc:propertyExpression><![CDATA["center"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.backgroundColor"> <hc:propertyExpression><![CDATA[new java.awt.Color(-1)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.borderColor"> <hc:propertyExpression><![CDATA["#708890"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.borderRadius"> <hc:propertyExpression><![CDATA[new Integer(5)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.borderWidth"> <hc:propertyExpression><![CDATA[0.5]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.enabled"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.floating"> <hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.itemHoverStyle.color"> <hc:propertyExpression><![CDATA["#FF0000"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.itemMarginBottom"> <hc:propertyExpression><![CDATA[new Integer(5)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.itemMarginTop"> <hc:propertyExpression><![CDATA[new Integer(5)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.layout"> <hc:propertyExpression><![CDATA["horizontal"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.lineHeight"> <hc:propertyExpression><![CDATA[new Integer(20)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.margin"> <hc:propertyExpression><![CDATA[new Integer(15)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.padding"> <hc:propertyExpression><![CDATA[new Integer(8)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.rtl"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.verticalAlign"> <hc:propertyExpression><![CDATA["bottom"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.y"> <hc:propertyExpression><![CDATA[new Integer(0)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.allowPointSelect"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.lineWidth"> <hc:propertyExpression><![CDATA[new Integer(1)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.marker.states.hover.radiusPlus"> <hc:propertyExpression><![CDATA[new Integer(2)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.selected"> <hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.shadow"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.states.hover.enabled"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.states.hover.lineWidth"> <hc:propertyExpression><![CDATA[new Integer(5)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.text"> <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.shared"> <hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.useHTML"> <hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.labels.rotation"> <hc:propertyExpression><![CDATA[new Integer(270)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.labels.step"> <hc:propertyExpression><![CDATA[new Integer(1)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.opposite" value="true"/> <hc:chartProperty name="xAxis.plotLines.value"> <hc:propertyExpression><![CDATA[$F{PERIOD_END}]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.plotLines.width"> <hc:propertyExpression><![CDATA[2]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.plotLines.color"> <hc:propertyExpression><![CDATA["#FF0000"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.alternateGridColor"> <hc:propertyExpression><![CDATA["#F0F7FF"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.gridLineColor"> <hc:propertyExpression><![CDATA["#708090"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.gridLineDashStyle"> <hc:propertyExpression><![CDATA["longdash"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.min"> <hc:propertyExpression><![CDATA[new Integer(0)]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.title.text"> <hc:propertyExpression><![CDATA["Dollars in Millions"]]></hc:propertyExpression> </hc:chartProperty> </hc:chartSetting> <multiAxisData> <multiAxisDataset/> <dataAxis axis="Rows"> <axisLevel name="Level1"> <labelExpression><![CDATA["Level Label expression"]]></labelExpression> <axisLevelBucket class="java.util.Date"> <bucketExpression><![CDATA[$F{PERIOD_END}]]></bucketExpression> </axisLevelBucket> </axisLevel> </dataAxis> <dataAxis axis="Columns"/> <multiAxisMeasure name="Measure1" class="java.lang.Double" calculation="Nothing"> <labelExpression><![CDATA["BCWS"]]></labelExpression> <valueExpression><![CDATA[$F{BCWS}]]></valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Measure2" class="java.lang.Double" calculation="Nothing"> <labelExpression><![CDATA["BCWP"]]></labelExpression> <valueExpression><![CDATA[$F{BCWP}]]></valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Measure3" class="java.lang.Double" calculation="Nothing"> <labelExpression><![CDATA["ACWP"]]></labelExpression> <valueExpression><![CDATA[$F{ACWP}]]></valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Measure4" class="java.lang.Double" calculation="Nothing"> <labelExpression><![CDATA["ETC"]]></labelExpression> <valueExpression><![CDATA[$F{ETC}]]></valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Measure5" class="java.lang.Double" calculation="Nothing"> <labelExpression><![CDATA["LRE"]]></labelExpression> <valueExpression><![CDATA[$F{LRE}]]></valueExpression> </multiAxisMeasure> </multiAxisData> <hc:series name="Measure1"/> <hc:series name="Measure2"/> <hc:series name="Measure3"/> <hc:series name="Measure4"/> <hc:series name="Measure5"/> </hc:chart> </componentElement> </band> </summary> </jasperReport>

Hello to Everyone, I Generated a report through the iReport tool with multiple aggregation operation like sum and count etc. And I have multiple groups for each variables. So, totaly I have 52 variables in my report. As Follows : ---------------- 1. Groups = 4 and Variables under each group is 13. So, the total will be 52. How to avoid this to create more variables in report. The sample variable creation in my report as follows : <variable name="cur_vt1" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{HOURS}]]></variableExpression></variable><variable name="cur_vt2" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{DIRECT}]]></variableExpression></variable><variable name="cur_vt3" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD1}]]></variableExpression></variable><variable name="cur_vt4" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD2}]]></variableExpression></variable><variable name="cur_vt5" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD3}]]></variableExpression></variable><variable name="cur_vt6" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD4}]]></variableExpression></variable><variable name="cur_vt7" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{GA}]]></variableExpression></variable><variable name="cur_vt8" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{HEADS}]]></variableExpression></variable><variable name="cur_vt9" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{UNITS}]]></variableExpression></variable><variable name="cur_vt10" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER1}]]></variableExpression></variable><variable name="cur_vt11" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER2}]]></variableExpression></variable><variable name="cur_vt12" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER3}]]></variableExpression></variable><variable name="cur_vt13" class="java.lang.Integer" resetType="Group" resetGroup="CurrencyGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER4}]]></variableExpression></variable><variable name="ct_vt1" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{HOURS}]]></variableExpression></variable><variable name="ct_vt2" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{DIRECT}]]></variableExpression></variable><variable name="ct_vt3" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD1}]]></variableExpression></variable><variable name="ct_vt4" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD2}]]></variableExpression></variable><variable name="ct_vt5" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD3}]]></variableExpression></variable><variable name="ct_vt6" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD4}]]></variableExpression></variable><variable name="ct_vt7" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{GA}]]></variableExpression></variable><variable name="ct_vt8" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{HEADS}]]></variableExpression></variable><variable name="ct_vt9" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{UNITS}]]></variableExpression></variable><variable name="ct_vt10" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER1}]]></variableExpression></variable><variable name="ct_vt11" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER2}]]></variableExpression></variable><variable name="ct_vt12" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER3}]]></variableExpression></variable><variable name="ct_vt13" class="java.lang.Integer" resetType="Group" resetGroup="CostTypeGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER4}]]></variableExpression></variable><variable name="wp_vt1" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{HOURS}]]></variableExpression></variable><variable name="wp_vt2" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{DIRECT}]]></variableExpression></variable><variable name="wp_vt3" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD1}]]></variableExpression></variable><variable name="wp_vt4" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD2}]]></variableExpression></variable><variable name="wp_vt5" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD3}]]></variableExpression></variable><variable name="wp_vt6" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD4}]]></variableExpression></variable><variable name="wp_vt7" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{GA}]]></variableExpression></variable><variable name="wp_vt8" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{HEADS}]]></variableExpression></variable><variable name="wp_vt9" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{UNITS}]]></variableExpression></variable><variable name="wp_vt10" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER1}]]></variableExpression></variable><variable name="wp_vt11" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER2}]]></variableExpression></variable><variable name="wp_vt12" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER3}]]></variableExpression></variable><variable name="wp_vt13" class="java.lang.Integer" resetType="Group" resetGroup="WorkPackageGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER4}]]></variableExpression></variable><variable name="ca_vt1" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{HOURS}]]></variableExpression></variable><variable name="ca_vt2" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{DIRECT}]]></variableExpression></variable><variable name="ca_vt3" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD1}]]></variableExpression></variable><variable name="ca_vt4" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD2}]]></variableExpression></variable><variable name="ca_vt5" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD3}]]></variableExpression></variable><variable name="ca_vt6" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{OVERHD4}]]></variableExpression></variable><variable name="ca_vt7" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{GA}]]></variableExpression></variable><variable name="ca_vt8" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{HEADS}]]></variableExpression></variable><variable name="ca_vt9" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{UNITS}]]></variableExpression></variable><variable name="ca_vt10" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER1}]]></variableExpression></variable><variable name="ca_vt11" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER2}]]></variableExpression></variable><variable name="ca_vt12" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER3}]]></variableExpression></variable><variable name="ca_vt13" class="java.lang.Integer" resetType="Group" resetGroup="ControlAccountGroup" calculation="Sum"><variableExpression><![CDATA[$F{USER4}]]></variableExpression></variable> Could you have any idea about, reduce no of variables in the report ? Please can you give any examples for this? Thanks, Shanmugaraj S.