nanndoj
-
Posts
8 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by nanndoj
-
-
Problem solved!
I don't need to test the parameter. I've put a coalesce in the report query
m.account.primaryKey.department.code = COALESCE($P{P_department} , m.account.primaryKey.department.code)
When the user mark the checkbox all the null value is sent to the database and the COALESCE make it bring all results!
Now my parameters is working fine! :)
-
To populate the combobox i'm adding properties in the parameter and reading through jasperDesign.getParameters() and getPropertiesMap() like the code below.
My main question I beleave is in the SQL WHERE
I wanna filter when the user select the department
m.account.primaryKey.department.code = $P{P_department}
or get all records if the $P{P_department} parameter is null (when the checkbox is checked)...
http://www.nanndoj.com.br/jasper/object_jasper.jpg
is there a way to test the parameter inside the report ?? or modify the query dinamically?
Code:
Post Edited by nanndoj at 07/06/2011 08:24
Post Edited by nanndoj at 07/06/2011 08:25
Post Edited by nanndoj at 07/06/2011 08:26
Post Edited by nanndoj at 07/06/2011 09:46 -
I'm doing it as a web application. But I have some problem as well :(
-
Hi,
I'm creating a generic screen to read the parameters and display to the user. It is working fine but the client asked me to create a way to list all records of some filter.
Below I put the image to explain better. I was thinking in make a HQL injection... but i don't know if it is the best solution
Has someone been faced this before? Is there a best solutions for this?
Thanks a lot!
http://www.nanndoj.com.br/jasper/jasper_example.jpg
Code:
Post Edited by nanndoj at 07/06/2011 07:29
Post Edited by nanndoj at 07/06/2011 09:46 -
Solved !!!. I did the downgrade to the 4.0.1 and it works perfectelly. It seems like a BUG in the Jasper Reports version 4.0.2
-
Hi all,
I'm new with Jasper reports and iReports and maybe (I'm sure) I'm doing anything wrong. My problem is that when i put a bold static text the last character is breaked down. It seems like the Jasper report is not reading the size described in the XML file.
I've attached the PDF Screen with the problem and the iReport design.
Someone has any idea?
Thank you :)
XML CODE:
Post Edited by nanndoj at 06/08/2011 06:36
Post Edited by nanndoj at 06/08/2011 06:36 -
I got the same Error. In my case when I put a Collection as DataSource it works...
DAO dao = DAO.getInstance(DAO.HIBERNATE);
List<Object> users = dao.find(User.class);
JRDataSource ds = new JRBeanCollectionDataSource(users);
...
// It works
JasperPrint print = JasperFillManager.fillReport(report, parameters, ds);
But if I remove the dataset and pass the Hibernate Session as parameter I got the error....
// java.lang.NoSuchFieldError: BOOLEAN JRHibernateQueryExecuter.<clinit>(JRHibernateQueryExecuter.java:70)
parameters.put("HIBERNATE_SESSION", dao.getSession());
JasperPrint print = JasperFillManager.fillReport(report, parameters);
Does someone know if I'm doing anything wrong? Can someone send the compiled version which works properly?
iReport 4.0.2 SVN location
in Products
Posted
Hi all,
I recompilated the JasperReports with the latest hibernate version to solve a problem with BOOLEAN types... That works great! but now my iReport (4.0.2) is working with a diferent hibernate version and the query generated by the iReport preview is not equals the query generated by the Jasper at runtime.
I've downloaded the latest trunk version of iReports to compile with the same hibernate jar but seems like the latest vesion avaliable in svn trunk is 3.0.0
I'm using this url http://jasperforge.org/svn/repos/ireport
is it right? Where can I download the 4.0.2 source?
Tks!