pennywise

Hi everyone, I will like to know if is posible hide visual elements in a report like static labels, lines, etc, using a param, i need user can configure the report with options like tables, show or not the date, show or not the title, etc, Thanks.

Ahhhhh, i see, well when i tryed use == null it show a exception, maybe is the form how i use it, how you make a condition using null, and how is the or sintaxys: for example: if varA==null and varA.lenght < 0 -> how is the equivalent in jasperreports thanks all for your reply

You said using scriplets? Wel i think i can resolve this issue if i know how make if else in jasperreports, is not clear how to do this, I know if is = (<condition> expre1 ? expre 2 :) but else? how you do a normal if-else block on jasperreports, for example to do if(varA.lenght<0){ make something }else{ make this }

I tryed this: ($V{variableA}.doubleValue() < 0 ? 0 : $V{variableA})+($V{variableB}.doubleValue() < 0 ? 0 : $V{variableB})+($V{variableC}.doubleValue() < 0 ? 0 : $V{variableC}) but there is an exeption: Incompatible conditional operands types int and double

VARIABLE A is double, i can't use ==, i tryed using variableA.intvalue() < 0 but i doesn't works, :(

Hi everyone, i have a variable wich sum a field, but when i don't have registers in the field the report show null in the variable, so i need to show 0 when i don't have register, that because i use that variable is in a subreport and i use it in a master report to make another num; subreport-> VARIABLE A = null Master report-> VARIABLEA+VARIABLEB+VARIABLEC if VARIABLEA = null master report show null, it doesn't matter if there are values in B or C :(, that's my problem

I solve the problem, Right Click in the report->properties->ignore pagination :)

