bogdangh

Unfortunately i didnt overcome the problem :|

Hi, in my crosstab i get values of 0 in cells that should have no data, as no data was given from DB. How can i eliminate the 0's ? Ex: dataSource: R1 C1 V1; R2 C2 V2 the report looks like this: Code: ---- C1 - C2 -R1- V1 - 0 -R2- 0 - V2 how do i get the 0 in R1C2 and R2C1 positions ? the code i used: Code:[code] <field name="Value" class="java.lang.Double"/> <measure name="Value_Count" class="java.lang.Double" calculation="Count"> <measureExpression><![CDATA[$F{Value}]]></measureExpression> </measure> <crosstabCell width="150" height="17"> <cellContents backcolor="#FFFFFF" mode="Transparent"> <box topBorder="1Point" topBorderColor="#FFFFFF" leftBorder="1Point" leftBorderColor="#FFFFFF" rightBorder="1Point" rightBorderColor="#FFFFFF" bottomBorder="1Point" bottomBorderColor="#FFFFFF"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="150" height="17" key="textField-8"> <printWhenExpression><![CDATA[new Boolean($P{FormulaType}.equals("Count"«»))]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{Value_Count}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> I use jr1.2.3. Any help is appreciated. Bogdan.

I managed to make it work, thank you. Bogdan

Hi, can anyone help me with the calculation of the total for the rows ? I have the following problem: i want to show the total after each row group like this : Code: --------------------------------------------- RowHeader1 | RowHeader2 | column1 | column2 --------------------------------------------- A | B | X1 | X2 A | C | X3 | X4 Total ----------------| X1+X3 | X2+X4 D | E | X5 | X6 D | F | X7 | X8 Total ------------------| X5+X7 | X6+X8 but I get : Code:[code] --------------------------------------------- RowHeader1 | RowHeader2 | column1 | column2 --------------------------------------------- A | B | X1 | X2 A | C | X3 | X4 D | E | X5 | X6 D | F | X7 | X8 Total -----------------|X1+X3+X5+X7|X2+X4+X6+X8 the code i used: Code:[code] <rowGroup name="reference" width="100" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{reference}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="17" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{reference}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents mode="Transparent"> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <staticText> <reportElement x="0" y="0" width="100" height="17" key="staticText-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <text><![CDATA[Reference total]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <crosstabCell width="100" height="17" rowTotalGroup="reference"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="17" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{Value_Count}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> Thanks in advance Bogdan.

On my machine i have also -XX:NewSize=200m. If this one doesnt help either, i'm out of ideas. B.

In JVM settings from Eclipse set: -Xmx512m (or -Xmx1024m) -XX:MaxPermSize=256m and see if you get the same error.

I managed to get it working after setting -XX:MaxPermSize=256m Post edited by: bogdangh, at: 2006/11/24 11:29

Hi, I have a problem with the compilation of the JasperDesign object. I use jasperreports-1.2.3. I have copied the example from the NoXmlDesignApp and i get an 'java.lang.OutOfMemoryError: PermGen space' exception every time i run the code that compiles the JD object. The code i used: Code: JasperDesign jasperDesign = getJasperDesign(); JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign); where getJasperDesign() is the function in NoXmlDesignApp sample. I have the JVM start with 512M and even 1024M. Do i do something wrong that i get the exception ?

Yes, this is the situation. First i though that i can hide/collapse the unwanted rows/columns from the crosstab but found out that is not possible and finally i got to your solution, building the report dynamically. My solution is to make a jrxml template with all the rows/columns that the user can choose, based on this to get the JasperReport object and than, based on the real criteria that was selected, to eliminate the unnecessary rows/columns and related info. Bogdan. Post edited by: bogdangh, at: 2006/11/23 11:26 Post edited by: bogdangh, at: 2006/11/23 11:27

That much i understood. My question remains if it is possible with JR to make from the same jrxml template a report that has it's rows and columns decided by user input from a given criteria (as shown in the example). Bogdan.

I'll try to modify the report design. I though it was an easier way, directly from the jrxml. Thank you B. Post edited by: bogdangh, at: 2006/11/22 13:50

