I am amazed that no one is answering this specific question. So I try it myself: create a jasperreports.properties file in the root path of the project: # loads/override properties from default.jasperreports.propertiesnet.sf.jasperreports.default.pdf.font.name=net/sf/jasperreports/fonts/dejavu/DejaVuSans.ttfnet.sf.jasperreports.default.pdf.embedded=true[/code] or change the default font by adding this Method and call it before export to PDF/A: public void setDefaultPdfFontEmbedded() { JasperReportsContext jasperReportsContext = DefaultJasperReportsContext.getInstance(); jasperReportsContext.setProperty("net.sf.jasperreports.default.pdf.font.name", "net/sf/jasperreports/fonts/dejavu/DejaVuSans.ttf"); jasperReportsContext.setProperty("net.sf.jasperreports.default.pdf.embedded", "true");}[/code]Please correct me if this is not true!
Thank you hozawa, change from SELECT DISTINCT "DB_DEVELOPER"."T_123456789"."VAL_FFIELD"FROM "DB_DEVELOPER"."T_123456789"[/code]to SELECT DISTINCT VAL_FFIELDFROM "$P!{DB}"."$P!{TABLE}"[/code]The SQL statement now is dynamic. http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/thumbs_up.gif