Hi, i am using a line in the top of the footer to simulate a table, but when i display the inform there is a gap between the detail last record of the page and the footer line, How i solve it?, thanks for reply in advance. This is my code: <?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="presupuesto" pageWidth="572" pageHeight="752" whenNoDataType="BlankPage" columnWidth="572" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isFloatColumnFooter="false"> <style name="Crosstab Data Text" isDefault="false" hAlign="Center"/> <parameter name="nombreEmpresa" class="java.lang.String"/> <parameter name="nombreObra" class="java.lang.String"/> <parameter name="nombreCliente" class="java.lang.String"/> <queryString> <![CDATA[sELECT PARTIDASPRESUPUESTOS.descripcionPartidas AS PARTIDASPRESUPUESTOS_descripcionPartidas, PARTIDASPRESUPUESTOS.codigoCoveninPartidas AS PARTIDASPRESUPUESTOS_codigoCoveninPartidas, PARTIDASPRESUPUESTOS.unidadPartidas AS PARTIDASPRESUPUESTOS_unidadPartidas, PARTIDASPRESUPUESTOS.idPartida AS idPartida, ROUND(PARTIDASPRESUPUESTOS.precioUnitario,2) AS PARTIDASPRESUPUESTOS_precioUnitario, ROUND(PARTIDASPRESUPUESTOS.cantidadPartidas,2) AS PARTIDASPRESUPUESTOS_cantidadPartidas, ROUND(PARTIDASPRESUPUESTOS.cantidadPartidas*PARTIDASPRESUPUESTOS.precioUnitario, 2) AS totalPartidas FROM PARTIDASPRESUPUESTOS PARTIDASPRESUPUESTOS]]> </queryString> <field name="PARTIDASPRESUPUESTOS_descripcionPartidas" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PARTIDASPRESUPUESTOS_codigoCoveninPartidas" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PARTIDASPRESUPUESTOS_unidadPartidas" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="idPartida" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PARTIDASPRESUPUESTOS_precioUnitario" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PARTIDASPRESUPUESTOS_cantidadPartidas" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="totalPartidas" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <variable name="sumatoriaHoja" class="java.lang.String"/> <variable name="totalesHoja" class="java.lang.Double" calculation="Sum"> <variableExpression><![CDATA[$F{totalPartidas}]]></variableExpression> </variable> <pageHeader> <band height="150" splitType="Stretch"> <textField> <reportElement x="12" y="12" width="149" height="20"/> <textElement> <font fontName="Arial" size="14" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{nombreEmpresa}]]></textFieldExpression> </textField> <textField> <reportElement x="48" y="51" width="356" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$P{nombreObra}]]></textFieldExpression> </textField> <textField> <reportElement x="71" y="71" width="333" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$P{nombreCliente}]]></textFieldExpression> </textField> <staticText> <reportElement x="12" y="51" width="36" height="20"/> <textElement/> <text><![CDATA[OBRA:]]></text> </staticText> <staticText> <reportElement x="12" y="71" width="59" height="15"/> <textElement/> <text><![CDATA[Contratante:]]></text> </staticText> <staticText> <reportElement x="197" y="103" width="195" height="20"/> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[PRESUPUESTO DE OBRAS]]></text> </staticText> </band> </pageHeader> <columnHeader> <band height="29" splitType="Stretch"> <staticText> <reportElement x="12" y="15" width="59" height="13" forecolor="#FF0000"/> <textElement/> <text><![CDATA[PARTIDA No]]></text> </staticText> <staticText> <reportElement x="125" y="15" width="74" height="13" forecolor="#FF0033"/> <textElement/> <text><![CDATA[DESCRIPCION]]></text> </staticText> <staticText> <reportElement x="258" y="15" width="44" height="13" forecolor="#FF0033"/> <textElement/> <text><![CDATA[uNIDAD]]></text> </staticText> <staticText> <reportElement x="325" y="15" width="57" height="13" forecolor="#FF0033"/> <textElement/> <text><![CDATA[CANTIDAD]]></text> </staticText> <staticText> <reportElement x="404" y="15" width="89" height="13" forecolor="#FF0033"/> <textElement/> <text><![CDATA[PRECIO UNITARIO]]></text> </staticText> <staticText> <reportElement x="517" y="15" width="38" height="13" forecolor="#FF0033"/> <textElement/> <text><![CDATA[TOTAL]]></text> </staticText> <line> <reportElement x="12" y="28" width="558" height="1"/> </line> <line> <reportElement x="11" y="0" width="559" height="1"/> </line> <line> <reportElement x="11" y="1" width="1" height="28"/> </line> <line> <reportElement x="84" y="0" width="1" height="29"/> </line> <line> <reportElement x="247" y="0" width="1" height="28"/> </line> <line> <reportElement x="318" y="0" width="1" height="29"/> </line> <line> <reportElement x="391" y="1" width="1" height="27"/> </line> <line> <reportElement x="504" y="1" width="1" height="27"/> </line> <line> <reportElement x="569" y="0" width="1" height="29"/> </line> </band> </columnHeader> <detail> <band height="5" splitType="Stretch"> <line> <reportElement stretchType="RelativeToBandHeight" x="11" y="0" width="1" height="5"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="84" y="0" width="1" height="5"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="247" y="0" width="1" height="5"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="391" y="0" width="1" height="5"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="318" y="0" width="1" height="5"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="504" y="0" width="1" height="5"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="569" y="0" width="1" height="5"/> </line> </band> <band height="32"> <textField isStretchWithOverflow="true"> <reportElement stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="86" y="16" width="161" height="16" isRemoveLineWhenBlank="true"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{PARTIDASPRESUPUESTOS_descripcionPartidas}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="86" y="1" width="161" height="15" isRemoveLineWhenBlank="true"/> <textElement> <font isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{PARTIDASPRESUPUESTOS_codigoCoveninPartidas}]]></textFieldExpression> </textField> <textField pattern="¤ #,##0.00"> <reportElement x="249" y="6" width="68" height="16" isRemoveLineWhenBlank="true"/> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA[$F{PARTIDASPRESUPUESTOS_unidadPartidas}]]></textFieldExpression> </textField> <textField> <reportElement x="319" y="7" width="71" height="16" isRemoveLineWhenBlank="true"/> <textElement textAlignment="Right"/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{PARTIDASPRESUPUESTOS_cantidadPartidas}]]></textFieldExpression> </textField> <textField> <reportElement x="393" y="6" width="106" height="16" isRemoveLineWhenBlank="true"/> <textElement textAlignment="Right"/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{PARTIDASPRESUPUESTOS_precioUnitario}]]></textFieldExpression> </textField> <textField> <reportElement x="13" y="16" width="70" height="16" isRemoveLineWhenBlank="true"/> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{idPartida}]]></textFieldExpression> </textField> <line> <reportElement stretchType="RelativeToBandHeight" x="11" y="0" width="1" height="32"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="247" y="0" width="1" height="31"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="391" y="0" width="1" height="31"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="318" y="0" width="1" height="31"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="84" y="0" width="1" height="31"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="504" y="0" width="1" height="32"/> </line> <line> <reportElement stretchType="RelativeToBandHeight" x="569" y="0" width="1" height="32"/> </line> <textField> <reportElement x="505" y="6" width="60" height="16" isRemoveLineWhenBlank="true"/> <textElement textAlignment="Right"/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{totalPartidas}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="49" splitType="Immediate"> <textField> <reportElement x="469" y="12" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.Double"><![CDATA[$V{totalesHoja}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="0" width="556" height="1"/> </line> </band> </columnFooter> <pageFooter> <band height="44" splitType="Stretch"> <staticText> <reportElement x="461" y="0" width="38" height="14"/> <textElement/> <text><![CDATA[Pagina]]></text> </staticText> <textField> <reportElement x="504" y="0" width="22" height="14"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> <staticText> <reportElement x="527" y="0" width="16" height="14"/> <textElement/> <text><![CDATA[de]]></text> </staticText> <textField evaluationTime="Report"> <reportElement x="543" y="0" width="27" height="14"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField pattern="dd/MM/yyyy"> <reportElement x="499" y="14" width="71" height="20"/> <textElement/> <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <staticText> <reportElement x="461" y="14" width="38" height="20"/> <textElement/> <text><![CDATA[Fecha:]]></text> </staticText> <staticText> <reportElement x="0" y="0" width="161" height="20"/> <textElement/> <text><![CDATA[Latinsoft Infocon Control de obras]]></text> </staticText> </band> </pageFooter> <lastPageFooter> <band height="50"/> </lastPageFooter> </jasperReport>

OUCH, Thank you guillo, I tryed using lines in pageheader and pagefooter, i change the lines horientation to simulate a grid, how can i contribute to the developement of the grid component?.

Hi comunity, i need to do a report like this, how can i do this in ireport, thanks so much, regards your friend pennyWise: idProduct productDescriprion productUnit priceByUnit totalPriceofProduct