[textAlignment="Right" has no effect]

Thanks peter.w, please see my comment!

[textAlignment="Right" has no effect]

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?

[SQL queryString arithmetic operations and functions]

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?

[SQL queryString arithmetic operations and functions]

*

[SQL queryString arithmetic operations and functions]

Jaspersoft^® Studio

http://www.gravatar.com/avatar/699c906be679b559cf9f9d0a05378066.jpg?d=identicon&s=128&r=G

martin.clarke

4

Joined: Apr 20 2015 - 2:28am

Last seen: 12 sec ago

Thanks 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

 

[SQL queryString arithmetic operations and functions]

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 Expressions

Expression Editor: what it is and how it works

---

A 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

 

[Jaspersoft Studio connection to Linux MySQL Database]

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

[Jaspersoft Studio connection to Linux MySQL Database]

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.