john.wendt

Just and update that I was able to figure this out myself using an old trick that allows you to save values from previous rows. I got the idea from this video from Teodor. https://www.youtube.com/watch?v=UcbTzeJMfiY. Once I was able to confirm that the value from the row before the previous was the same, I wwas able to assign a variable that I could then use for grouping and sorting. Works good. Thanks for the tip Teodor! Here is my report jrxml. Take a close look at the variables allowing me to save the values from the previous two rows of data (partnumber (current row), oldPartNumber (previous), OlderPartNumber (2nd previous)) Thanks, John <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.0.final using JasperReports Library version 6.1.0 --><!-- 2016-04-10T20:58:26 --><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="Blank_A4_4" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="43bb0d79-3727-4b1f-8124-a11779148538"><property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/><queryString language="CSV"><![CDATA[]]></queryString><field name="LOTFLOWTRACKING_quantity" class="java.lang.String"/><field name="LOT_bin_number" class="java.lang.String"/><field name="LOT_lot_name" class="java.lang.String"/><field name="LOT_slot_number" class="java.lang.String"/><field name="ORDLOT_batch_number" class="java.lang.String"/><field name="ORDPART_category" class="java.lang.String"/><field name="ORDPART_product_line" class="java.lang.String"/><field name="ORD_dist_due_dt" class="java.lang.String"/><field name="ORD_schedule_ID" class="java.lang.String"/><field name="ORD_schedule_SEQ" class="java.lang.String"/><field name="TBOMPART_addlDesc" class="java.lang.String"/><field name="TBOMPART_category" class="java.lang.String"/><field name="TBOMPART_colorExt" class="java.lang.String"/><field name="TBOMPART_colorInt" class="java.lang.String"/><field name="TBOMPART_description" class="java.lang.String"/><field name="TBOMPART_handing" class="java.lang.String"/><field name="TBOMPART_height" class="java.lang.String"/><field name="TBOMPART_length" class="java.lang.String"/><field name="TBOMPART_locPosition" class="java.lang.String"/><field name="TBOMPART_locRack" class="java.lang.String"/><field name="TBOMPART_locRow" class="java.lang.String"/><field name="TBOMPART_locShelf" class="java.lang.String"/><field name="TBOMPART_locSupermarket" class="java.lang.String"/><field name="TBOMPART_part_number" class="java.lang.String"/><field name="TBOMPART_pkgType" class="java.lang.String"/><field name="TBOMPART_prod_size" class="java.lang.String"/><field name="TBOMPART_quantity" class="java.lang.String"/><field name="TBOMPART_width_F" class="java.lang.String"/><field name="WF_work_flow_name" class="java.lang.String"/><field name="categorySeq" class="java.lang.String"/><field name="Global_Picklist_Report" class="java.lang.String"/><field name="Global_UnitQty" class="java.lang.String"/><field name="Global_empID_cart" class="java.lang.String"/><field name="Global_username" class="java.lang.String"/><sortField name="Variable_3" type="Variable"/><sortField name="ORD_schedule_SEQ"/><sortField name="TBOMPART_locPosition" order="Descending"/><variable name="OlderPartNumber" class="java.lang.String"><variableExpression><![CDATA[$V{oldPartNumber}]]></variableExpression></variable><variable name="oldPartNumber" class="java.lang.String"><variableExpression><![CDATA[$V{partnumber}]]></variableExpression></variable><variable name="partnumber" class="java.lang.String"><variableExpression><![CDATA[$F{TBOMPART_part_number}]]></variableExpression></variable><variable name="changeParts" class="java.lang.Integer"><variableExpression><![CDATA[$F{TBOMPART_handing}.equalsIgnoreCase("LHSD")?($F{TBOMPART_part_number}.equalsIgnoreCase($V{OlderPartNumber})?$V{changeParts}:$V{changeParts}+10):$V{changeParts}]]></variableExpression><initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression></variable><variable name="Variable_3" class="java.lang.String"><variableExpression><![CDATA[$V{changeParts}.toString()+$F{TBOMPART_handing}]]></variableExpression></variable><group name="Group1"><groupExpression><![CDATA[$F{TBOMPART_part_number}+$F{TBOMPART_handing}]]></groupExpression><groupHeader><band/></groupHeader><groupFooter><band height="35" splitType="Prevent"><printWhenExpression><![CDATA[!$F{TBOMPART_part_number}.equalsIgnoreCase("TBOMPART_part_number")]]></printWhenExpression><textField><reportElement x="200" y="0" width="100" height="30" uuid="0d2c48cf-a311-4ff9-b9f1-571930dd943e"><property name="net.sf.jasperreports.export.json.path" value="Group1_COUNT"/></reportElement><textFieldExpression><![CDATA[$V{Group1_COUNT}]]></textFieldExpression></textField><textField><reportElement x="0" y="0" width="100" height="30" uuid="a39665cf-d309-4060-aeec-2d2b0ea6fe56"><property name="net.sf.jasperreports.export.json.path" value="TBOMPART_part_number"/></reportElement><textFieldExpression><![CDATA[$F{TBOMPART_part_number}]]></textFieldExpression></textField><textField><reportElement x="100" y="0" width="100" height="30" uuid="a58dcd16-1086-4591-bdd7-c836b90a090b"><property name="net.sf.jasperreports.export.json.path" value="TBOMPART_handing"/></reportElement><textFieldExpression><![CDATA[$F{TBOMPART_handing}]]></textFieldExpression></textField></band></groupFooter></group><background><band splitType="Stretch"/></background><title><band splitType="Stretch"/></title><pageHeader><band splitType="Stretch"/></pageHeader><columnHeader><band splitType="Stretch"/></columnHeader><detail><band splitType="Stretch"/></detail><columnFooter><band splitType="Stretch"/></columnFooter><pageFooter><band splitType="Stretch"/></pageFooter><summary><band splitType="Stretch"/></summary></jasperReport>

