[jasperreports-questions] dynamic xls report
Hi! I need to make an excel report with dynamic fields and I don't know how. I need to generate a table, but I can't do a design before because the number and name of the colums are variable.Is there a method to do this with Jasper Reports?
[jasperreports-questions] PDF Font Loading
Hi, I am new to Jasper Reports. I am trying to generate a PDF reports that conatins mixture of English,Chinese and Korean Characters. In PDF i saw only English characters. So i changed in JRXML file like this pdfFont anf PdfEncoding but while running report i am getting this following error [java] NESTED BY : [java] net.sf.jasperreports.engine.JRException: Could not load the following font : [java] pdfFontName : Helvetica [java] pdfEncoding : UniGB-UCS2-H [java] isPdfEmbedded : true [java] at net.sf.jasperreports.engine.export.JRPdfExporter.getChunk (JRPdfExporter.java:1 476) [java] at net.sf.jasperreports.engine.export.JRPdfExporter.getPhrase (JRPdfExporter.java: 1428) [java] at net.sf.jasperreports.engine.export.JRPdfExporter.exportText (JRPdfExporter.java :1678) [java] at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage (JRPdfExporter.java :496) [java] at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExp orter.java:436) [java] at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport (JRPdfExporter.ja va:282) How can i resolve this one Please help me, Thanks Suresh --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Subdataset usage
Hi all, I need to create a report wherein I have to use multiple subreports which would actually make the report slower. Instead I am thinking to use subdatasets. My report fetches tthe country names on some criteria. Depending on the country names I have to get project details etc & then depending on tghe project details I have to fetch the tool details. Then I have to total the tool cost for each subproject & project. Would anybody please tell me if using subdataset would help me make suach a report. If I make the main query & then make a subdataset & then another subdataset. WOuld the first subdataset be able to pass values to the second subdataset? Please reply asap, Thanks & Regards, Meenakshi. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Dynamic query, parameters question
How can I pass a parameter to the query of the type SELECT COUNT(*),model FROM elevators WHERE society=1 GROUP BY model ORDER BY model DESC I'd like to pass in the order_by (here count) to be also a model, should it be of type java.lang.String? Should the default value be quoted ""? Also how do I specify the society parameter (here I've put it to 1), how can I make it obligatory, and to my java code I'm using java.lang.Long, postgresql characterizes it as int8, what should I choose as data type and how do I set the default value to it as it's not value type but reference type? Srgjan Srepfler --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions