Frans Lubbe posted a comment on discussion General Discussion

WIll this type of formatting/conditions work in PL-jrxml2pdf: <printWhenExpression><![CDATA[$V{DUTY_ALLOC_ID} != null]]></printWhenExpression> and also: <textFieldExpression><![CDATA[$P{P_TITLE}!=null?$P{P_TITLE}:$R{header.title}]]></textFieldExpression> Thanks in advance for your reponse.

Frans Lubbe modified a comment on discussion General Discussion

Frans Lubbe posted a comment on discussion General Discussion

Andreas, Thanks for your reponse. Just another question .... WIll this type of formatting work in PL-jrxml2pdf: <printWhenExpression><![CDATA[$V{DUTY_ALLOC_ID} != null]]></printWhenExpression> and also, will this work: <textFieldExpression><![CDATA[$P{P_TITLE}!=null?$P{P_TITLE}:$R{header.title}]]></textFieldExpression>

Frans Lubbe posted a comment on discussion General Discussion

I have also tried with this <subreportExpression><!["DutyRoster_Detail.jasper"]]></subreportExpression>

Frans Lubbe posted a comment on discussion General Discussion

Thanks for your support and quick response.

Frans Lubbe modified a comment on discussion General Discussion

Hi there, I have one subreport that I specify in the main jrxml file as <subreport> <reportElement x="0" y="0" width="55" height="24" uuid="655570ea-7932-4173-a7e8-464aac9ec3c4"> <printWhenExpression><![CDATA[$V{DUTY_ALLOC_ID} != null]]></printWhenExpression> </reportElement> <subreportParameter name="P_DUTY_ALLOC_ID"> <subreportParameterExpression><![CDATA[$V{DUTY_ALLOC_ID}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$V{REPORT_CONNECTION}]]></connectionExpression>...

Frans Lubbe posted a comment on discussion General Discussion

Hi there, I have one subreport that I specify in the main jrxml file as <subreport> <reportElement x="0" y="0" width="55" height="24" uuid="655570ea-7932-4173-a7e8-464aac9ec3c4"> <printWhenExpression><![CDATA[$V{DUTY_ALLOC_ID} != null]]></printWhenExpression> </reportElement> <subreportParameter name="P_DUTY_ALLOC_ID"> <subreportParameterExpression><![CDATA[$V{DUTY_ALLOC_ID}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$V{REPORT_CONNECTION}]]></connectionExpression>...

Frans Lubbe posted a comment on discussion General Discussion

Hey Guys/Girls, I have the following <textFieldExpression> in Jasper that returns 'SAT 1' for an example. <textFieldExpression><![CDATA[(new SimpleDateFormat("EEEE")).format($V{THE_DAY}).substring(0,3).toUpperCase() + " " + DAY($V{THE_DAY}).toString()]]></textFieldExpression> When I run the same code through PL-jrxml2pdf I get the output of 'EEEE04/01/17' It seems that SimpleDateFormat has issues in Oracle. Any idea how to resolve? Help much appreciated.!

Frans Lubbe modified a comment on discussion General Discussion

Yes, found the issue. It was not with the SQL query, but rather with the IF statement $F{DUTY_NAME} + "|" + ($F{DUTY_DESCRIPTION}!=null?$F{DUTY_DESCRIPTION}:"") Thanks for your response.

Frans Lubbe posted a comment on discussion General Discussion

Yes, found the issue. It was not with the SQL query, but rather with the IF statement, thanks

Frans Lubbe posted a comment on discussion General Discussion

Hey there, please help. I can execute my jasper report no problem, but as soon as I run it via PL-jrxml2pdf, I get an ORA-00907: missing right parenthesis error. Other reports work fine, so it must be something with this specific one. I am using the latest PL-jrxml2pdf, downloaded 1 month ago. S Please see my code below. <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2017-05-08T18:39:21 --> <jasperReport...