khushal.solanki8

I use jaspersoft designer 5.6.0 tool for design report. i want to create hyperlink in some text field i done aal process which has give in documentation but i cant creat hyperlink. can u help me step by step to do hyperlink in jaspersoft designer 5.6.0?

in this picture you saw that the average total line is not a straight. i want draw a graph with total monthly and single straight line without dots of average total monthly. i have try this my XML code is- <?xml version="1.0" encoding="UTF-8"?> <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="traffic_monthwise" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="580b5719-0f44-433d-8f92-4d48be2d7079"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="150"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> <style backcolor="#EFF7FF"/> </conditionalStyle> </style> <style name="table 1"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> <style backcolor="#EFF7FF"/> </conditionalStyle> </style> <style name="table 2"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> <style backcolor="#EFF7FF"/> </conditionalStyle> </style> <style name="table 3"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="monthwise" uuid="2721b683-546f-494f-a508-76bb59016665"> <parameter name="tollid1" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="syear1" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="eyear1" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="smonth1" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="emonth1" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT traffic_monthly.toll_id AS traffic_monthly_toll_id, traffic_monthly.month AS traffic_monthly_month, traffic_monthly.year AS traffic_monthly_year, traffic_monthly.car_total AS traffic_monthly_car_total, traffic_monthly.lcv_total AS traffic_monthly_lcv_total, traffic_monthly.bus_total AS traffic_monthly_bus_total, traffic_monthly.truck_total AS traffic_monthly_truck_total, traffic_monthly.axle_total AS traffic_monthly_3axle_total, traffic_monthly.hcm_total AS traffic_monthly_hcm_total, traffic_monthly.oversized_total AS traffic_monthly_oversized_total FROM traffic_monthly traffic_monthly WHERE toll_id=$P{tollid1} AND $P{syear1}<= year AND year <=$P{eyear1} AND NOT ( ($P{syear1}= year AND month <$P{smonth1}) OR ( $P{eyear1}= year AND month >$P{emonth1}) ) ORDER BY YEAR, MONTH;]]> </queryString> <field name="traffic_monthly_toll_id" class="java.lang.String"/> <field name="traffic_monthly_month" class="java.lang.String"/> <field name="traffic_monthly_year" class="java.lang.String"/> <field name="traffic_monthly_car_total" class="java.lang.String"/> <field name="traffic_monthly_lcv_total" class="java.lang.String"/> <field name="traffic_monthly_bus_total" class="java.lang.String"/> <field name="traffic_monthly_truck_total" class="java.lang.String"/> <field name="traffic_monthly_3axle_total" class="java.lang.String"/> <field name="traffic_monthly_hcm_total" class="java.lang.String"/> <field name="traffic_monthly_oversized_total" class="java.lang.String"/> <variable name="row_total" class="java.math.BigDecimal" incrementType="Report" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_car_total})+Integer.parseInt($F{traffic_monthly_lcv_total})+Integer.parseInt($F{traffic_monthly_bus_total})+Integer.parseInt($F{traffic_monthly_truck_total})+Integer.parseInt($F{traffic_monthly_3axle_total})+Integer.parseInt($F{traffic_monthly_hcm_total})+Integer.parseInt($F{traffic_monthly_oversized_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="car_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_car_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="lcv_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_lcv_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="bus_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_bus_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="truck_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_truck_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="axle_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_3axle_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="hcm_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_hcm_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="oversized_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_oversized_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="all_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$V{row_total}]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> </subDataset> <parameter name="location" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="user" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="tollid" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="syear" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="eyear" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="smonth" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="emonth" class="java.lang.Integer"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT traffic_monthly.toll_id AS traffic_monthly_toll_id, traffic_monthly.month AS traffic_monthly_month, traffic_monthly.year AS traffic_monthly_year, traffic_monthly.car_total AS traffic_monthly_car_total, traffic_monthly.lcv_total AS traffic_monthly_lcv_total, traffic_monthly.bus_total AS traffic_monthly_bus_total, traffic_monthly.truck_total AS traffic_monthly_truck_total, traffic_monthly.axle_total AS traffic_monthly_3axle_total, traffic_monthly.hcm_total AS traffic_monthly_hcm_total, traffic_monthly.oversized_total AS traffic_monthly_oversized_total FROM traffic_monthly traffic_monthly WHERE toll_id=$P{tollid} AND $P{syear}<= year AND year <=$P{eyear} AND NOT ( ($P{syear}= year AND month <$P{smonth}) OR ( $P{eyear}= year AND month >$P{emonth}) ) ORDER BY YEAR, MONTH;]]> </queryString> <field name="traffic_monthly_toll_id" class="java.lang.String"/> <field name="traffic_monthly_month" class="java.lang.String"/> <field name="traffic_monthly_year" class="java.lang.String"/> <field name="traffic_monthly_car_total" class="java.lang.String"/> <field name="traffic_monthly_lcv_total" class="java.lang.String"/> <field name="traffic_monthly_bus_total" class="java.lang.String"/> <field name="traffic_monthly_truck_total" class="java.lang.String"/> <field name="traffic_monthly_3axle_total" class="java.lang.String"/> <field name="traffic_monthly_hcm_total" class="java.lang.String"/> <field name="traffic_monthly_oversized_total" class="java.lang.String"/> <variable name="row_total" class="java.math.BigDecimal" incrementType="Report" calculation="Sum"> <variableExpression><![CDATA[integer.parseInt($F{traffic_monthly_car_total})+Integer.parseInt($F{traffic_monthly_lcv_total})+Integer.parseInt($F{traffic_monthly_bus_total})+Integer.parseInt($F{traffic_monthly_truck_total})+Integer.parseInt($F{traffic_monthly_3axle_total})+Integer.parseInt($F{traffic_monthly_hcm_total})+Integer.parseInt($F{traffic_monthly_oversized_total})]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="avg" class="java.math.BigDecimal"> <variableExpression><![CDATA[$V{all_total}/4]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <variable name="all_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$V{row_total}]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="93" splitType="Stretch"> <staticText> <reportElement x="175" y="0" width="501" height="25" uuid="68628a09-7315-4281-b58e-0310ce0a4e35"/> <textElement textAlignment="Center"> <font size="18" isBold="true"/> </textElement> <text><![CDATA[Prakash Asphaltings & Toll Highways (India) Ltd]]></text> </staticText> <staticText> <reportElement x="422" y="25" width="102" height="23" uuid="d6f994ff-a88d-4494-89e1-12fe402ef8d6"/> <textElement> <font size="18" isBold="true"/> </textElement> <text><![CDATA[Toll Plaza]]></text> </staticText> <textField> <reportElement x="240" y="25" width="176" height="23" uuid="d650e94a-9baa-4d81-8bb2-ead5ee71de4b"/> <textElement textAlignment="Right"> <font size="18" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$P{location}]]></textFieldExpression> </textField> <image> <reportElement x="13" y="0" width="91" height="48" uuid="563bc310-3b03-4a8d-81e9-cd967dbab06f"/> <imageExpression><![CDATA["/usr/pathcentralserver/images/path_logo.png"]]></imageExpression> </image> <staticText> <reportElement x="307" y="72" width="207" height="20" uuid="44f11f79-a17c-46e1-9696-795806dce26e"/> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[MonthWise Count Report]]></text> </staticText> </band> </title> <pageHeader> <band height="35" splitType="Stretch"> <staticText> <reportElement x="22" y="12" width="63" height="20" uuid="7f5da0ca-150c-4641-a5d1-c3edde8ffc6f"/> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Month :]]></text> </staticText> <staticText> <reportElement x="196" y="12" width="22" height="20" uuid="a57188ea-10ee-4103-aaa0-f094e3fadbc8"/> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[To]]></text> </staticText> <textField> <reportElement x="85" y="14" width="111" height="20" uuid="d3a26c5c-37c5-4e30-985d-82343f5d0a14"/> <textElement> <font size="12"/> </textElement> <textFieldExpression><![CDATA[new DateFormatSymbols().getMonths()[$P{smonth}-1]+"-"+$P{syear}]]></textFieldExpression> </textField> <textField> <reportElement x="220" y="14" width="109" height="20" uuid="da3d83ff-a61f-4f6a-8447-31a1305e32c5"/> <textElement> <font size="12"/> </textElement> <textFieldExpression><![CDATA[new DateFormatSymbols().getMonths()[$P{emonth}-1]+"-"+$P{eyear}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band splitType="Stretch"/> </columnHeader> <detail> <band height="37" splitType="Stretch"> <printWhenExpression><![CDATA[$V{REPORT_COUNT}==1]]></printWhenExpression> <componentElement> <reportElement key="table 3" style="table 3" x="22" y="0" width="360" height="37" uuid="cf65f2f2-3e40-4249-883c-fa32530cf56b"/> <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="monthwise" uuid="e25d8cac-1a50-4795-be1d-22273893af83"> <datasetParameter name="smonth1"> <datasetParameterExpression><![CDATA[$P{smonth}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="syear1"> <datasetParameterExpression><![CDATA[$P{syear}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="emonth1"> <datasetParameterExpression><![CDATA[$P{emonth}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="eyear1"> <datasetParameterExpression><![CDATA[$P{eyear}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="tollid1"> <datasetParameterExpression><![CDATA[$P{tollid}]]></datasetParameterExpression> </datasetParameter> </datasetRun> <jr:column width="61" uuid="ae009f3e-1549-458d-9b99-882ef9d6d130"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="59" height="30" uuid="2498ab4a-fb4f-4973-a8d4-7ed84660137e"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Month/ Year]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="59" height="19" uuid="6d83bf57-220c-40db-9e32-5255e5faf173"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Total]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="59" height="20" uuid="ff58ea2f-3c79-427c-a19f-29e8e1b27927"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="874d57d5-d381-4e2a-a1d0-7f7c56530ae7"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="74" height="20" uuid="3433688f-10d6-48bc-bbfb-7f20fb19e085"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Car]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="19" uuid="09b50b20-633e-4f11-b491-ac1d075d113e"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{car_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="20" uuid="17e03a40-b474-417b-9fb8-dc698bc7d53c"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{traffic_monthly_car_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="036493c9-7ae9-4dae-92bc-ba91effacd51"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="74" height="20" uuid="b4f9fcee-41de-479d-afac-93f48699abcb"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[LCV]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="19" uuid="5ad7af92-7709-4f72-b0b6-1474105a3e52"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{lcv_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="20" uuid="dff1008f-1587-40d7-9599-9251150a7ee8"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{traffic_monthly_lcv_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="392e1ba7-e91d-4c1a-a1ee-ec5e4d5a16ac"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="74" height="20" uuid="d9fe8e47-4984-45b6-abdb-74d7ca686da9"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[bus]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="19" uuid="e5c104cf-cf91-4c99-8ff1-80c770156b1c"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{bus_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="20" uuid="23b528f0-8587-4909-9545-b567217081c5"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{traffic_monthly_bus_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="eb3e2e4a-354a-4395-b589-d904aab9df9d"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="74" height="20" uuid="1367bb22-8ee1-49e8-bd03-a5bec4da47e1"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Truck]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="19" uuid="ff5b88ac-8e4a-4443-a088-a15bc50b7e67"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{truck_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="20" uuid="dc9ff86c-0e7f-4ce8-a423-ec4094771327"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{traffic_monthly_truck_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="52f3ada4-361d-42c4-9ef6-c1fbc0b2db45"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="74" height="20" uuid="b71fb0bb-523b-40b3-b943-a6affcda5ec4"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[3Axle]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="19" uuid="be5ec674-8060-46eb-a643-e71e3d72cca7"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{axle_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="20" uuid="fdecb81d-5b6a-4ec9-b23e-5caa7bc4e3a9"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{traffic_monthly_3axle_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="de4399da-5acf-4efe-bfcc-513c31c7929f"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="74" height="20" uuid="a1fdd427-cc3d-4eb9-b213-59f52c46e8b1"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[HCM]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="19" uuid="58cd0b62-3530-43d4-be4c-9e5b755833d6"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{hcm_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="20" uuid="4a859c69-d859-4018-a881-f0238020c95d"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{traffic_monthly_hcm_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="320c461e-4fdc-4883-9f05-4f930bf1c7e9"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="74" height="20" uuid="4143c7d7-ec48-4e6a-95b3-875164557e28"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[OverSized]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="19" uuid="15c062a8-dd29-4fd9-9b80-2a0cd7a38764"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{oversized_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="74" height="20" uuid="a00058b9-5510-4df5-9806-64208286abdb"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{traffic_monthly_oversized_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="94" uuid="15f80181-56e0-4ee5-81c6-bf3f2f191068"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="10" width="90" height="20" uuid="28b6557d-43de-4322-9e32-052047d99deb"/> <textElement textAlignment="Center"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Total]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="table 3_CH" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="90" height="19" uuid="1eac9bc9-6c9d-497f-8b98-33dfc66e350b"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{all_total}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="94" height="20" uuid="ca1c60b1-1bb4-4139-8003-19c5d665cacc"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{row_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> <band height="514" splitType="Stretch"> <printWhenExpression><![CDATA[$V{REPORT_COUNT}==1]]></printWhenExpression> <break> <reportElement x="0" y="-1" width="752" height="1" uuid="2141e779-92a5-48e3-ada4-aee9e4cbf202"/> </break> <lineChart> <chart> <reportElement x="0" y="268" width="752" height="246" uuid="1779ed93-01df-4ef2-b30e-bc423f10b4cb"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["Car"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[integer.parseInt($F{traffic_monthly_car_total})]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["LCV"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[integer.parseInt($F{traffic_monthly_lcv_total})]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Bus"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[integer.parseInt($F{traffic_monthly_bus_total})]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Truck"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[integer.parseInt($F{traffic_monthly_truck_total})]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["3Axle"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[integer.parseInt($F{traffic_monthly_3axle_total})]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["HCM"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[integer.parseInt($F{traffic_monthly_hcm_total})]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["OverSized"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[integer.parseInt($F{traffic_monthly_oversized_total})]]></valueExpression> </categorySeries> </categoryDataset> <linePlot> <plot labelRotation="-90.0"/> <categoryAxisFormat labelRotation="-90.0"> <axisFormat/> </categoryAxisFormat> <valueAxisFormat> <axisFormat/> </valueAxisFormat> </linePlot> </lineChart> <lineChart> <chart> <reportElement x="0" y="13" width="752" height="231" uuid="5208099e-92d0-44d3-bb24-ddab900b01e9"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["Month Total"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[$V{row_total}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Average Month Total"]]></seriesExpression> <categoryExpression><![CDATA[new DateFormatSymbols().getShortMonths()[integer.parseInt($F{traffic_monthly_month})-1]+"-"+Integer.parseInt($F{traffic_monthly_year})]]></categoryExpression> <valueExpression><![CDATA[$V{avg}]]></valueExpression> </categorySeries> </categoryDataset> <linePlot> <plot/> <categoryAxisFormat> <axisFormat/> </categoryAxisFormat> <valueAxisFormat> <axisFormat/> </valueAxisFormat> </linePlot> </lineChart> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="23" splitType="Stretch"> <staticText> <reportElement x="108" y="3" width="106" height="20" uuid="d48b8f17-1541-4158-a6b1-f53992bd75fd"/> <textElement> <font size="12" isBold="true"/> </textElement> <text><![CDATA[Generated By :]]></text> </staticText> <textField> <reportElement x="214" y="3" width="104" height="20" uuid="bfb2245b-a3ce-417a-bd04-020b64170222"/> <textElement> <font size="12" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$P{user}]]></textFieldExpression> </textField> <staticText> <reportElement x="349" y="3" width="17" height="20" uuid="e2c6bdc1-aee3-4e31-9fcd-697468972752"/> <textElement> <font size="12" isBold="true"/> </textElement> <text><![CDATA[At]]></text> </staticText> <textField pattern="dd/MM/yyyy h.mm a"> <reportElement x="372" y="3" width="142" height="20" uuid="b9d79a31-78ea-4b45-b8f5-3b56a6f90f48"/> <textElement> <font size="12" isBold="false"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <textField> <reportElement x="618" y="3" width="80" height="20" uuid="ae490698-70b5-40c7-b326-6ae4a4695949"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="698" y="3" width="40" height="20" uuid="ffabb83f-346f-4f0a-998b-6a51c99c7b86"/> <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band splitType="Stretch"/> </summary> </jasperReport>

i want to add in last row who will sum of column like Total Price and total stock how can i create this with table ? sum of rows and sum of column