problem passing parameters from PHP to JRXML

[steven foukaridis]

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>

[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>