Hi,

I have seen a posting earlier in the site regarding Using Jasper Reports with Hibernate..and here is the wat the suggestion about how to create the reports using jasper and hibernate and convert it into pdf or any other formats.

List cats = session.find("from eg.Cat");

Map parameters = new HashMap();
parameters.put("Title", "The Cat Report");

InputStream reportStream = this.class.getResourceAsStream("/the-cat-report.xml");
JasperDesign jasperDesign = JasperManager.loadXmlDesign(reportStream);
JasperReport jasperReport = JasperManager.compileReport(jasperDesign);

JRBeanCollectionDataSource ds = new JRBeanCollectionDataSource(cats);
JasperPrint jasperPrint = JasperManager.fillReport(jasperReport, parameters, ds);

JasperManager.printReportToPdfFile(jasperPrint, "the-cat-report.pdf");

Now My doubt is HOW do i know wat kind of format is allowed in the the-cat-report.xml file mentioned in the code.

To be precise wat is the content in the xml file Is it a plain xml file or it has any mandatory tags in it.

Thanks in Advance,
Austin :-)

Link for the above mentioned posting is given below:

http://www.hibernate.org/79.html

This is a Jasper question rather than a Hibernate one but...

I have used Jasper reports extensivlely and it is straight forward to get it up and running. The lastest version has even better integration (which I am not using since I dont want to change 300 reports).

In anycase, the XML document (normally .jrxml extension) you refer to is the
defintion of the report. I suggest you use ireport to visually design the report and it will create you report definition for you.

See Jasper examples and ireport for further information.

Hi David,

thank u for ur reply. At the same time i would also like to tel u that. I domt have any problem using the xml file whcih is used to create the design template. I would be using it any how.

Let me be more clear on wat i would like to say, If u see the examples or samples which are under the samples folder of JSR/demo/samples/noxmldesign/ this particular struture has been given for those who does nt want to use the designing tool or to be precise the .jrxml file.

I am ok with creating my own structure. But the problem i am facing is In the program u have to pass the query to fill the report.But i already have the data in the form of objects using Hibernate. Now if at all i pass on the query again..Does it mean that i am doing a repeatition of the code by executing the query twice.

Let me show us with example.

This part of the code is in jsr/demo/samples/noxmlDesign/noxmlDesignApp.java

//Query
JRDesignQuery query = new JRDesignQuery();
query.setText("SELECT * FROM Address $P!{OrderByClause}");
jasperDesign.setQuery(query);


Here is the click I dont want to send a query string again coz i have already got the queries data..i mean the result.

I hope u got my point.

Looking ahead for ur reply,

Austin

I have not created reports without the jrxml defintion. I did not know you could do it. In anycase, the are multiple data sources that can be used. I use the POJO data source rather than pass the query or embed the query in the reports. eg;


This is the way I apporach it for my use cases.

JasperReports 1.2 now supports Hibernate directly. You can put a HQL query within the JRXML.

Sherman Wood
JasperSoft

I was aware of the new enhancement but he wanted to know how to use POJOs. In anycase, thanks for dropping in. Good to see you monitor this forum.
Cheers.

First of all Thanks to one and every one for ur help.

Is there any possiblity to check what is exactly happening or written inside the .jasper or .jrprint file once we pass on the parameters..like fill.

and comming back the original query i was still not able to figure out how it cud be done...with out repassing the query.

I go the data thru hibernate...now how shud i pass on the same data without requerying it or trying to rerteive the info from database.

//Query
JRDesignQuery query = new JRDesignQuery();
query.setText("SELECT * FROM Address $P!{OrderByClause}");
jasperDesign.setQuery(query);

I belive i am doing a repetetive work on this...Is there any possibility to skip this process...

Austin

I don't use queries inside the report - my design choice. I would suggest you look at the latest version of Jasper and look at the example Hibernate sample suuplied. It uses HQL queries in the report.

You really need to take these questions to the JasperReports forum http://sourceforge.net/forum/forum.php?forum_id=113530.

Setting the query like that will requery the data. David's mention of JRBeanCollectionDataSource points to the right way. Have a look at:




You can cache the dataSource, change the JasperReport and call the above method to get the result.


Sherman Wood
JasperSoft

List cats = session.find("from eg.Cat");

Map parameters = new HashMap();
parameters.put("Title", "The Cat Report");

InputStream reportStream = this.class.getResourceAsStream("/the-cat-report.xml");
JasperDesign jasperDesign = JasperManager.loadXmlDesign(reportStream);
JasperReport jasperReport = JasperManager.compileReport(jasperDesign);

JRBeanCollectionDataSource ds = new JRBeanCollectionDataSource(cats);
JasperPrint jasperPrint = JasperManager.fillReport(jasperReport, parameters, ds);

JasperManager.printReportToPdfFile(jasperPrint, "the-cat-report.pdf");



// In this example JRBeanCollectionDataSource is used as a parameter instead of a resultset in SQL Query
in my case i did in JDBCODBC connection in ireports to create jrxml and the same query generated in ireports is passed in Hibrnate

Query q = HibHelper.getSession().createQuery(sql);

and passed this list to JRBeanCollectionDataSource

Will it works??????
and i always get a message that a particular column like login_name dosent exist

No..actually it didnt work,always get exceptions

Can anyone help me to create jrxml in ireport using hibernate

Its an interesting and useful thread of hibernate users. I think this forum contains plenty of nice information about hibernate. Thanks for sharing it with me.

Hey Manjush, I am also looking for some help for create jrxml in ireport. I hope you got some way for making jrxml in this time. Pleas share some instruction.

It may not working now~
you should ask for someone professional