Cralevic

HI Anand, yep I'm. I enclose even .xls file. Cralevic current IReport version 4.1.2

Hi Anand, as I promise I enclose pictures and code. In the final screen I put those two fields to each other. Do not hesitate to contact me again :-) Cralevic Wrote: Hi Anand, yep I mean field. Yes exactly. Tomorrow I'll post some pictures and code. Those two fields should be on the each other. Cralevic current IReport version 4.1.2 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="condition" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <queryString> <![CDATA[sELECT show, val FROM (SELECT 'Y' as show, sysdate as val FROM dual UNION ALL SELECT 'N' as show, sysdate as val FROM dual)]]> </queryString> <field name="SHOW" class="java.lang.String"/> <field name="VAL" class="java.sql.Timestamp"/> <background> <band splitType="Stretch"/> </background> <title> <band splitType="Stretch"/> </title> <pageHeader> <band splitType="Stretch"/> </pageHeader> <columnHeader> <band height="42" splitType="Stretch"> <staticText> <reportElement x="0" y="22" width="100" height="20"/> <textElement/> <text><![CDATA[sHOW]]></text> </staticText> <staticText> <reportElement x="100" y="22" width="100" height="20"/> <textElement/> <text><![CDATA[VAL]]></text> </staticText> </band> </columnHeader> <detail> <band height="21" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="100" height="20"/> <box> <bottomPen lineWidth="1.0"/> </box> <textElement> <font size="10"/> </textElement> <textFieldExpression><![CDATA[$F{SHOW}]]></textFieldExpression> </textField> <textField> <reportElement x="100" y="0" width="100" height="20"> <printWhenExpression><![CDATA[$F{SHOW}.equals( "Y" )]]></printWhenExpression> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <textElement/> <textFieldExpression><![CDATA[$F{VAL}]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="100" y="0" width="100" height="20" backcolor="#FF0033"> <printWhenExpression><![CDATA[$F{SHOW}.equals( "N" )]]></printWhenExpression> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <textElement/> <textFieldExpression><![CDATA[$F{VAL}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band splitType="Stretch"/> </pageFooter> <summary> <band splitType="Stretch"/> </summary></jasperReport>

Hi Anand, yep I mean field. Yes exactly. Tomorrow I'll post some pictures and code. Those two fields should be on the each other. Cralevic current IReport version 4.1.2

The other workaround I have used is simple but not very comfortable. I have two cells with same source, one has white background the oher has red backgroud color in property "backcolor". According to value in specified column I show the "white" or the "red" cell using condition in property "print when expression". Cralevic current IReport version 4.1.2

Hi, You have change for example the crosstable header not just the cell itself. In the crosstab header for example you have to change the backcolor property and check opaque property. Then it should works fine. Cralevic current IReport version 4.1.2

Hi, have you tried for example backcolor='red' instead of color number? Open Office has some bugs with displayed colors. I use in my exports colors [191,225,255] or [204,192,218], but now I don't know their number ... Hope it'll help you somehow.

Do you have checked checkbox "Print repeated values"??

Thanks for replying! I just found some workaround solution using conditional formating. Cralevic

Hi all, I have one report, that connects to Oracle DB and produces a .CSV file. This file is source for another parameterized report with export to .PDF. Am I somehow able to create one report that will replace those two? It means, this new report should connect to database, creates .CSV file, than run again, connects to .CSV file and the result export to .PDF? Thanks for any replies.

Hi all, I have same problem. Yep, the subreport is solution I think. I have the master report based on data1.csv. The subreport is based on data2.csv. Both alone are functional. But I don't know how to give source to the subreport. Can anybody help?? Any ideas?

Yeah! I'm so silly. :silly: The subselect works with dummy well. I tried it already, but I didn't know the syntax exactly. I have another question. May I somehow use IF - THEN or do loops? Thank you for other tips :kiss:

Hello, I have simillar problem, but I don't want to rewrite this function from PL/SQL into java class. Is then any solution how to use the function in PL/SQL directly in iReport? Thanks for answering ;)