JasperStarter runs on every OS that has a Java 7 or 8 build. Note that I use MySQL under CentOS, but this should work for any SQL engine on any OS. No, I will not support Jasper or Java for you. Life is busy sometimes.Īll of this stuff is free, but if you’re not familiar with Java, XML, or Jasper Reports, you will benefit greatly from buying a JasperSoft support contract. I hope this is already helpful, and I expect it will become helpful…er. You would have dropped it in the wrong place, trust me. THAT is where you drop your JDBC connector for MySQL, PostgreSQL, Snoracle, MSSQL, etc. I’ll share that script in the tutorial, and explain how it eases management of scheduled/automatic reporting.īe aware that the JasperStarter install directory has a folder named jdbc. On CentOS 6, I installed a real Java VM, 1.8, instead of OpenJDK 1.5, and wrote a frontend bash script to manage report parameter parsing. Use Access for a database while you’re at it. The project site claims that it works there however, so feel free to shoot yourself in the foot. I haven’t tried it on Windows because that’s … amateur. I’ll try to put together a tutorial on a complete reporting system when things slow down here, but many of you will be able to use this project right away. When the report is done, that php outputs a download link, or emails the report, or displays it to the screen, depending on the constraints provided by the user. It supports every feature of the free iReports / JasperStudio report design tools, provides output in any format that you might want, and doesn’t beat your server to death every time a report is run.įrom ScriptCase, I build a JasperStarter command line in a variable after prompting the user for constraints, make that variable global, then I redirect to a tiny bit of PHP that executes the command line built from ScriptCase. JasperStarter/ is built around the latest (5.6.0 as of this post) Jasper Server reporting engine. PHPJasperXML is very limited, and it’s extremely easy to break a report with no way to debug the problem. I tried dozens of methods before stumbling across the jasperstarter project on SourceForge. After reading the forum post about PHPJasperXML, I did some serious research into the many ways that reports can be managed from ScriptCase.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |