Lazarus Long

Just upgraded to 3.7.1 and can't compile reports with scriptlets unless in include a very old iReport.jar is there a replacement for this?

Not sure about the web service route, but we are having great success by using the PHP-Java bridge. You can probably find some sample code for it out there.

You need to use the PHP-Java Bridge. You can use the standalone servlet or use Tomcat. I'm using it extensively for a PHP site and it works just fine. -LL

Yes, I am interested. I've been developing with Crystal Reports for many years but because of the pricing and licensing, I'd love to be able to switch some of my poor Windows-based clients over to Jasper and iReport. Please post some information! Thanks.

Thanks, removing the call to checkAvailablePrinters did the trick!

Your query can be ...sales_person.id in ($P{ID}) just make the ID parameter a string then pass a list of numbers separated by commas, like "1,2,3".

Lucian, Thank you! I found a copy of rt.jar in /library/java/extensions that was causing the problem. Now, however, I am getting a different error and so am still unable to print. Here is output from the Java console when I hit the print button: security: Automation: Accept printing security: Automation: Accept printing network: Connecting http://localhost:631/CanonMP530 with proxy=DIRECT security: Automation: Accept printing net.sf.jasperreports.engine.JRException: No printer available. at net.sf.jasperreports.engine.JasperPrintManager.printReport(JasperPrintManager.java:241) at net.sf.jasperreports.view.JRViewer$21.run(JRViewer.java:1198) at java.lang.Thread.run(Thread.java:613) Any ideas? I do have two printers set up, but neither is local. My CUPS log shows a bunch of entries like: localhost - - [21/Mar/2008:06:27:40 -0500] "POST / HTTP/1.1" 200 193 Get-Printer-Attributes successful-ok which indicates that the applet is successfully getting information about my printer. Thanks!

I posted this earlier but have not seen any response. Therefore I am assuming perhaps this is some sort of regression bug. Printing worked fine with 2.0.4, and works fine on Windows. However it is now broken on Mac OS X (I suspect it may be broken on other non-Win32 platforms, too...) Clicking on the print button on the Applet (jasperreports-2.0.5-applet.jar) when using Mac OS X causes the following exception. This did not happen in 2.0.4. It seems that the code is trying to access Win32 print information. Any ideas? Exception in thread "Thread-64" java.lang.UnsatisfiedLinkError: getDefaultPrinterName at sun.print.Win32PrintServiceLookup.getDefaultPrinterName(Native Method) at sun.print.Win32PrintServiceLookup.getDefaultPrintService(Win32PrintServiceLookup.java:198) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:61) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:157) at javax.print.PrintServiceLookup.getServices(PrintServiceLookup.java:359) at javax.print.PrintServiceLookup.lookupPrintServices(PrintServiceLookup.java:105) at java.awt.print.PrinterJob.lookupPrintServices(PrinterJob.java:80) at net.sf.jasperreports.engine.export.JRPrintServiceExporter.checkAvailablePrinters(JRPrintServiceExporter.java:356) at net.sf.jasperreports.engine.JasperPrintManager.checkAvailablePrinters(JasperPrintManager.java:409) at net.sf.jasperreports.engine.JasperPrintManager.printReport(JasperPrintManager.java:240) at net.sf.jasperreports.view.JRViewer$21.run(JRViewer.java:1198) at java.lang.Thread.run(Thread.java:613) Exception in thread "Thread-65" java.lang.UnsatisfiedLinkError: getDefaultPrinterName at sun.print.Win32PrintServiceLookup.getDefaultPrinterName(Native Method) at sun.print.Win32PrintServiceLookup.getDefaultPrintService(Win32PrintServiceLookup.java:198) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:61) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:157) at javax.print.PrintServiceLookup.getServices(PrintServiceLookup.java:359) at javax.print.PrintServiceLookup.lookupPrintServices(PrintServiceLookup.java:105) at java.awt.print.PrinterJob.lookupPrintServices(PrinterJob.java:80) at net.sf.jasperreports.engine.export.JRPrintServiceExporter.checkAvailablePrinters(JRPrintServiceExporter.java:356) at net.sf.jasperreports.engine.JasperPrintManager.checkAvailablePrinters(JasperPrintManager.java:409) at net.sf.jasperreports.engine.JasperPrintManager.printReport(JasperPrintManager.java:240) at net.sf.jasperreports.view.JRViewer$21.run(JRViewer.java:1198) at java.lang.Thread.run(Thread.java:613)

Clicking on the print button on the Applet (jasperreports-2.0.5-applet.jar) when using Mac OS X causes the following exception. This did not happen in 2.0.4. It seems that the code is trying to access Win32 print information. Any ideas? Exception in thread "Thread-64" java.lang.UnsatisfiedLinkError: getDefaultPrinterName at sun.print.Win32PrintServiceLookup.getDefaultPrinterName(Native Method) at sun.print.Win32PrintServiceLookup.getDefaultPrintService(Win32PrintServiceLookup.java:198) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:61) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:157) at javax.print.PrintServiceLookup.getServices(PrintServiceLookup.java:359) at javax.print.PrintServiceLookup.lookupPrintServices(PrintServiceLookup.java:105) at java.awt.print.PrinterJob.lookupPrintServices(PrinterJob.java:80) at net.sf.jasperreports.engine.export.JRPrintServiceExporter.checkAvailablePrinters(JRPrintServiceExporter.java:356) at net.sf.jasperreports.engine.JasperPrintManager.checkAvailablePrinters(JasperPrintManager.java:409) at net.sf.jasperreports.engine.JasperPrintManager.printReport(JasperPrintManager.java:240) at net.sf.jasperreports.view.JRViewer$21.run(JRViewer.java:1198) at java.lang.Thread.run(Thread.java:613) Exception in thread "Thread-65" java.lang.UnsatisfiedLinkError: getDefaultPrinterName at sun.print.Win32PrintServiceLookup.getDefaultPrinterName(Native Method) at sun.print.Win32PrintServiceLookup.getDefaultPrintService(Win32PrintServiceLookup.java:198) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:61) at sun.print.Win32PrintServiceLookup.getPrintServices(Win32PrintServiceLookup.java:157) at javax.print.PrintServiceLookup.getServices(PrintServiceLookup.java:359) at javax.print.PrintServiceLookup.lookupPrintServices(PrintServiceLookup.java:105) at java.awt.print.PrinterJob.lookupPrintServices(PrinterJob.java:80) at net.sf.jasperreports.engine.export.JRPrintServiceExporter.checkAvailablePrinters(JRPrintServiceExporter.java:356) at net.sf.jasperreports.engine.JasperPrintManager.checkAvailablePrinters(JasperPrintManager.java:409) at net.sf.jasperreports.engine.JasperPrintManager.printReport(JasperPrintManager.java:240) at net.sf.jasperreports.view.JRViewer$21.run(JRViewer.java:1198) at java.lang.Thread.run(Thread.java:613)