Hi, if the report has multiple column groups, can some of them be hidden/collapsed with printWhenExpression and removeLineWhenBlank (or any other solution) ? I want to remove/collapse the entire column group if there are no values to show. The code i used: Code: <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="aaa" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="800" pageHeight="1000" columnWidth="740" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <field name="commodity" class="java.lang.String"/> <field name="company" class="java.lang.String"/> <field name="deliv" class="java.lang.String"/> <field name="pht" class="java.lang.String"/> <field name="value" class="java.lang.Double"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="0" isSplitAllowed="true" > </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="700" isSplitAllowed="true" > <crosstab > <reportElement x="14" y="20" width="702" height="660" key="crosstab-1"/> <crosstabHeaderCell> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabHeaderCell> <rowGroup name="company" width="100"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{company}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="30" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{company}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> </rowGroup> <rowGroup name="deliv" width="100"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{deliv}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="30" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{deliv}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> </rowGroup> <columnGroup name="commodity" height="25" headerPosition="Center"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{commodity}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="25" key="textField" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[new Boolean($V{commodity} != null)]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{commodity}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> </columnGroup> <columnGroup name="pht" height="25" headerPosition="Center"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{pht}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="25" key="textField" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[new Boolean($V{pht} != null)]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{pht}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> </columnGroup> <measure name="value_Nothing" class="java.lang.Double"> <measureExpression><![CDATA[$F{value}]]></measureExpression> </measure> <crosstabCell width="50" height="30"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="30" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{value_Nothing}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="0" height="30" columnTotalGroup="pht"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="30" columnTotalGroup="commodity"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="50" height="0" rowTotalGroup="deliv"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="deliv" columnTotalGroup="pht"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="deliv" columnTotalGroup="commodity"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="50" height="0" rowTotalGroup="company"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="company" columnTotalGroup="pht"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="company" columnTotalGroup="commodity"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <whenNoDataCell> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </whenNoDataCell> </crosstab> </band> </summary> </jasperReport> But instead of removing the entire column group, the group is shown with no values inside. This is quite important so any help will be greatly appreciated.

Hi, if the report has multiple column groups, can some of them be hidden/collapsed with printWhenExpression and removeLineWhenBlank (or any other solution) ? I want to remove/collapse the entire column group if there are no values to show. The code i used: Code: <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="aaa" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="800" pageHeight="1000" columnWidth="740" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <field name="commodity" class="java.lang.String"/> <field name="company" class="java.lang.String"/> <field name="deliv" class="java.lang.String"/> <field name="pht" class="java.lang.String"/> <field name="value" class="java.lang.Double"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="0" isSplitAllowed="true" > </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="700" isSplitAllowed="true" > <crosstab > <reportElement x="14" y="20" width="702" height="660" key="crosstab-1"/> <crosstabHeaderCell> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabHeaderCell> <rowGroup name="company" width="100"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{company}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="30" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{company}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> </rowGroup> <rowGroup name="deliv" width="100"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{deliv}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="30" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{deliv}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> </rowGroup> <columnGroup name="commodity" height="25" headerPosition="Center"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{commodity}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="25" key="textField" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[new Boolean($V{commodity} != null)]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{commodity}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> </columnGroup> <columnGroup name="pht" height="25" headerPosition="Center"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{pht}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="25" key="textField" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[new Boolean($V{pht} != null)]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{pht}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> </columnGroup> <measure name="value_Nothing" class="java.lang.Double"> <measureExpression><![CDATA[$F{value}]]></measureExpression> </measure> <crosstabCell width="50" height="30"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="30" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{value_Nothing}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="0" height="30" columnTotalGroup="pht"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="30" columnTotalGroup="commodity"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="50" height="0" rowTotalGroup="deliv"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="deliv" columnTotalGroup="pht"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="deliv" columnTotalGroup="commodity"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="50" height="0" rowTotalGroup="company"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="company" columnTotalGroup="pht"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <crosstabCell width="0" height="0" rowTotalGroup="company" columnTotalGroup="commodity"> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </crosstabCell> <whenNoDataCell> <cellContents mode="Transparent"> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> </cellContents> </whenNoDataCell> </crosstab> </band> </summary> </jasperReport> But instead of removing the entire column group, the group is shown with no values inside. This is quite important so any help will be greatly appreciated.

A yes or no will just make my day. Can anyone help me ? Teodor ? B.

Anyone with an answer ? Please, this is quite urgent. Bogdan PS: I have uploaded an image with how the report should look like. Can someone tell me if this can be done with JR ? Post edited by: bogdangh, at: 2006/11/21 17:07 [file name=img.gif size=49724]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/img.gif[/file] Post edited by: bogdangh, at: 2006/11/21 17:08