sabel

I plan to migrate to JSS soon. Unfortunately, I can not be idle and must continue to learn and develop reports until then.

I have a report with 3 detail bands, each containing a subreport. It runs fine as is, but I would like to be able to selectively show or hide each of the bands or subreports. I am still very new to iReports, can someone help me please.

here is the xml <?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="Material_Pricing_Quotation" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="02f32866-ee78-4392-84b9-a67762694d24"><property name="ireport.zoom" value="1.5"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"><defaultValueExpression><![CDATA["C:\Users\Cost-OS\Desktop\rEPORTS\subreports\"]]></defaultValueExpression></parameter><queryString language="CostosHQL"><![CDATA[sELECTo.boqItemPublishedItemCode as Item_Code,cast(o.boqItemGroupCode1Level1Title as string) as boqItemGroupCode1,o.boqItemUnit1 as UM,o.boqItemQuantity1 as Quantity,o.boqItemTitle as Description,o.boqItemGroupCode1Level1Title as boqItemGroupCode1Level1Title,o.boqItemGroupCode1Level2Title as boqItemGroupCode1Level2Title,o.boqItemGroupCode1Level3Title as boqItemGroupCode1Level3Title,o.boqItemGroupCode1Level4Title as boqItemGroupCode1Level4Title,o.boqItemGroupCode1Level5Title as boqItemGroupCode1Level5Title,o.boqItemGroupCode1Level1Code as boqItemGroupCode1Level1Code,o.boqItemGroupCode1Level2Code as boqItemGroupCode1Level2Code,o.boqItemGroupCode1Level3Code as boqItemGroupCode1Level3Code,o.boqItemGroupCode1Level4Code as boqItemGroupCode1Level4Code,o.boqItemGroupCode1Level5Code as boqItemGroupCode1Level5Code,o.boqItemEquipmentCost/nullif((select sum(z.boqItemQuantity1) from BoqItemView z),0) as Equipment_Unit_Rate,o.boqItemLaborCost/nullif((select sum(z.boqItemQuantity1) from BoqItemView z),0) as Labor_Unit_Rate,o.boqItemMaterialCost/nullif((select sum(z.boqItemQuantity1) from BoqItemView z),0) as Material_Unit_Rate,o.boqItemTotalCost/nullif((select sum(z.boqItemQuantity1) from BoqItemView z),0) as Unit_Rate,o.boqItemSubcontractorCost/nullif((select sum(z.boqItemQuantity1) from BoqItemView z),0) as Sub_Unit_Rate,o.boqItemLaborCost+boqItemMaterialCost as Labor_Material,o.boqItemLaborCost as Labor,o.boqItemMaterialCost as Material,o.projectName as Project_Name,o.projectCode as Project_Code,o.projectClientName as Client_Name,o.boqItemTotalCost as TotalCost,o.boqItemTotalCost/nullif ((select sum(z.boqItemTotalCost) from BoqItemView z),0) as Percent,cast(o.boqItemGroupCode1Level1Title as string) as kfrom BoqItemView as oorder by k]]></queryString><field name="Item_Code" class="java.lang.String"/><field name="boqItemGroupCode1" class="java.lang.String"/><field name="UM" class="java.lang.String"/><field name="Quantity" class="java.math.BigDecimal"/><field name="Description" class="java.lang.String"/><field name="boqItemGroupCode1Level1Title" class="java.lang.String"/><field name="boqItemGroupCode1Level2Title" class="java.lang.String"/><field name="boqItemGroupCode1Level3Title" class="java.lang.String"/><field name="boqItemGroupCode1Level4Title" class="java.lang.String"/><field name="boqItemGroupCode1Level5Title" class="java.lang.String"/><field name="boqItemGroupCode1Level1Code" class="java.lang.String"/><field name="boqItemGroupCode1Level2Code" class="java.lang.String"/><field name="boqItemGroupCode1Level3Code" class="java.lang.String"/><field name="boqItemGroupCode1Level4Code" class="java.lang.String"/><field name="boqItemGroupCode1Level5Code" class="java.lang.String"/><field name="Equipment_Unit_Rate" class="java.math.BigDecimal"/><field name="Labor_Unit_Rate" class="java.math.BigDecimal"/><field name="Material_Unit_Rate" class="java.math.BigDecimal"/><field name="Unit_Rate" class="java.math.BigDecimal"/><field name="Sub_Unit_Rate" class="java.math.BigDecimal"/><field name="Labor_Material" class="java.math.BigDecimal"/><field name="Labor" class="java.math.BigDecimal"/><field name="Material" class="java.math.BigDecimal"/><field name="Project_Name" class="java.lang.String"/><field name="Project_Code" class="java.lang.String"/><field name="Client_Name" class="java.lang.String"/><field name="TotalCost" class="java.math.BigDecimal"/><field name="Percent" class="java.math.BigDecimal"/><field name="k" class="java.lang.String"/><variable name="TotalCost_1" class="java.math.BigDecimal" resetType="Group" resetGroup="Division" calculation="Sum"><variableExpression><![CDATA[$F{TotalCost}]]></variableExpression></variable><group name="Division"><groupExpression><![CDATA[$F{boqItemGroupCode1Level1Title}]]></groupExpression></group><group name="Division 01"><groupExpression><![CDATA[$F{boqItemGroupCode1Level1Code}]]></groupExpression><groupHeader><band height="50"><subreport isUsingCache="false" runToBottom="false"><reportElement uuid="affc6a3c-a139-4e42-a98c-34a72185e999" isPrintRepeatedValues="false" x="1" y="0" width="752" height="50" isRemoveLineWhenBlank="true" printWhenGroupChanges="Division"/><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Division_1_SubReport.jasper"]]></subreportExpression></subreport></band></groupHeader></group><background><band splitType="Stretch"/></background><pageHeader><band height="79" splitType="Stretch"><image><reportElement uuid="840dec5c-b6e4-4aad-9224-d3c13dc20f27" x="334" y="42" width="85" height="30"/><imageExpression><![CDATA["C:\logo.jpg"]]></imageExpression></image><line><reportElement uuid="95bd1eb7-a83b-43ae-ae30-36d0e7a9d686" x="1" y="34" width="752" height="1"/><graphicElement><pen lineWidth="3.0"/></graphicElement></line><staticText><reportElement uuid="3585fa68-bfe4-43df-8d6c-97bf641c6772" x="0" y="36" width="52" height="20"/><textElement verticalAlignment="Middle"><font size="10" isBold="false"/></textElement><text><![CDATA[Client: ]]></text></staticText><staticText><reportElement uuid="4694ed7a-93ac-420f-8423-8b289a72ab07" x="0" y="56" width="52" height="20"/><textElement verticalAlignment="Middle"><font size="10" isBold="false"/></textElement><text><![CDATA[Job Code: ]]></text></staticText><textField pattern="MMMMM dd, yyyy"><reportElement uuid="dcfe676b-07f9-49c3-9f0e-acbb22d457a6" x="590" y="56" width="162" height="20"/><textElement textAlignment="Right" verticalAlignment="Middle"><font size="10"/></textElement><textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression></textField><textField><reportElement uuid="606c7005-7b50-4729-9993-9593d826e064" x="590" y="36" width="162" height="20"/><textElement textAlignment="Right" verticalAlignment="Middle"><font size="10" isBold="true"/></textElement><textFieldExpression><![CDATA[$F{Project_Name}]]></textFieldExpression></textField><textField><reportElement uuid="764b680b-7124-4bbf-90ec-2cf0555e1acd" x="52" y="56" width="126" height="20"/><textElement verticalAlignment="Middle"><font size="10"/></textElement><textFieldExpression><![CDATA[$F{Project_Code}]]></textFieldExpression></textField><textField><reportElement uuid="dea31afa-994e-4e79-8413-ffea9f97946b" x="52" y="36" width="126" height="20"/><textElement verticalAlignment="Middle"><font size="10"/></textElement><textFieldExpression><![CDATA[$F{Client_Name}]]></textFieldExpression></textField><line><reportElement uuid="304ea539-c88d-4f91-8adb-223c4af0dcfa" x="1" y="29" width="508" height="1"/><graphicElement><pen lineWidth="3.0"/></graphicElement></line><staticText><reportElement uuid="b5a2ae59-6856-4553-9ebf-46174eaae96f" x="1" y="4" width="155" height="20"/><textElement verticalAlignment="Middle"><font size="12" isBold="true"/></textElement><text><![CDATA[Material Pricing Quotation]]></text></staticText><textField evaluationTime="Report"><reportElement uuid="c1ca9a27-21ca-40a3-bdd5-9836a5696b26" x="732" y="4" width="20" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="12" isItalic="true"/></textElement><textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression></textField><textField><reportElement uuid="e411d511-7c9b-4968-a719-25f35518f94d" x="700" y="4" width="20" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="12" isItalic="true"/></textElement><textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression></textField><staticText><reportElement uuid="7583c01c-f0ed-4eca-89da-031aa8cf0e23" x="720" y="4" width="12" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="12" isItalic="true"/></textElement><text><![CDATA[of]]></text></staticText></band></pageHeader><columnHeader><band height="31"><line><reportElement uuid="ead91ffa-781b-40c8-b7e9-057067317f7d" x="0" y="29" width="752" height="1"/><graphicElement><pen lineWidth="3.0" lineStyle="Double"/></graphicElement></line><line><reportElement uuid="9f552036-a979-4693-91bd-674806b81667" x="0" y="2" width="752" height="1"/><graphicElement><pen lineWidth="3.0"/></graphicElement></line><staticText><reportElement uuid="001b8749-2716-416d-9bcf-960afa49deb3" x="0" y="6" width="52" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="true" isUnderline="true"/></textElement><text><![CDATA[item Code]]></text></staticText><staticText><reportElement uuid="6d11a6d9-02e4-400b-88b2-0ae82c66eec3" x="52" y="6" width="237" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="true" isUnderline="true"/></textElement><text><![CDATA[Description]]></text></staticText><staticText><reportElement uuid="76cac425-df50-4d33-a896-2fd5f88ae4ce" x="289" y="6" width="57" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="true" isUnderline="true"/></textElement><text><![CDATA[Quantity]]></text></staticText><staticText><reportElement uuid="d9c8c184-a97b-4094-b2c1-1ac317393148" x="346" y="6" width="49" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="true" isUnderline="true"/></textElement><text><![CDATA[uM]]></text></staticText><staticText><reportElement uuid="25084147-9d26-4c12-8b36-08fa515a35a9" x="595" y="6" width="157" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="true" isUnderline="true"/></textElement><text><![CDATA[Note]]></text></staticText><staticText><reportElement uuid="706e99a8-9eb8-46ae-b950-a874ffef8009" x="495" y="6" width="100" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="true" isUnderline="true"/></textElement><text><![CDATA[Extended Price]]></text></staticText><staticText><reportElement uuid="cd23178c-7ca9-45ed-8afa-874664bfa2cd" x="395" y="6" width="100" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="true" isUnderline="true"/></textElement><text><![CDATA[unit Price]]></text></staticText></band></columnHeader><summary><band height="129" splitType="Stretch"><line><reportElement uuid="e9e217a0-2805-4df3-b9a9-632a686791df" x="0" y="2" width="752" height="1"/><graphicElement><pen lineWidth="3.0" lineStyle="Double"/></graphicElement></line><staticText><reportElement uuid="5ab33f20-78be-4fb4-a731-2af7e40faac3" x="266" y="27" width="111" height="20"/><box><pen lineStyle="Dashed"/><topPen lineWidth="1.0" lineStyle="Dashed"/><leftPen lineWidth="1.0" lineStyle="Dashed"/><bottomPen lineWidth="1.0" lineStyle="Dashed"/><rightPen lineWidth="1.0" lineStyle="Dashed"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font size="12" isBold="true" isUnderline="false"/></textElement><text><![CDATA[Estimate Total]]></text></staticText><textField pattern="#,##0.00"><reportElement uuid="aa72a838-9356-4002-8030-557562540e3c" mode="Opaque" x="390" y="27" width="98" height="20" backcolor="#CCCCCC"/><box><pen lineWidth="1.0"/><topPen lineWidth="1.0"/><leftPen lineWidth="0.0"/><bottomPen lineWidth="1.0"/><rightPen lineWidth="1.0"/></box><textElement verticalAlignment="Middle"><font size="12" isBold="true"/></textElement><textFieldExpression><![CDATA[$V{TotalCost_1}]]></textFieldExpression></textField><line><reportElement uuid="aed4beba-381f-4be1-9fa9-ccdccfa556b9" x="244" y="14" width="508" height="1"/><graphicElement><pen lineWidth="3.0"/></graphicElement></line><staticText><reportElement uuid="beb07cd2-a197-4b05-b7c0-6f8615cde075" isPrintRepeatedValues="false" x="160" y="58" width="432" height="28"/><box><pen lineWidth="2.0" lineStyle="Solid"/><topPen lineWidth="2.0" lineStyle="Solid"/><leftPen lineWidth="2.0" lineStyle="Solid"/><bottomPen lineWidth="2.0" lineStyle="Solid"/><rightPen lineWidth="2.0" lineStyle="Solid"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font size="8" isBold="false"/></textElement><text><![CDATA[Return quote information to: ____________________ no later than __________ on ____________________ ]]></text></staticText><line><reportElement uuid="8cca7f01-9a0d-4b53-a35e-35fdab717684" x="0" y="8" width="752" height="1"/><graphicElement><pen lineWidth="3.0"/></graphicElement></line><staticText><reportElement uuid="bb0a89c8-0345-41c4-9308-3bbcd9e8da7f" mode="Opaque" x="377" y="27" width="13" height="20" backcolor="#CCCCCC"/><box><topPen lineWidth="1.0"/><leftPen lineWidth="1.0"/><bottomPen lineWidth="1.0"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font size="12" isBold="true"/></textElement><text><![CDATA[$]]></text></staticText></band></summary></jasperReport>

