booyeeka

Hi all! I have a problem trying to add Total Page variable on report. Variable $V{PAGE_NUMBER} defined as total number of pages in Library window, always returns current page. Where can be a problem with that? Am I using vrong variable? Thank you in advance!

Hi all! I can create nice report with jasperReports, and to preview it before printing. How can I suggest report file name and extension, when I want to save it from PrintPreviw layout? I wolud like to have a suggestion, and to set default type as pdf. Thank you in advance! Post edited by: booyeeka, at: 2006/10/29 10:45

Hi all! Can you help me how to use a value (ie. ID of selected record in subquery), in a main report? How to pass that data from subreport to main report? Thank you in advance!

Hey Sven! I did manage to solve our problem. You can check my post here: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=post

It looks like I did manage to solve my problem. In Jasper Report Query, I defined parameter as : $P!{EMPID} ... and it works good. I post this, because I noticed that a lot of JasperReports user have same problem. But BTW, JasperReports really rocks!

Hello Sven, I have the same problem.... Did you manage to find the solution for this? Thank you in advance!

Hi all! Can you help me how to send complete SQL query into JasperReports, from Java code. If in Java code I send (put) one parameter, like: Code: String empid = "3"; reportParam.put("EMPID", empid); ... this example works, by a simple call of next query in Jasper's XML file: Code:[code] select * from employees where Employee_ID = $P{EMPID} BUT, when I try to call query in java file like : Code:[code] String empid = "select * from employees where Employee_ID = 3"; reportParam.put("EMPID", empid); ... with $P{EMPID} only defined in jasper file, I get the following error: Code:[code] java.lang.NullPointerException Can you tell me where is my mistake? Thank you in advance!