martin.clarke

Thanks peter.w, please see my comment!

The Jasper documentation is unbelievable. How does one align output? Everything aligns left. I've changed <textElement> to <textElement textAlignment="Right"> to no effect. Any ideas?

The Jasper documentation is unbelievable. How does one align output? Everything aligns left. I've changed <textElement> to <textElement textAlignment="Right"> to no effect. Any ideas?

*

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

OK guys. I'm lost. Can anyone point me in the direction of how to perform arithmetic operations and functions on java.math.BigDecimal fields please? Well half an hour later I found Jaspersoft Studio Documentation > Tutorials > Variables and ExpressionsExpression Editor: what it is and how it worksA user that is editing an expression for a report, with language set to Groovy or Java, can see this interface: ... My language according to the Dataset and Query Dialog is SQL. Java isn't an option. My query is SELECT w.ID, w.AUTHOR, w.STARTDATE, w.timeworked, i.summary from db.worklog w, db.issue i where AUTHOR = "<whoever>" and w.issueid = i.id Group BY w.STARTDATE and returns 'timeworked' in seconds. I merely want to do what I can do in MySQL: 'round(w.timeworked/3600,2)' which returns hours to 2 decimal points. Kind regards Martin

Thanks hozawa. I have eighteen thousand jar files. Nearly two thousand connector files. Exactly what file am I looking for please? Well, an hour later I've downloaded MySQL Connector/J and will work through Data Sources in the documentation. None of the Paste options work above, I suppose that's because I'm on an 'old' IE. Ah HA! Yes. Firefox & Chrome work: Jasper . File Data Adapter Name: MySQL JDBC Driver com.mysql.jdbc.Driver JDBC URL jdbc:mysql://localhost/database > jdbc:mysql://dal/jiradb martinc / DeltaEcho Test net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:173) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:157) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:174) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:145) ... 4 more Later: I'm feeling more and more foolish hozawa, the answers are all here I suspect: http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/creating-and-using-database-jdbc-connections

Hi, I'd run iReports, but no version works on my client with JDK8. I'm trying to connect to a Linux MySQL database that I have no trouble connecting to with MySQL Workbench on the same client. I can't post the error stack here, none of the Paste options work. For my report data adapter: JDBC Driver com.mysql.jdbc.driver JDBC URL jdbc:mysql://<hostname>/<dbname> valid uname/pw Test errors with ClassNotFOundException for the driver. Do I have to download this AS WELL AS Jaspersoft Studio? Set a path? What? Where? Please.