Jaspersoft® Studiohttp://www.gravatar.com/avatar/699c906be679b559cf9f9d0a05378066.jpg?d=identicon&s=128&r=Gmartin.clarke4Joined: Apr 20 2015 - 2:28amLast seen: 12 sec agoThanks butlerc. I added the field in the first place and it failed: Unknown column name timeworked in result set ... soooooo, I wondered intuitively if an alias was required. I've never seen that before with any SQL (Oracle, SQLServer, MySQL) in 20 years, but you never know! It was : ) select w.ID, w.AUTHOR, w.STARTDATE, round(w.timeworked/3600,2) timeworked, i.summary from db.worklog w, db.issue i where AUTHOR = "<whoever>" and w.issueid = i.id group by w.STARTDATE[/code]As Java is the default I'll stay with that, but I'll look around as one does. Is there ANY decent documentation anywhere? That's rhetorical. There's no book on Jaspersoft Studio and every book of iReports and JasperReports is very badly rated on Amazon. Thanks again butlerc, you were a vital part of the solution! Regards Martin