pedro.riky Posted April 23, 2013 Share Posted April 23, 2013 Hi all i have a simple Jasper thath print 3 column. One of this column, is under a printwhen expression, the value is printed in the same xy but print different value depending of some condition. If i print and save a pdf file i have the right result, but if i save an Excel file i lose the cell corrisponding at the printwhenexpression, only in one case. The cell corrisponding to $F{sbilancioDare} is blank.Any ide? resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{bilanciodare}</div><div> resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{bilancioavere}</div><div> calculation="Sum" incrementType="None"> $F{bilanciodare}</div><div> calculation="Sum" incrementType="None"> $F{bilancioavere}</div><div> resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{sbilancioAvere}</div><div> resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{sbilancioDare}</div><div> resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{saldodareSaldo}</div><div> resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{saldoavereSaldo}</div><div> resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{sbilancioAvereSaldo}</div><div> resetGroup="MastroGroup" calculation="Sum" incrementType="None"> $F{sbilancioDareSaldo}</div><div> resetGroup="PrefiGroup" calculation="Sum" incrementType="None"> $F{bilanciodare}</div><div> resetGroup="PrefiGroup" calculation="Sum" incrementType="None"> $F{bilancioavere}</div><div> resetGroup="PrefiGroup" calculation="Sum" incrementType="None"> $F{saldodareSaldo}</div><div> resetGroup="PrefiGroup" calculation="Sum" incrementType="None"> $F{saldoavereSaldo}</div><div> calculation="Sum" incrementType="None"> $F{saldodareSaldo}</div><div> calculation="Sum" incrementType="None"> $F{saldoavereSaldo}</div><div> calculation="Sum" incrementType="None"> $P{mapAttivita}.containsKey($F{prefisso}) ? $F{bilanciodare}.subtract($F{bilancioavere}) : new BigDecimal(0) calculation="Sum" incrementType="None"> $P{mapPassivita}.containsKey($F{prefisso}) ? $F{bilancioavere}.subtract($F{bilanciodare}) : new BigDecimal(0) incrementType="None"> $P{mapNetto}.containsKey($F{prefisso}) ? $F{bilancioavere}.subtract($F{bilanciodare}) : new BigDecimal(0) incrementType="None"> $P{mapCosti}.containsKey($F{prefisso}) ? $F{bilanciodare}.subtract($F{bilancioavere}) : new BigDecimal(0) incrementType="None"> $P{mapRicavi}.containsKey($F{prefisso}) ? $F{bilancioavere}.subtract($F{bilanciodare}) : new BigDecimal(0) calculation="Sum" incrementType="None"> $P{mapAttivita}.containsKey($F{prefisso}) ? $F{saldodareSaldo}.subtract($F{saldoavereSaldo}) : new BigDecimal(0) calculation="Sum" incrementType="None"> $P{mapPassivita}.containsKey($F{prefisso}) ? $F{saldoavereSaldo}.subtract($F{saldodareSaldo}) : new BigDecimal(0) calculation="Sum" incrementType="None"> $P{mapNetto}.containsKey($F{prefisso}) ? $F{saldoavereSaldo}.subtract($F{saldodareSaldo}) : new BigDecimal(0) calculation="Sum" incrementType="None"> $P{mapCosti}.containsKey($F{prefisso}) ? $F{saldodareSaldo}.subtract($F{saldoavereSaldo}) : new BigDecimal(0) calculation="Sum" incrementType="None"> $P{mapRicavi}.containsKey($F{prefisso}) ? $F{saldoavereSaldo}.subtract($F{saldodareSaldo}) : new BigDecimal(0) isReprintHeaderOnEachPage="false"> $F{prefisso} stringUtility.fillSx($F{prefisso}+"",3,'0') + " " + Converter.objectFormatter($P{mapDescPref}.get($F{prefisso}),FieldProps.TYPE_STRING) new Boolean($V{TotalePrefissoDare} .compareTo($V{TotalePrefissoAvere} ) >= 0 && $V{TotalePrefissoDare} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) </div><div> </div><div> $V{TotalePrefissoDare}.subtract($V{TotalePrefissoAvere})</div><div> </div><div> </div><div> new Boolean($V{TotalePrefissoDare} .compareTo($V{TotalePrefissoAvere} ) >= 0 && $V{TotalePrefissoDare} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) D new Boolean($V{TotalePrefissoAvere} .compareTo($V{TotalePrefissoDare} ) >= 0 && $V{TotalePrefissoAvere} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) $V{TotalePrefissoAvere}.subtract($V{TotalePrefissoDare}) new Boolean($V{TotalePrefissoAvere} .compareTo($V{TotalePrefissoDare} ) > 0 && $V{TotalePrefissoAvere} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) A isReprintHeaderOnEachPage="true"> $F{mastro} isPrintRepeatedValues="true"> $P{mapMastri}.get($F{prefisso}.toString() + $F{mastro}.toString()) != null "Totale mastro "+ $P{mapMastri}.get($F{prefisso}.toString() + $F{mastro}.toString()) isPrintRepeatedValues="true"> $P{mapMastri}.get($F{prefisso}.toString() + $F{mastro}.toString()) == null "Totale mastro " + $F{mastro}.toString() new Boolean($V{TotaleBilancioDare} .compareTo($V{TotaleBilancioAvere} ) >= 0 && $V{TotaleBilancioDare} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) $V{TotaleBilancioDare}.subtract($V{TotaleBilancioAvere}) new Boolean($V{TotaleBilancioDare} .compareTo($V{TotaleBilancioAvere} ) >= 0 && $V{TotaleBilancioDare} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) D new Boolean($V{TotaleBilancioAvere} .compareTo($V{TotaleBilancioDare} ) >0 && $V{TotaleBilancioAvere} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) $V{TotaleBilancioAvere}.subtract($V{TotaleBilancioDare}) new Boolean($V{TotaleBilancioAvere} .compareTo($V{TotaleBilancioDare} ) >0 && $V{TotaleBilancioDare} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) A hyperlinkTarget="Self" bookmarkLevel="0"> stretchType="NoStretch" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> $P{intestazione} hyperlinkTarget="Self" bookmarkLevel="0"> stretchType="NoStretch" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> "Pagina " + ( $V{PAGE_NUMBER}.intValue()) hyperlinkTarget="Self" bookmarkLevel="0"> stretchType="NoStretch" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> $P{titolo} Conto Descrizione Saldo new Boolean($V{REPORT_COUNT}.intValue()%2 == 1 && !$P{soloMastri} && (!$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0'))))) isPrintRepeatedValues="true"> !$P{soloMastri} && (!$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0')))) $F{conto} !$P{soloMastri} && ( !$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0')))) isPrintRepeatedValues="true" stretchType="RelativeToBandHeight"> !$P{soloMastri} && ( !$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0')))) $F{nome8_1} !$P{soloMastri} && ( !$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0')))) !$P{soloMastri} && ( !$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0')))) new Boolean($F{sbilancioDare} != null && $F{sbilancioDare}.compareTo(new BigDecimal(BigInteger.ZERO)) != 0 && (!$P{soloTotCliForn} && !$P{soloMastri} || (( $P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0'))))) ) $F{sbilancioDare} !$P{soloMastri} && ( !$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0')))) new Boolean($F{sbilancioDare} != null && $F{sbilancioDare}.compareTo(new BigDecimal(BigInteger.ZERO)) != 0 && (!$P{soloTotCliForn} && !$P{soloMastri} || (( $P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0'))))) ) D !$P{soloMastri} &&( !$P{soloTotCliForn} || ($P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0')))) new Boolean($F{sbilancioAvere} != null && $F{sbilancioAvere}.compareTo(new BigDecimal(BigInteger.ZERO)) != 0 && (!$P{soloTotCliForn} && !$P{soloMastri} || (( $P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0'))))) ) $F{sbilancioAvere} new Boolean($F{sbilancioAvere} != null && $F{sbilancioAvere}.compareTo(new BigDecimal(BigInteger.ZERO)) != 0 && (!$P{soloTotCliForn} && !$P{soloMastri} || (( $P{soloTotCliForn} && !$P{mapCliForn}.containsKey(it.dpe.lib.util.StringUtility.fillSx($F{prefisso}+"",3,'0') + "."+ it.dpe.lib.util.StringUtility.fillSx($F{mastro}+"",4,'0'))))) ) A backcolor="#CCCCCC"/> TOTALI GENERALI TOTALE ATTIVITA' TOTALE PASSIVITA' TOTALE NETTO style="Arial_Bold"> ($V{TotaleAttivita}.subtract($V{TotaleNetto}).subtract($V{TotalePassivita})).compareTo(new BigDecimal(BigInteger.ZERO)) >= 0 UTILE PATRIMONIALE style="Arial_Bold"> ($V{TotaleAttivita}.subtract($V{TotaleNetto}).subtract($V{TotalePassivita})).compareTo(new BigDecimal(BigInteger.ZERO)) < 0 PERDITA PATRIMONIALE TOTALE COSTI TOTALE RICAVI style="Arial_Bold"> ($V{TotaleCosti}) .compareTo($V{TotaleRicavi}) > 0 PERDITA ECONOMICA style="Arial_Bold"> ($V{TotaleRicavi}).compareTo($V{TotaleCosti}.abs()) >= 0 UTILE ECONOMICO new Boolean($V{TotaleBilancioDareReport} .compareTo($V{TotaleBilancioAvereReport} ) >= 0 && $V{TotaleBilancioDareReport} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) $V{TotaleBilancioDareReport}.subtract($V{TotaleBilancioAvereReport}) new Boolean($V{TotaleBilancioDareReport} .compareTo($V{TotaleBilancioAvereReport} ) >= 0 && $V{TotaleBilancioDareReport} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) D new Boolean($V{TotaleBilancioAvereReport} .compareTo($V{TotaleBilancioDareReport} ) >=0 && $V{TotaleBilancioAvereReport} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) $V{TotaleBilancioAvereReport}.subtract($V{TotaleBilancioDareReport}) new Boolean($V{TotaleBilancioAvereReport} .compareTo($V{TotaleBilancioDareReport} ) > 0 && $V{TotaleBilancioAvereReport} .compareTo(new BigDecimal(BigInteger.ZERO) ) != 0 ) A $V{TotaleAttivita}.abs() $V{TotaleAttivita}.signum() == -1 ? "A" : "D" $V{TotalePassivita}.abs() $V{TotalePassivita}.signum() == -1 ? "D" : "A" $V{TotaleNetto}.abs() $V{TotaleNetto}.signum() == -1 ? "D" : "A" ($V{TotaleAttivita}.subtract($V{TotalePassivita}).subtract($V{TotaleNetto})).abs() $V{TotaleCosti}.abs() $V{TotaleCosti}.signum() == -1 ? "A" : "D" $V{TotaleRicavi}.abs() $V{TotaleRicavi}.signum() == -1 ? "D" : "A" ($V{TotaleRicavi}.subtract($V{TotaleCosti})).abs() ($P{mapReturn}.put("patrimoniale", $V{TotaleAttivita}.subtract($V{TotaleNetto}).subtract($V{TotalePassivita})) == null ?Boolean.FALSE:Boolean.FALSE) ($P{mapReturn}.put("economico", ($V{TotaleRicavi}.subtract($V{TotaleCosti}))) == null ?Boolean.FALSE:Boolean.FALSE) [/code] The cell corrisponding to $F{sbilancioDare} is blank.Why?any idea? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now