sql - JasperReport printing repeated values even when set not to -

i combining sql column , using group count print out 1 line combined items. i'm getting result:

here's code: (sorry if it's messy)

<?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="tablereceipt" pagewidth="225" pageheight="800" whennodatatype="allsectionsnodetail" columnwidth="195" leftmargin="5" rightmargin="25" topmargin="20" bottommargin="20" isfloatcolumnfooter="true" isignorepagination="true" uuid="516cb110-18eb-4a7a-865b-66c019f5be1a">     <property name="ireport.scriptlethandling" value="0"/>     <property name="ireport.encoding" value="utf-8"/>     <property name="ireport.zoom" value="1.9965000000000035"/>     <property name="ireport.x" value="0"/>     <property name="ireport.y" value="0"/>     <import value="net.sf.jasperreports.engine.*"/>     <import value="java.util.*"/>     <import value="net.sf.jasperreports.engine.data.*"/>     <parameter name="ticketid" class="java.lang.integer">         <defaultvalueexpression><![cdata[2]]></defaultvalueexpression>     </parameter>     <parameter name="issale" class="java.lang.boolean">         <defaultvalueexpression><![cdata[false]]></defaultvalueexpression>     </parameter>     <parameter name="endticket" class="java.lang.boolean">         <defaultvalueexpression><![cdata[false]]></defaultvalueexpression>     </parameter>     <querystring>         <![cdata[select     t.ticket_item_id,     ticket_item_desc,     ticket_item_total,     ticket.ticket_id,     ticket_customer_name,     ticket_check_total,     ticket_total_tax,     ticket_item_number     ticket_item t,     ticket     t.ticket_id = $p{ticketid} ,     ticket.ticket_id = $p{ticketid} ,     ticket_item_void = 0]]>     </querystring>     <field name="ticket_item_id" class="java.lang.integer">         <fielddescription><![cdata[]]></fielddescription>     </field>     <field name="ticket_item_desc" class="java.lang.string">         <fielddescription><![cdata[]]></fielddescription>     </field>     <field name="ticket_item_total" class="java.lang.double">         <fielddescription><![cdata[]]></fielddescription>     </field>     <field name="ticket_id" class="java.lang.integer">         <fielddescription><![cdata[]]></fielddescription>     </field>     <field name="ticket_customer_name" class="java.lang.string">         <fielddescription><![cdata[]]></fielddescription>     </field>     <field name="ticket_check_total" class="java.lang.double">         <fielddescription><![cdata[]]></fielddescription>     </field>     <field name="ticket_total_tax" class="java.lang.double">         <fielddescription><![cdata[]]></fielddescription>     </field>     <field name="ticket_item_number" class="java.lang.integer">         <fielddescription><![cdata[]]></fielddescription>     </field>     <variable name="15per" class="java.lang.double">         <variableexpression><![cdata[($f{ticket_check_total}-$f{ticket_total_tax})*0.15]]></variableexpression>     </variable>     <variable name="18per" class="java.lang.double">         <variableexpression><![cdata[($f{ticket_check_total}-$f{ticket_total_tax})*0.18]]></variableexpression>     </variable>     <variable name="20per" class="java.lang.double">         <variableexpression><![cdata[($f{ticket_check_total}-$f{ticket_total_tax})*0.20]]></variableexpression>     </variable>     <variable name="count" class="java.lang.integer" resettype="none">         <variableexpression><![cdata[$v{item_name_count}]]></variableexpression>         <initialvalueexpression><![cdata[$v{item_name_count}]]></initialvalueexpression>     </variable>     <group name="item_name">         <groupexpression><![cdata[$f{ticket_item_number}]]></groupexpression>     </group>     <title>         <band height="20" splittype="stretch">             <subreport>                 <reportelement uuid="f2cebdf8-f1d6-413f-9c03-914be928988c" x="0" y="20" width="195" height="0"/>                 <subreportparameter name="top">                     <subreportparameterexpression><![cdata[1]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/ticket_lines.jasper"]]></subreportexpression>             </subreport>             <statictext>                 <reportelement uuid="ffbd8a47-40c3-4210-8301-913b3ef152e6" x="0" y="0" width="195" height="20">                     <printwhenexpression><![cdata[!$p{issale}]]></printwhenexpression>                 </reportelement>                 <textelement textalignment="center" verticalalignment="middle">                     <font fontname="calibri" size="12" isbold="true"/>                 </textelement>                 <text><![cdata[not sale ticket]]></text>             </statictext>         </band>     </title>     <pageheader>         <band height="36">             <subreport>                 <reportelement uuid="a1231c58-cd4f-46d7-87ce-a277abb52bc6" x="0" y="0" width="195" height="36">                     <printwhenexpression><![cdata[$f{ticket_customer_name} == null]]></printwhenexpression>                 </reportelement>                 <subreportparameter name="ticketid">                     <subreportparameterexpression><![cdata[$p{ticketid}]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/details.jasper"]]></subreportexpression>             </subreport>             <subreport>                 <reportelement uuid="f47b2daf-b879-4fd6-9168-f1893a5a323f" x="0" y="0" width="195" height="36">                     <printwhenexpression><![cdata[$f{ticket_customer_name} != null]]></printwhenexpression>                 </reportelement>                 <subreportparameter name="ticketid">                     <subreportparameterexpression><![cdata[$p{ticketid}]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/customerdetails.jasper"]]></subreportexpression>             </subreport>         </band>     </pageheader>     <columnheader>         <band height="11" splittype="stretch"/>     </columnheader>     <detail>         <band height="11" splittype="stretch">             <textfield isstretchwithoverflow="true" isblankwhennull="true">                 <reportelement uuid="5b3ae499-3805-43ed-8f73-5a07bb67d2be" isprintrepeatedvalues="false" x="20" y="0" width="140" height="11" isremovelinewhenblank="true" isprintwhendetailoverflows="true" printwhengroupchanges="item_name"/>                 <textelement verticalalignment="middle">                     <font fontname="calibri" size="9" isbold="false"/>                 </textelement>                 <textfieldexpression><![cdata[$f{ticket_item_desc}]]></textfieldexpression>             </textfield>             <textfield isstretchwithoverflow="true" pattern="#,##0.00" isblankwhennull="true">                 <reportelement uuid="16aac7b5-9688-4a78-860a-073cfca5fb9e" isprintrepeatedvalues="false" x="160" y="0" width="35" height="11" isremovelinewhenblank="true" isprintwhendetailoverflows="true" printwhengroupchanges="item_name"/>                 <textelement textalignment="right" verticalalignment="middle">                     <font fontname="calibri" size="9" isbold="false"/>                 </textelement>                 <textfieldexpression><![cdata[$f{ticket_item_total}]]></textfieldexpression>             </textfield>             <subreport>                 <reportelement uuid="95f2a214-786a-45f7-ad12-2fc2befb5351" positiontype="float" isprintrepeatedvalues="false" x="0" y="11" width="195" height="0" isremovelinewhenblank="true"/>                 <subreportparameter name="ticket_item_id">                     <subreportparameterexpression><![cdata[$f{ticket_item_id}]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/modifiers.jasper"]]></subreportexpression>             </subreport>             <textfield isstretchwithoverflow="true" evaluationtime="group" evaluationgroup="item_name" isblankwhennull="true">                 <reportelement uuid="0536d26c-7ce5-4cb6-a3ea-7a8f3303ac25" isprintrepeatedvalues="false" mode="transparent" x="0" y="0" width="20" height="11" isremovelinewhenblank="true" isprintwhendetailoverflows="true" printwhengroupchanges="item_name"/>                 <textelement verticalalignment="middle">                     <font fontname="calibri" size="9"/>                 </textelement>                 <textfieldexpression><![cdata[$v{item_name_count}]]></textfieldexpression>             </textfield>         </band>     </detail>     <summary>         <band height="160">             <subreport runtobottom="false">                 <reportelement uuid="7fc03f4a-fc6e-486f-8194-c7e6f770f5ff" positiontype="float" x="0" y="59" width="195" height="0" isprintwhendetailoverflows="true"/>                 <subreportparameter name="top">                     <subreportparameterexpression><![cdata[0]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/ticket_lines.jasper"]]></subreportexpression>             </subreport>             <subreport runtobottom="false">                 <reportelement uuid="3dffcb5c-fda5-483e-a8e6-d584d2343dc6" x="0" y="0" width="195" height="0" isprintwhendetailoverflows="true"/>                 <subreportparameter name="ticketid">                     <subreportparameterexpression><![cdata[$p{ticketid}]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/totals.jasper"]]></subreportexpression>             </subreport>             <subreport>                 <reportelement uuid="64e108d9-e944-402d-b5a4-83c618f64521" positiontype="float" x="0" y="68" width="195" height="92" isremovelinewhenblank="true"/>                 <subreportparameter name="ticketid">                     <subreportparameterexpression><![cdata[$p{ticketid}]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/deliverydetails.jasper"]]></subreportexpression>             </subreport>             <subreport runtobottom="false">                 <reportelement uuid="6757917e-b848-4d29-ad8b-7df6ef333561" positiontype="float" x="0" y="15" width="195" height="0" isprintwhendetailoverflows="true">                     <printwhenexpression><![cdata[$p{endticket}]]></printwhenexpression>                 </reportelement>                 <subreportparameter name="ticketid">                     <subreportparameterexpression><![cdata[$p{ticketid}]]></subreportparameterexpression>                 </subreportparameter>                 <connectionexpression><![cdata[$p{report_connection}]]></connectionexpression>                 <subreportexpression><![cdata["subreports/condensed_transactions.jasper"]]></subreportexpression>             </subreport>             <textfield pattern="¤ #,##0.00">                 <reportelement uuid="f309bce5-1d1b-475f-b6e0-91d254b20ae4" positiontype="float" x="95" y="15" width="55" height="13" isremovelinewhenblank="true">                     <printwhenexpression><![cdata[!$p{endticket}]]></printwhenexpression>                 </reportelement>                 <textelement verticalalignment="middle">                     <font fontname="calibri"/>                 </textelement>                 <textfieldexpression><![cdata[$v{15per}]]></textfieldexpression>             </textfield>             <statictext>                 <reportelement uuid="67bd8b7a-122e-435f-abf5-e7a109c4f7b8" positiontype="float" x="61" y="41" width="34" height="13" isremovelinewhenblank="true">                     <printwhenexpression><![cdata[!$p{endticket}]]></printwhenexpression>                 </reportelement>                 <textelement verticalalignment="middle">                     <font fontname="calibri"/>                 </textelement>                 <text><![cdata[20% -]]></text>             </statictext>             <statictext>                 <reportelement uuid="69ee0f5f-378d-4fa0-b3f5-bd1dc337d71c" positiontype="float" x="61" y="28" width="34" height="13" isremovelinewhenblank="true">                     <printwhenexpression><![cdata[!$p{endticket}]]></printwhenexpression>                 </reportelement>                 <textelement verticalalignment="middle">                     <font fontname="calibri"/>                 </textelement>                 <text><![cdata[18% -]]></text>             </statictext>             <textfield pattern="¤ #,##0.00">                 <reportelement uuid="1747abc9-812c-4157-a717-fc6774fb92d7" positiontype="float" x="95" y="28" width="55" height="13" isremovelinewhenblank="true">                     <printwhenexpression><![cdata[!$p{endticket}]]></printwhenexpression>                 </reportelement>                 <textelement verticalalignment="middle">                     <font fontname="calibri"/>                 </textelement>                 <textfieldexpression><![cdata[$v{18per}]]></textfieldexpression>             </textfield>             <textfield pattern="¤ #,##0.00">                 <reportelement uuid="ec57b3a8-4b29-40e5-b05c-1b90cab7558f" positiontype="float" x="95" y="41" width="55" height="13" isremovelinewhenblank="true">                     <printwhenexpression><![cdata[!$p{endticket}]]></printwhenexpression>                 </reportelement>                 <textelement verticalalignment="middle">                     <font fontname="calibri"/>                 </textelement>                 <textfieldexpression><![cdata[$v{20per}]]></textfieldexpression>             </textfield>             <statictext>                 <reportelement uuid="8130693f-ca43-4a22-9b05-6f89707dc71f" positiontype="float" x="61" y="15" width="34" height="13" isremovelinewhenblank="true">                     <printwhenexpression><![cdata[!$p{endticket}]]></printwhenexpression>                 </reportelement>                 <textelement verticalalignment="middle">                     <font fontname="calibri"/>                 </textelement>                 <text><![cdata[15% -]]></text>             </statictext>         </band>     </summary> </jasperreport> 

what we're looking @ $v{item_name_count} field. print repeated values set false, i'm still getting them. evaluation time set group because if it's set else, count increment , not give me correct group count. idea how fix this? need count.

seems simple group , count fixed issue.

here's sql used:

select     t.ticket_item_id,     ticket_item_desc,     ticket_item_total,     ticket.ticket_id,     ticket_customer_name,     ticket_check_total,     ticket_total_tax,     ticket_item_number,     count(ticket_item_number) count     ticket_item t,     ticket     t.ticket_id = $p{ticketid} ,     ticket.ticket_id = $p{ticketid} ,     ticket_item_void = 0 group     ticket_item_number 

everything else stayed same.