Thanks this at least help me understand why it works the way it does. I gave up on this idea and tried posting my exact problem to see if there is a simpler way. If you have a second, would you mind taking in look at my actual use case posted here? Thanks again! http://community.jaspersoft.com/questions/989111/skipping-row-grouping-functionality

Hello, I have a simple use case that I can’t quite figure out. I am trying to do this inside or Report Studio 6.1.1. I am trying to do this activity entirely inside of Report Studio. My raw data coming in looks like this. Sort Part Number Quantity 10 1234 1 10 4567 1 20 1234 1 20 4567 1 30 7890 1 30 2345 1 40 1234 1 40 4567 1 50 1234 1 50 4567 1 I am simply trying to group by skipping one row to determine how the grouping should be. My desired output is the following: Part Number Quantity 1234 2 4567 2 7890 1 2345 1 1234 2 4567 2 I can’t figure out how to utilize the grouping/sorting functionality to be able to properly provide this output. I have tried multiple different sorting and grouping options but I must just be missing something. Thanks for any help!

Hello, I am trying to combine multiple stand-alone sub-reports into one main report. I was following this one as an example http://community.jaspersoft.com/questions/847522/how-create-one-master-report-multiple-independent-subreports. The only difference between the two subreports is the filter expression. They both run fine stand alone. I am using Jaspersoft Studio 6.1.1 with a csv dataset I can only get one of my subreports to show any data. What am I missing? Thanks in advance, John **MAIN REPORT** <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1 --><!-- 2016-04-04T23:55:24 --><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="Blank_A4_2" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="c1e5ddac-833a-4068-b4ec-9a05d1faa7e0"><property name="com.jaspersoft.studio.data.sql.tables" value="RFVBTCAsMTUsMTUsZDFhMmU4MWQtZDhmYS00MzNiLTg4ZWItMGJjYjgxZjg0YTUzOw=="/><property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/><queryString language="CSV"><![CDATA[sELECT top 1 AS DUMMYFROM DUAL]]></queryString><field name="LOTFLOWTRACKING_quantity" class="java.lang.String"/><field name="LOT_bin_number" class="java.lang.String"/><field name="LOT_lot_name" class="java.lang.String"/><field name="LOT_slot_number" class="java.lang.String"/><field name="ORDLOT_batch_number" class="java.lang.String"/><field name="ORDPART_category" class="java.lang.String"/><field name="ORDPART_product_line" class="java.lang.String"/><field name="ORD_dist_due_dt" class="java.lang.String"/><field name="ORD_schedule_ID" class="java.lang.String"/><field name="ORD_schedule_SEQ" class="java.lang.String"/><field name="TBOMPART_addlDesc" class="java.lang.String"/><field name="TBOMPART_category" class="java.lang.String"/><field name="TBOMPART_colorExt" class="java.lang.String"/><field name="TBOMPART_colorInt" class="java.lang.String"/><field name="TBOMPART_description" class="java.lang.String"/><field name="TBOMPART_handing" class="java.lang.String"/><field name="TBOMPART_height" class="java.lang.String"/><field name="TBOMPART_length" class="java.lang.String"/><field name="TBOMPART_locPosition" class="java.lang.String"/><field name="TBOMPART_locRack" class="java.lang.String"/><field name="TBOMPART_locRow" class="java.lang.String"/><field name="TBOMPART_locShelf" class="java.lang.String"/><field name="TBOMPART_locSupermarket" class="java.lang.String"/><field name="TBOMPART_part_number" class="java.lang.String"/><field name="TBOMPART_pkgType" class="java.lang.String"/><field name="TBOMPART_prod_size" class="java.lang.String"/><field name="TBOMPART_quantity" class="java.lang.String"/><field name="TBOMPART_width_F" class="java.lang.String"/><field name="WF_work_flow_name" class="java.lang.String"/><field name="categorySeq" class="java.lang.String"/><field name="Global_Picklist_Report" class="java.lang.String"/><field name="Global_UnitQty" class="java.lang.String"/><field name="Global_empID_cart" class="java.lang.String"/><field name="Global_username" class="java.lang.String"/><background><band splitType="Stretch"/></background><title><band height="15" splitType="Stretch"/></title><pageHeader><band splitType="Stretch"/></pageHeader><columnHeader><band splitType="Stretch"/></columnHeader><detail><band height="75" splitType="Stretch"><subreport runToBottom="true"><reportElement stretchType="RelativeToBandHeight" x="0" y="10" width="200" height="57" uuid="b0f517fd-860d-47ba-81df-71fd9820e285"/><parametersMapExpression><![CDATA[$P{REPORT_CONNECTION}]]></parametersMapExpression><dataSourceExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></dataSourceExpression><subreportExpression><![CDATA["OFM Report2.jasper"]]></subreportExpression></subreport></band><band height="90" splitType="Stretch"><subreport runToBottom="true"><reportElement x="0" y="10" width="200" height="64" uuid="5a5c7a85-c4c3-422a-9817-c3ca9ea6c334"/><parametersMapExpression><![CDATA[$P{REPORT_CONNECTION}]]></parametersMapExpression><dataSourceExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></dataSourceExpression><subreportExpression><![CDATA["OFM Report.jasper"]]></subreportExpression></subreport></band></detail><columnFooter><band splitType="Stretch"/></columnFooter><pageFooter><band splitType="Stretch"/></pageFooter><summary><band height="10" splitType="Stretch"/></summary></jasperReport> *SUB 1 Report** ?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1 --><!-- 2016-04-04T23:56:19 --><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="Blank_A4_1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7db543a9-f440-4131-b7da-afe6969e6611"><queryString language="CSV"><![CDATA[]]></queryString><field name="LOTFLOWTRACKING_quantity" class="java.lang.String"/><field name="LOT_bin_number" class="java.lang.String"/><field name="LOT_lot_name" class="java.lang.String"/><field name="LOT_slot_number" class="java.lang.String"/><field name="ORDLOT_batch_number" class="java.lang.String"/><field name="ORDPART_category" class="java.lang.String"/><field name="ORDPART_product_line" class="java.lang.String"/><field name="ORD_dist_due_dt" class="java.lang.String"/><field name="ORD_schedule_ID" class="java.lang.String"/><field name="ORD_schedule_SEQ" class="java.lang.String"/><field name="TBOMPART_addlDesc" class="java.lang.String"/><field name="TBOMPART_category" class="java.lang.String"/><field name="TBOMPART_colorExt" class="java.lang.String"/><field name="TBOMPART_colorInt" class="java.lang.String"/><field name="TBOMPART_description" class="java.lang.String"/><field name="TBOMPART_handing" class="java.lang.String"/><field name="TBOMPART_height" class="java.lang.String"/><field name="TBOMPART_length" class="java.lang.String"/><field name="TBOMPART_locPosition" class="java.lang.String"/><field name="TBOMPART_locRack" class="java.lang.String"/><field name="TBOMPART_locRow" class="java.lang.String"/><field name="TBOMPART_locShelf" class="java.lang.String"/><field name="TBOMPART_locSupermarket" class="java.lang.String"/><field name="TBOMPART_part_number" class="java.lang.String"/><field name="TBOMPART_pkgType" class="java.lang.String"/><field name="TBOMPART_prod_size" class="java.lang.String"/><field name="TBOMPART_quantity" class="java.lang.String"/><field name="TBOMPART_width_F" class="java.lang.String"/><field name="WF_work_flow_name" class="java.lang.String"/><field name="categorySeq" class="java.lang.String"/><field name="Global_Picklist_Report" class="java.lang.String"/><field name="Global_UnitQty" class="java.lang.String"/><field name="Global_empID_cart" class="java.lang.String"/><field name="Global_username" class="java.lang.String"/><sortField name="ORD_schedule_SEQ"/><sortField name="TBOMPART_handing"/><variable name="TBOMPART_quantity1" class="java.lang.Integer" resetType="Group" resetGroup="Group1" calculation="Count"><variableExpression><![CDATA[$F{TBOMPART_quantity}]]></variableExpression></variable><variable name="TBOMPART_part_number1" class="java.lang.Integer" resetType="Group" resetGroup="Group1" calculation="DistinctCount"><variableExpression><![CDATA[$F{TBOMPART_part_number}]]></variableExpression></variable><variable name="LOTFLOWTRACKING_quantity1" class="java.lang.Integer" resetType="Group" resetGroup="Group1" calculation="Count"><variableExpression><![CDATA[$F{LOTFLOWTRACKING_quantity}]]></variableExpression></variable><filterExpression><![CDATA[$F{TBOMPART_handing}.equalsIgnoreCase("RHSD")]]></filterExpression><group name="Group1"><groupExpression><![CDATA[$F{TBOMPART_part_number}+$F{TBOMPART_handing}]]></groupExpression></group><group name="Group2"><groupExpression><![CDATA[$F{TBOMPART_part_number}]]></groupExpression><groupHeader><band height="46"><textField><reportElement x="-20" y="10" width="100" height="30" uuid="1fd90e50-eea3-47d9-90f7-b54dc293c956"/><textFieldExpression><![CDATA[$F{TBOMPART_part_number}]]></textFieldExpression></textField><textField><reportElement x="90" y="10" width="100" height="30" uuid="ac658cee-860c-4384-acdb-c241b5452138"/><textFieldExpression><![CDATA[$F{TBOMPART_handing}]]></textFieldExpression></textField><textField><reportElement x="200" y="10" width="100" height="30" uuid="5bd5f86c-96bd-46aa-951a-dc062c64a805"/><textFieldExpression><![CDATA[$F{TBOMPART_quantity}]]></textFieldExpression></textField></band></groupHeader><groupFooter><band height="15"/></groupFooter></group><background><band splitType="Stretch"/></background><title><band height="17" splitType="Stretch"/></title><pageHeader><band height="23" splitType="Stretch"/></pageHeader><columnHeader><band height="18" splitType="Stretch"/></columnHeader><detail><band splitType="Stretch"/></detail><columnFooter><band height="18" splitType="Stretch"/></columnFooter><pageFooter><band height="25" splitType="Stretch"/></pageFooter><summary><band height="16" splitType="Stretch"/></summary></jasperReport> **SUB 2 Report** ?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1 --><!-- 2016-04-04T23:56:43 --><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="Blank_A4_1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7db543a9-f440-4131-b7da-afe6969e6611"><queryString language="CSV"><![CDATA[]]></queryString><field name="LOTFLOWTRACKING_quantity" class="java.lang.String"/><field name="LOT_bin_number" class="java.lang.String"/><field name="LOT_lot_name" class="java.lang.String"/><field name="LOT_slot_number" class="java.lang.String"/><field name="ORDLOT_batch_number" class="java.lang.String"/><field name="ORDPART_category" class="java.lang.String"/><field name="ORDPART_product_line" class="java.lang.String"/><field name="ORD_dist_due_dt" class="java.lang.String"/><field name="ORD_schedule_ID" class="java.lang.String"/><field name="ORD_schedule_SEQ" class="java.lang.String"/><field name="TBOMPART_addlDesc" class="java.lang.String"/><field name="TBOMPART_category" class="java.lang.String"/><field name="TBOMPART_colorExt" class="java.lang.String"/><field name="TBOMPART_colorInt" class="java.lang.String"/><field name="TBOMPART_description" class="java.lang.String"/><field name="TBOMPART_handing" class="java.lang.String"/><field name="TBOMPART_height" class="java.lang.String"/><field name="TBOMPART_length" class="java.lang.String"/><field name="TBOMPART_locPosition" class="java.lang.String"/><field name="TBOMPART_locRack" class="java.lang.String"/><field name="TBOMPART_locRow" class="java.lang.String"/><field name="TBOMPART_locShelf" class="java.lang.String"/><field name="TBOMPART_locSupermarket" class="java.lang.String"/><field name="TBOMPART_part_number" class="java.lang.String"/><field name="TBOMPART_pkgType" class="java.lang.String"/><field name="TBOMPART_prod_size" class="java.lang.String"/><field name="TBOMPART_quantity" class="java.lang.String"/><field name="TBOMPART_width_F" class="java.lang.String"/><field name="WF_work_flow_name" class="java.lang.String"/><field name="categorySeq" class="java.lang.String"/><field name="Global_Picklist_Report" class="java.lang.String"/><field name="Global_UnitQty" class="java.lang.String"/><field name="Global_empID_cart" class="java.lang.String"/><field name="Global_username" class="java.lang.String"/><sortField name="ORD_schedule_SEQ"/><sortField name="TBOMPART_handing"/><variable name="TBOMPART_quantity1" class="java.lang.Integer" resetType="Group" resetGroup="Group1" calculation="Count"><variableExpression><![CDATA[$F{TBOMPART_quantity}]]></variableExpression></variable><variable name="TBOMPART_part_number1" class="java.lang.Integer" resetType="Group" resetGroup="Group1" calculation="DistinctCount"><variableExpression><![CDATA[$F{TBOMPART_part_number}]]></variableExpression></variable><variable name="LOTFLOWTRACKING_quantity1" class="java.lang.Integer" resetType="Group" resetGroup="Group1" calculation="Count"><variableExpression><![CDATA[$F{LOTFLOWTRACKING_quantity}]]></variableExpression></variable><filterExpression><![CDATA[$F{TBOMPART_handing}.equalsIgnoreCase("LHSD")]]></filterExpression><group name="Group1"><groupExpression><![CDATA[$F{TBOMPART_part_number}+$F{TBOMPART_handing}]]></groupExpression></group><group name="Group2"><groupExpression><![CDATA[$F{TBOMPART_part_number}]]></groupExpression><groupHeader><band height="46"><textField><reportElement x="-20" y="10" width="100" height="30" uuid="1fd90e50-eea3-47d9-90f7-b54dc293c956"/><textFieldExpression><![CDATA[$F{TBOMPART_part_number}]]></textFieldExpression></textField><textField><reportElement x="90" y="10" width="100" height="30" uuid="ac658cee-860c-4384-acdb-c241b5452138"/><textFieldExpression><![CDATA[$F{TBOMPART_handing}]]></textFieldExpression></textField><textField><reportElement x="200" y="10" width="100" height="30" uuid="5bd5f86c-96bd-46aa-951a-dc062c64a805"/><textFieldExpression><![CDATA[$F{TBOMPART_quantity}]]></textFieldExpression></textField></band></groupHeader><groupFooter><band height="15"/></groupFooter></group><background><band splitType="Stretch"/></background><title><band height="17" splitType="Stretch"/></title><pageHeader><band height="23" splitType="Stretch"/></pageHeader><columnHeader><band height="18" splitType="Stretch"/></columnHeader><detail><band splitType="Stretch"/></detail><columnFooter><band height="18" splitType="Stretch"/></columnFooter><pageFooter><band height="25" splitType="Stretch"/></pageFooter><summary><band height="16" splitType="Stretch"/></summary></jasperReport>

The CSV Metadata report output works fine until I try and use the change columns order property. Once I try and change columns order the output get messed up. Is anyone else experiencing this?