johno_1

I can create a font extension with pdf embed and use it in JasperSoft Studio 7.5. to export to PDF without any problems. My issue is when I export the font extension as a jar and then delete the font extension from properties and reload it as an external jar. When I then try to export to PDF, I get the error: net.sf.jasperreports.engine.JRRuntimeException: Could not load the following font: pdfFontName: fonts/ArialJR/arial.ttf pdfEncoding: Cp1252 isPdfEmbedded : true at net.sf.jasperreports.engine.export.JRPdfExporter.getFont(JRPdfExporter.java:2585) at net.sf.jasperreports.engine.export.JRPdfExporter.getChunk(JRPdfExporter.java:2368) at net.sf.jasperreports.engine.export.JRPdfExporter.getPhrase(JRPdfExporter.java:2337) at net.sf.jasperreports.engine.export.SimplePdfTextRenderer.getPhrase(SimplePdfTextRenderer.java:64) at net.sf.jasperreports.engine.export.SimplePdfTextRenderer.render(SimplePdfTextRenderer.java:73) at net.sf.jasperreports.engine.export.JRPdfExporter.exportText(JRPdfExporter.java:2698) at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:1104) at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:1063) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:927) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:547) at com.jaspersoft.studio.editor.preview.actions.export.AExportAction.exportWithProgress(AExportAction.java:223) at com.jaspersoft.studio.editor.preview.actions.export.AExportAction.doExport(AExportAction.java:308) at com.jaspersoft.studio.editor.preview.actions.export.AExportAction$2.run(AExportAction.java:161) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Any thoughts on what might be going on?

Using Jaspersoft Studio Pro 7.5.0 Using Jasper Server Pro 7.5.1 Created parameter $P{DATE_RANGE} for use in dynamic sql statement IF( $P{SPECIFY_TIME}.equals( "Y" ), "AND (dss.STAGED_TIMESTAMP>=TRUNC(TO_DATE('"+ $P{CUSTOM_DATE_FROM_OPT} +"','YYYY-MM-DD')) AND dss.STAGED_TIMESTAMP<TRUNC(TO_DATE('" +$P{CUSTOM_DATE_TO_OPT} + "','YYYY-MM-DD')))", "" ) $P{CUSTOM_DATE_FROM / TO_OPT} is type java.sql.Date DATE_RANGE is inserted in the SQL statement WHERE clause as --> WHERE ... $P!{DATE_RANGE} ... The above works as expected in JasperSoft Studio, but when uploaded and run on Jasper Server, it produces error: Error evaluating expression for source text: IF( $P{SPECIFY_TIME}.equals( "Y" ), "AND (dss.STAGED_TIMESTAMP>=TRUNC(TO_DATE('"+ $P{CUSTOM_DATE_FROM_OPT}+"','YYYY-MM-DD')) AND dss.STAGED_TIMESTAMP<TRUNC(TO_DATE('" +$P{CUSTOM_DATE_TO_OPT} + "','YYYY-MM-DD')))", "" ) net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: IF( $P{SPECIFY_TIME}.equals( "Y" ), "AND (dss.STAGED_TIMESTAMP>=TRUNC(TO_DATE('"+ $P{CUSTOM_DATE_FROM_OPT}+"','YYYY-MM-DD')) AND dss.STAGED_TIMESTAMP<TRUNC(TO_DATE('" +$P{CUSTOM_DATE_TO_OPT} + "','YYYY-MM-DD')))", "" ) at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:284) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:316) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:673) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:641) at ... I've been able to run these types of dynamic sql with dates on community versions of Jasper server with no problem in the past. Any thoughts to what might be going on?