Personal tools
You are here: Home Blog PHP and JasperReports
Document Actions

PHP and JasperReports

by Nathan Cassano last modified 2007-10-17 10:42

Example of how to use PHP and JasperReports with paging

Here is an example of how to use PHP with JasperReports and also do some paging.

Example:
<?php

// Compile report
$objJcm = new Java("net.sf.jasperreports.engine.JasperCompileManager");
$objReport = $objJcm->compileReport("classic.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/mydatabase", "user", "pass");

// Run the report
$objJfm = new Java("net.sf.jasperreports.engine.JasperFillManager");
$objPrint = $objJfm->fillReport($objReport, new Java("java.util.HashMap"), $objDbConnect);

// Setup file stream
$objStream = new Java("java.io.ByteArrayOutputStream");

// Get object containing export parameters
$objJep = new Java('net.sf.jasperreports.engine.JRExporterParameter');

// Export to HTML
$objJhe = new Java("net.sf.jasperreports.engine.export.JRHtmlExporter");

// Set the source report result print object
$objJhe->setParameter($objJep->JASPER_PRINT, $objPrint );

// Display only the first page
$objJhe->setParameter($objJep->PAGE_INDEX, new Java('java.lang.Integer', 0 ) );

// Set the stream output destination
$objJhe->setParameter($objJep->OUTPUT_STREAM, $objStream );

//
$objJhe->exportReport();

// Display the HTML to the screen
echo $objStream->toString();

?>
Links
« February 2010 »
Su Mo Tu We Th Fr Sa
123456
78910111213
14151617181920
21222324252627
28
 

Powered by Plone CMS, the Open Source Content Management System