Advice needed for very simple reports


Hi all,

Firstly, my requirement is really simple, my budget is zero sadly and I know very little about Jaspersoft or Jasperreports and the funcyionality looks immense.

I have built an OpnCart shop for a client which uses a mysql database hosted on a linux server.

I need to create 6-10 very simple reports for the client to run each day.

they will use a query but mainly be two table joins maybe three: I can write the sql and check it in phpadmin....

but i need the client to run these reports...

Ive been told by a support guy from Tibco that i cannot create adhoc stuff in JasperServer unless i signup to a license....

so my question is... can i use anything in the jaspercommunity stuff to design write and test the reports and how do i deploy to a customer over a browser?

many many thanks to anyone who can point me in the right direction





george_17's picture
Joined: Jul 21 2017 - 9:36am
Last seen: 6 months 3 weeks ago

2 Answers:


You can create reports using a community version of the Jaspersoft Studio and publish them to a community version of the server.  The report interface is more complex (and more powerful) and less intuitive, and there are a few things that aren't supported, but it is possible.  

For more information, see the Studio manual

For information about connecting to the server & publishing, see this chapter


elizam's picture
Joined: Mar 5 2012 - 9:19am
Last seen: 1 day 1 hour ago

thanks that is REALLY useful...


Im trying to create a datasource to a mysql database so used


and added user password ... all checked as ok and working


i get a test connection error


net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: cannot be found by
Caused by: java.lang.ClassNotFoundException: cannot be found by
 at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(
 at org.eclipse.osgi.internal.loader.BundleLoader.findClass(
 at org.eclipse.osgi.internal.loader.BundleLoader.findClass(
 at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(
 at java.lang.ClassLoader.loadClass(
 at java.lang.Class.forName0(Native Method)
 at java.lang.Class.forName(
 at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(
 ... 5 more


anyone explain how to fix this>

george_17's picture
Joined: Jul 21 2017 - 9:36am
Last seen: 6 months 3 weeks ago