kkracko

I've created a crosstab in the summary band but it does not display anything at all. I frequently use charts but this is the first time I've tried to do a crosstab. Any help is greatly appreciated. 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="Summary By Product xtab test3" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="792" pageHeight="612" columnWidth="732" 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.*" /> <queryString><![CDATA[sELECT * FROM dbo.vw_ECR_cost_summary_by_product]]></queryString> <field name="PRODUCT" class="java.lang.String"/> <field name="ECNSTATUS" class="java.lang.String"/> <field name="ECRFORMATTED" class="java.lang.String"/> <field name="ECRs" class="java.lang.Integer"/> <field name="ECRs Due" class="java.lang.Integer"/> <field name="Days_Complete" class="java.lang.Integer"/> <field name="ReasonCode" class="java.lang.String"/> <field name="Cost" class="java.lang.String"/> <field name="Annualized" class="java.math.BigDecimal"/> <field name="cip" class="java.lang.String"/> <field name="ALL" class="java.lang.Integer"/> <field name="OPEN" class="java.lang.Integer"/> <field name="DUE" class="java.lang.Integer"/> <field name="start_time" class="java.sql.Timestamp"/> <field name="end_time" class="java.sql.Timestamp"/> <variable name="CountReasonCode" class="java.lang.Integer" resetType="Report" calculation="Count"> <variableExpression><![CDATA[$F{ReasonCode}]]></variableExpression> </variable> <variable name="CountReasonCodeByProduct" class="java.lang.Integer" resetType="Report" calculation="Count"> <variableExpression><![CDATA[$F{ReasonCode}]]></variableExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="50" isSplitAllowed="true" > <staticText> <reportElement x="61" y="5" width="412" height="40" key="staticText"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font size="28" isBold="true"/> </textElement> <text><![CDATA[Classic Report Template]]></text> </staticText> <line direction="TopDown"> <reportElement x="0" y="48" width="534" height="0" forecolor="#000000" key="line" positionType="FixRelativeToBottom"/> <graphicElement stretchType="NoStretch" pen="2Point"/> </line> <line direction="TopDown"> <reportElement x="0" y="3" width="534" height="0" forecolor="#000000" key="line"/> <graphicElement stretchType="NoStretch" pen="2Point"/> </line> </band> </title> <pageHeader> <band height="9" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="20" isSplitAllowed="true" > <rectangle radius="0" > <reportElement mode="Opaque" x="1" y="1" width="534" height="17" forecolor="#000000" backcolor="#999999" key="element-22"/> <graphicElement stretchType="NoStretch" pen="Thin"/> </rectangle> <staticText> <reportElement x="0" y="1" width="133" height="16" forecolor="#FFFFFF" key="element-90"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="" size="12"/> </textElement> <text><![CDATA[PRODUCT]]></text> </staticText> <staticText> <reportElement x="133" y="1" width="133" height="16" forecolor="#FFFFFF" key="element-90"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="" size="12"/> </textElement> <text><![CDATA[ReasonCode]]></text> </staticText> <staticText> <reportElement x="266" y="1" width="133" height="16" forecolor="#FFFFFF" key="element-90"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="" size="12"/> </textElement> <text><![CDATA[Annualized]]></text> </staticText> <staticText> <reportElement x="399" y="1" width="133" height="16" forecolor="#FFFFFF" key="element-90"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="" size="12"/> </textElement> <text><![CDATA[Days_Complete]]></text> </staticText> </band> </columnHeader> <detail> <band height="19" isSplitAllowed="true" > <line direction="TopDown"> <reportElement x="0" y="17" width="535" height="0" forecolor="#808080" key="line" positionType="FixRelativeToBottom"/> <graphicElement stretchType="NoStretch" pen="Thin"/> </line> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="1" width="133" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="Times-Roman" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{PRODUCT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="133" y="1" width="133" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="Times-Roman" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{ReasonCode}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="266" y="1" width="133" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="Times-Roman" size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{Annualized}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="399" y="1" width="133" height="15" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="Times-Roman" size="12"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{Days_Complete}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="25" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="325" y="4" width="170" height="19" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font fontName="Helvetica" size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="499" y="4" width="36" height="19" forecolor="#000000" backcolor="#FFFFFF" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="0" y="1" width="535" height="0" forecolor="#000000" key="line"/> <graphicElement stretchType="NoStretch" pen="2Point"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="1" y="6" width="209" height="19" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font fontName="Times-Roman" size="10"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="384" isSplitAllowed="true" > </band> </summary></jasperReport>

I've tried creating a crosstab report following the example in the iReport Definitive Guide but nothing ever displays. The crosstab is in the summary and I tried a subdataset but display is nothing but blank pages. I also checked 'Use a dataset to fill the crosstab and parameter 'Use connection expression' $P{REPORT_CONNECTION} iReport version 2.02, no error messages are generated Does anyone have any ideas or a simple working example I can use to see what the problem is? Thanks,

I have a report with a simple input string parameter which filters the result. My users have requested a drop down list of valid selections on the input parameter rather than free text input. The input list can be hard coded or even better would be a lookup of the possible selections using a query. Thanks,

I tried this and it worked! It also works with NOT new Integer(!($F{STATUS}.equals("Completed")) ? 1 : 0) How could it work if there is more than one condition. ($F{STATUS}.equals("Completed") ($F{STATUS}.equals("InProcess") ? Thanks