java - ireport plug-in for netbeans doesn't export PDF or XLS? -
i using netbeans7.3. ireports4.7.1 plug-in
my program connects database , retrieves 1 record should shown in report generated.
and here code generate it:
try { connection con= drivermanager.getconnection(host, uname, pword); file f1 = new file("report1spring.jrxml"); string path = f1.getabsolutepath(); jasperdesign jd = jrxmlloader.load(path); string sql = "select arabic , english, nit, cnumber, (select mail emails id ="+ vars.pronum +") email allinfo inner join allaccounts on allinfo.id=allaccounts.id allinfo.id ="+vars.pronum; jrdesignquery newquery = new jrdesignquery(); newquery.settext(sql); jd.setquery(newquery); jasperreport jasrep = jaspercompilemanager.compilereport(jd); jasperprint jasprint = jasperfillmanager.fillreport(jasrep, null , con); jasperviewer.viewreport(jasprint,false); } catch (sqlexception | jrexception e) { joptionpane.showmessagedialog(null,e); }
the problem here that:
i clean , build project,
then execute jar file generated, putting jasper andjrxml file in same dist directory.
then when press "generate report" button, report gets generated perfectly,
the thing when need save pdf,rtf, xls(single sheet or multiple sheets) gives problem. other extensions goes fine. "save pdf" option generates pdf file of size 0, , when try open it, gives me error:"could not open because it's either damaged or not supported file type", , "save xls", doesn't generate files @ all.
and "save csv" generates files when open it, shows symbolic characters doesn't have meanings.
i can't find problem, , appreciated.
thanks
Comments
Post a Comment