steven foukaridis

Hi guys,

Got it sorted. All that was required was the addition of the following statement prior to the sql statement in the jrxml file:

<parameter name="EMIS" isForPrompting="true" class="java.lang.String">
<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
</parameter>

Hi guys, I'm having trouble getting my variables across to my .jrxml file.

I'm using php with a java bridge and reports created in ireports. I keep getting the following error: Report design not valid : 1. Query parameter not found : emis

Here's my PHP code:
$compileManager = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager"); $report = $compileManager->compileReport(realpath("promotion.jrxml")); // Get the database connection $objClass = new Java("java.lang.Class"); $objClass->forName('com.mysql.jdbc.Driver'); $objDbm = new Java("java.sql.DriverManager"); $objDbConnect = $objDbm->getConnection("jdbc:mysql://localhost/db", "", ""); $fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager"); $params = new Java("java.util.HashMap"); $params->put('emis', '105480827'); $jasperPrint = $fillManager->fillReport($report, $params, $objDbConnect); $exportManager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager"); $outputPath = realpath(".")."/"."promotion.pdf"; $exportManager->exportReportToPdfFile($jasperPrint, $outputPath); header ('Location: promotion.pdf');

AND my Jrxml (removed unnecessary 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="promotion" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <queryString language="SQL"> <![CDATA[SELECT * FROM TABLE WHERE COLUMN = $P!{EMIS}]]> </queryString> <field name="RPT_PROMOTIONSCHEDULE_LEARNERID" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="52" splitType="Stretch"> </band> </pageHeader> <columnHeader> <band height="84" splitType="Stretch"> </frame> </band> </columnHeader> <detail> <band height="71" splitType="Stretch"> <frame> </frame> </band> </detail> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> </jasperReport>

Hi guys,

I'm having trouble getting my variables across to my .jrxml file.

I'm using php with a java bridge and reports created in ireports.

Here's my PHP code

$fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager"); $params = new Java("java.util.HashMap"); $params->put('emis', 105480827); $jasperPrint = $fillManager->fillReport($report, $params, $objDbConnect); $exportManager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager"); $outputPath = realpath(".")."/"."promotion.pdf"; $exportManager->exportReportToPdfFile($jasperPrint, $outputPath); header ('Location: promotion.pdf');

And here's my respective jrxml code:
<queryString language="SQL"> <![CDATA[SELECT * FROM `RPT_PROMOTIONSCHEDULE` RPT_PROMOTIONSCHEDULE WHERE NATIONALEMIS = $P!{emis}]]>

However, it keeps coming back with the following error:

Report design not valid : 1. Query parameter not found : emis

I'm busy going nuts with this one...