Archive for the ‘JasperReports and iReport’ Category

My book on EJB 3 is now on sale

July 3rd, 2010 No comments

I received an email from the editor informing me that the book is now printed and will be available in bookstores next week (from July 5th, 2010).

It is already available for sale on Amazon and ENI.

An online version is also available.

Here is the cover of the book :


Review of the book iReport 3.7

May 9th, 2010 No comments

In this book made of 12 chapters, the author Shamsuddin Ahammad shows how to use iReport, the indispensable tool to conceive reports based on the JasperReports library, written with Java.
A MySQL database is created and its model is described in the appendix.

Read more…

Quick chat with Teodor Danciu, the founder of JasperReports

March 16th, 2010 No comments

Today I went to the Solutions Linux Open source conference and met the founder of JasperReports: Teodor Danciu. He is Romanian and speaks a very good French.

I had a quick chat with him. First, I thanked him for creating that great reporting library and then I asked him if the generated Excel files are compatible with Excel 2000, being a requirement of the customer on the project i am currently working on. The answer is: check the excel libraries that are used in JasperReports (POI and iText). They are compatible with Excel 2003 for sure.

I quickly discussed with him the support of iReport/JasperReports for EJB-QL queries. And MDX queries against an SQL Server 2008 Analysis Services. It seems a fix is available in the SVN repository and will be integrated in the next release (in 2 weeks) of JasperReports (3.7.x ?)

In the end, he gave me his business card to contact him if needed.

Categories: JasperReports and iReport Tags:

Generate a report from an SQL Server 2008 Anaysis Services OLAP cube with iReport and JasperReports

February 19th, 2010 No comments

Software versions that i used :

iReport 3.6.1
JasperReports 3.7.1
Microsoft SQL Server 2008 Analysis Services
Tomcat Web Server 6.0

I was recently tasked to generate a report through JasperReports/iReport
with data coming from an OLAP cube stored in SQL Server 2008 Analysis Services.

It was rather tricky because it seems there is no default Query Executer Factory that can handle MDX
through the XML/A protocol for SQL Server 2008 Analysis Services.

Read more…