When I do this, the report will not load.

EDIT: I meant parameter, not variable. Replaced in title and body of message.

I have a field in my summary section $V{TotalCost_2}. I have a parameter that is manually entered - $V{Building_Area} - which is the square footage. I would like to divide the total cost by the square footage to arrive at cost per square foot. How can I accomplish this?

Solved my own problem using group headers.

My company uses iReports in conjunction with an estimating software. The software builds an estimate, which is also the table the reports will reference. What I have been trying to do, with no success, is total one column that is sorted by information in another column. To be more specific, our data in the estimate is grouped by item and title similar to the very simple example below: COLUMN 1 COLUMN 2 COLUMN 3 01 division cost of item 01.1 secondary bdivision cost of item 01.1.1 tertiary division cost of item 01.1.1.a item cost of item 01.1.1.b item cost of item 01.1.1.c item cost of item 02 division cost of item 02.1 secondary division cost of item 02.1.1 tertiary division cost of item 02.1.1.a item cost of item 02.1.1.b item cost of item 02.1.1.c item cost of item I am trying to total column3 by the division and subdivision listed in column1 and/or column2. These estimates will contain 20+ divisions, even more secondary and tertiary divisions and thousands to tens of thousands of line items. I need to create reports that group items by division, secondary division, tertiary division as well as unit of measure (another column) and also total the items in the report in the same way. Any help is appreciated.