Hi iReport "Definitive guide" Users, I'm lucky to be familiar with Java and Reporting, so I could solve the problems of that Guide! My comment is based on the "Definitive guide to iReport" from August 2007 and iReport 2.0. My steps: ========= A) First I downloaded the samples from the Apress homepage as documented within the tutorial. Works fine! B.) Then I downloaded the HSQLDB from sourceforge (version 1.7). Works fine! C) Then I wondered that the praised Northwind database is not part of the download from Apress. My opinion is, that Apress should put the Northwind scripts to the download, what else make sense?? :-( D) Then I browse the iReport directories regarding that Northwind, NOTHING! E) Then I browse as recommended in an other thread my jasperreports-1.3.4 download folders and found a DB script in the directory demo/hsql folder. Nice, but that database has no CUSTOMER table as used in many examples! My conclusion: that database has nothing to do with the well known Northwind DB. F) Then I searched the Internet regarding suitable scripts. I found two projects hosted on sourcforge. One has the name Butler http://sourceforge.net/project/showfiles.php?group_id=94553&package_id=100556 Instruction: Download that project, go to the directory /demo/northwind/sql and take that scripts compatible with HSQLDB 1.7., it works fine! G) The first example in chapter 1 uses a SQL command "Select * from CUSTOMERS". DON'T use that, the wizard will always popup an error message: Code:SQL problems: Table not found: CUSTOMER in statement [select * from CUSTOMER] {2} Instaed use: Code:[code]SELECT DISTINCT * FROM "Customers" Customers Works fine in my iReport 2.0 HSQLDB 1.7 environment. I solve that problems when I used the SQL wizard in the screen I write the SQL command. The SQL wizard always generated a command that works, so if you have any problems use that! Good Luck! Post edited by: jackkilian, at: 2007/09/26 08:59 Post edited by: jackkilian, at: 2007/09/26 09:10