malsmary
commented
4 years ago PHPJasperXML Unable to print table data or SUBREPORT OR TABLES, NOTHING IS SHOWING
Open mihaip007 opened 6 years ago
malsmary
commented
4 years ago PHPJasperXML Unable to print table data or SUBREPORT OR TABLES, NOTHING IS SHOWING
tests.zip Hi - I came across your project and I am so happy that it works without the need of using TomCat and PHP JavaBridge, which is the way I was doing it...
Anyway - I used the following code and I came across 2 issues:
include_once('PhpJasperLibrary/tcpdf/tcpdf.php'); include_once('PhpJasperLibrary/PHPJasperXML.inc.php'); $server='localhost'; $db='xxxxxxxx'; $user='xxxxxxx'; $pass='xxxxxx'; $pgport=3306; $xml = simplexml_load_file('test.jrxml'); $PHPJasperXML = new PHPJasperXML(); $PHPJasperXML->xml_dismantle($xml); $PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); $PHPJasperXML->outpage('I');The first issue is that when I have a title, it creates an entire page for the title. The second issue is that when I run this report, an error was trapped at line number 3155:
so I replaced it with:
if ($this->arraygrouphead && is_array($this->arraygrouphead)){ foreach ($this->arraygrouphead as $out) { $this->display($out,$y,true); } }I attached the report and I can give you the address so you can see what it does: http://sdksandbox.com/_sandbox/mihai/jasper_test/report.phpThe title is set 30 in height in the iReport, but it creates this page... I am using iReport v5.5.1 and I just downloaded your library. So it is the latest as I write this issue.
Please let me know if I can help with anything to get this working...