how to set php parameter in jasper report
dear all need help php parameter in jasper report i want make some report with jasper report and php. i want that's query in jasper report from some value in PHP. for the next step i want make dynamic.
jrxml
  <parameter name="parameter1" class="java.lang.String"/>      <queryString>          <![CDATA[select merk, type, tahun from tbl_mobil where merk =$P{parameter1}]]>      </queryString>      and the php code
  <?php  error_reporting(0);  /*    * To change this template, choose Tools | Templates   * and open the template in the editor.   */  include_once('phpjasperxml_0.9d/class/tcpdf/tcpdf.php');  include_once("phpjasperxml_0.9d/class/PHPJasperXML.inc.php");  include_once ('phpjasperxml_0.9d/setting.php');    $server = "localhost";  $user = "root";  $pass = "";  $db = "mobil";  $nilai ="Honda";        $PHPJasperXML = new PHPJasperXML();  //$PHPJasperXML->debugsql=true;  $PHPJasperXML->arrayParameter=array("parameter1"=>$nilai);  $PHPJasperXML->load_xml_file("sandi.jrxml");    $PHPJasperXML->transferDBtoArray($server,$user,$pass,$db);  $PHPJasperXML->outpage("I");    //page output method I:standard output  D:Download file      ?>      and the result like this enter image description here
No comments:
Post a Comment