george_17

thanks very much!!

hi all i was reading that to install a report rom studio onto the server open report from explorer then select the icon publish the file on jasperreports server this opens the dialog box containing a list .... well actually mine doesnt... its completely empty.... i think i have started the server ... noticed start and stop somewhere ... why doesnt studio see it?? georgr

hmm... to set it up on my hosted acciount i need a VPS ... far too expensive so cheaper to have a dedicated pc at the client site just for his reports think i will use your first suggestion setup access for him to select the reports off the jaspersoft server george

An excellent reply, thank you very much for the options. the simplest for me will be the best since hopefully i will ned less research to understand how to build the solution... now all i currently need to find out is how to setup a jasperserver on my host - a linux server how the REST API work how to set it all up in an iframe i will go look on youtube thanks very much george

thanks for the suggestions... still get the same, tried changing the field i am comparing with a converted text to date but still the same... is there any log gnerated anywhere to try to pinpoint what exactly its failingon the full sql is here SELECT themeats_01.oc_order.order_id, themeats_01.oc_order.invoice_no, themeats_01.oc_order.invoice_prefix, themeats_01.oc_order.store_id, themeats_01.oc_order.store_name, themeats_01.oc_order.store_url, themeats_01.oc_order.customer_id, themeats_01.oc_order.date_added, themeats_01.oc_order.comment FROM themeats_01.oc_order where (STR_TO_DATE(themeats_01.oc_order.comment, '%d/%m/%y') = cast($P(Message) as date)

can anyone describe a way i can publish a report i create in jasperreports studio onto a web page that i host for a customer to run any help or pointers would be very welcome regards george

hi all made some huge strides in finding promted parameters.... so using a jasperrreport i alread have i created a parameter, renamed it Message set it to java.date checking requires prompting and added it to my report layout then i modified the sql by adding to the sql where themeats.oc_order.date_added = $P(Message) tried a preview and got an error generating report,,, anyone see what is wrong please thanks george

see my new post re prompted parameters

brilliant thanks mate ... best one i liked really really good was watching this i realized that was missing the two panels on the left ... window > reset perspective ... voila all good thanks

hi all seems so simple but i read the docs and cannot understand what it means... the docs say select the node of the report in the outline view.... cannot see a nod or anything referring to itself as a node all i see is a blank outline with a pallette on right containing other sections... anyway ... trying to read the docs to see how it adds fields i manage to find a control over the outline report view which opens the datasource table on left panel and field in right within a sql select... i see in docs it refers to clicking read so i do that... in the bottom panel i can see fields i selected in the datasource and actions on right to add remove etc... so i add a field, click ok expecting the field to be added to the report... but the report outline is blank Please can anyone help me fgure out how to get these field into the body of my report many thanks george

Hi all I have had some excellent advice here and really appreciate sharing the knowledge. I now need to understand how to write a report like select * from table x where date = a date entered by the user can anyone tell me how to do this please?? many thanks george

BRILLIANT ... THANK YOU SO MUCH!!!!

Hi all I have installed the community Jaspersoft Studio as a poster suggested. I have a mysql database hosted on my linux server. I have checked and validated all the remote connections and locally on the server using phpmyadmin for the dataadapter i am using JDBC Driver org.gjt.mm.mysql.Driver and Jdbc url jdbc:mysql://91.208.99.2:1187/themeats_01 I use the validated correct user/password i test and it fails ... with the message... Reason java.lang.ClassNotFoundException org.git.mm.mysql.Driver cannot be found net.sf.jasperreports 6.4.0.finalorg.gjt.mm.mysql.Driver PLEASE ... can anyone tell me how to fix this... thanks george

thanks that is REALLY useful... Im trying to create a datasource to a mysql database so used jdbc:mysql://91.208.99.2:1187/themeats_01 and added user password ... all checked as ok and working i get a test connection error net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver cannot be found by net.sf.jasperreports_6.4.0.final 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:122) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:156) at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver cannot be found by net.sf.jasperreports_6.4.0.final at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:461) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:372) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:364) at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:161) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:174) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:145) ... 5 more anyone explain how to fix this>

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 thanks george

i have stepped through the process again from the start and ensured that i selected 5 fields from the table... i tried crosstab table and chart and the save button is grayed out... i raised a query with support and the explanation is that you can only create adhoc query if you have paid to use the product... see the explanation: It was great talking with you yesterday. I checked with one of our experts and the reason why the 'Save' button is grayed out is that that feature is indeed part of the Professional, Enterprise, or Reporting commercial editions of Jaspersoft, not included in the Community version. More information on what capabilities are available on each edition can be found here: https://www.jaspersoft.com/editions If you are interested in finding more about those, let us know and we'd be happy to assist you. Kind regards, Ivan Obarski | Business Development Executive UK & Nordics so Im going to start a new topic asking for suggestions of hoto use the community product to create reports... because i have no budget for this....

thanks for the suggestion... i tried this in chrome but cannot do a hard reload rightclick does nothing and a refresh does nothing

Hi all I posted this a while ago but still cannot figure out what to do.. PLEASE someone help me I am new to all this but reasonably technical capable I have created a new datasource, tested connection ok created a new domain using one table and a couple of fields I am trying to create a new adhoc view and can select the datasource and layout the two fields selected the ubderlying data is displayed... BUT.. the save button is grayed out... why?? (thats the second button in the row)

once again thank you... i now have a domain... i tried to create an adhoc view... selected the domain and the table in there... selected just one field and dragged into row... added a title... but the save button is grayed out... why?? one other question please ... i am assuming that once ive got this saved i can create a dashboard and add it to the dashboard for the production team to run... can i actually just create a user who will have access to this dashboard?? thanks george

Greatly appreciate your comments and feedback.... i have created a datasource and connected ok to it and saved it... however i have tried to create a domain ... which as far as i can see is definingtables needed and joins... but the save button seems disabled... what am i missing?

Hi all... I am new to jaspersoft... but i am technically okish ... i think... well i should be.. i am hoping the products here are crystalreports like but without the pricetag because we havent much money just yet... i just downloaded to evaluate studio 8.4.0 professional... not sure if i really needed the community version.. anyway i cannot grasp what i need to do so i will explain what i am trying to do and hopefully someone will be able to help me with some simple config steps... i have an opencart system setup on my hosting provider... on a linux server using mysql database... i can access and run phpmyadmin on the hosting company servers to view structures run sql etc etc i am accessing all this from my pcs which are microsoft surface pcs running windows 10 i am hoping the jasper products allow me to access the mysql darabase and design reports and save the reports to be run by my operational staff can anyone talk me through the product i need and steps to configure and set this up i would be extremely grateful.. also... what is the pricing once my evaluation has finished thanks george i