rida_10

Hi, as i attempt to run (preview) a report by clicking on preview nothing happens! And the output window doesn't show any error although the query fetch data from database any help thanks Rida

Good Morning mgeise, first thanks for the step by step example of the table component feature, but as i am running the report from the preview button in ireport, nothing happens! maybe bec. the main report's query is select 1 as dummy_field, although i have set the report's property that when no do print all sections

Hi, i realize that we can't manipulate data such as sorting or filtering of the generated excel document how to overcome this point thank you

Hi the sqljdbc driver is missing it must be in the lib directory of tomcat that is running the jasperserver web application

Thanks tkvanagh, i located the jar file in the exported folder, where the jar file is the same, but this time is .data, I renamed the extension from .data to .jar, then i extracted it, using winrar, and get the .class files in my jar file

Hi, if I am using a report that is using a jar file, we can add that jar file to jasper server ,so that we use it , and can be added so it is found in the repository so that if another report need that jar file we can refer to it. my question is that , is there a way in jasper server 4, so that we can get that jar file, (that we have added previoiusly) so that i can know what classes are in that jar file. thank you

Hi Nitin your proposed way resulted in an exception: Error loading object from URL : repo:/Reports/Services/IPT/Sub_TotalSummary.jasper as i run the report, pioppogatto's way worked, Best regards

thanks piopogatto , it Worked!

thanks piopogatto, but did u add the sub report first to jasper server as a report unit by it self ??? nice day

HI ALL,,, ihave been working on ireport designer 3.0, to develop sub reports and i used the $R{subreports.folder} resource bundle to refer to the location for my sub report as such: $R{subreports.folder} + java.io.File.separator + "Sub_TotalSummary.jasper" where subreports.folder property refers to a location on the hard disk : subreports.folder=D:/my-reports/build/3.0.0 (all .jasper reports are generated in this directory) so where ever we want to run the report we only change the value of subreports.folder THE QUESTION IS HOW TO REFER TO SUB REPORTS WHEN REPORTS ARE RUN FROM JASPER SERVER NOT FROM AN ORDINARY JAVA APPLICATION. THANK YOU RIDA

Hi Kristine, One of the many attempts that we have tried is to restart mysql, we were running jasperserver (linux distributtion) so first we run a script named mysqld_start but it didn't work,,,, but there where a script in opt/jasperreports/exports/scripts/ctl.sh.start when we run it , the jasper server run as usual !!! note that i haven't tried to alter with any of the tables of jasperserver in mysql thank you Rida

Hello All, we have some strange case, we were running jasper reports server, and electricity power went off , so the service went down, when i restarted the server and the jasperserver application couldnt started and i got this exception Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketIm Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in file [/usr/opt/jasperreports/buildomatic/conf_source/ieCe/applicationContext-report-schedule i will attache the complete log file. i thought that its problem with mysql , so i installed jasperreports server on other machine bundled with mysql, and i (killed ) the mysql running process to simulate the problem that occurred , and i found same exception occurred , as the mysql process crashed anyyyyyyy helpppppppppppppp and how can i export reports that exist on that server, i will attach the log file

Hello all, as i export a folder of reports to other computer having jasper server and attempt to run any report of this server, i get the following exception: com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.xml.sax.SAXParseException: Content is not allowed in trailing section.is this exception related to user permission?

Thanks Khahn, very nice feature in jasper server, in the attached example do we have 2 resource bundle files each for different locale, that is one properties file for english locale and other for french OR all key-value properties for ALL locales are defined in one resource bundle(properties file)????? Post Edited by rida_10 at 06/06/2011 06:44 Post Edited by rida_10 at 06/06/2011 06:48

Hi all , i deployed a jrxml report that uses a jar file (joda-time-1.1.jar) to jasperreprts server on linux platform. after attempting to run the report i got a class not found exception complaining that the joda time class is not found although i have put the joda-time-1.1.jar file in the lib folder of the web aplication jasperreports server and i restarted the tomcat of jasper-server but still same exception althrough on windows it works Post Edited by rida_10 at 06/01/2011 11:32

can a query input control parameter make reference to resource bundle using the notation $R{certain_property} like we can in ireport. I need these because, i need to define as a resource bundle a property named countryId whose value is constant bec i don't want to use cascading parameters here, bec if i want to install the jasperserver in italy i want to see always the combo list of italian cities, and by that i get rid of extra un necessary parameter (the country) bec. its known always for that user in italy that all his data are for italian cities so i imagine that the parameter goes like this: select cityID, cityName from city_table where city_table.countryID = $R{COUNTRY_ID} where COUNTRY_ID is defined in a properties file. Post Edited by rida_10 at 05/31/2011 06:28

okay thanks !

Good Morning, One simple question, is there a way to change the priority of parameters after defining a report ? so, if for example there where a report that has 6 parameters and we want the 6th parameter to be the first input control as we are running the report , then i should remove 5 parameters, then re define them again where the 6th parameter is now first in the prompt page when running the reportBest Regards........

okay thanks Kristine, it worked......

I tried all combinations: - js-export.bat --uris "\/Content files" --output-dir=c:\jasper_bckup3 - js-export.bat --uris \"\/Content files\" --output-dir=c:\jasper_bckup3 but it is not working !, i am using windows xp , did you tried it ur self?? I make a trivial work around by creating a folder whose name doesn't contains a space(input_parameters) and copy the content of a folder named: "input parameters" to it. Best Regards

Okay !!, now i know the plain meaning of $X{...} expression, thanks kirstine

thank you very much kahn for the help in export/import

thanks kahn for ur reply, and i downloaded the jasperreports adminstratation guid, and the export was done as expected but i faced one simple problem is that what if the resource that i want to export contains a space like content files , and i tried the following: js-export.bat --uris "/Content files" --output-dir=c:\jasper_bckup. and i received URI /Content files was not found in the repository

okay it worked with me export command as follows: js-export --everything --output-dir=c:\jasper_bckup where the folder c:\jasper_bckup is the export target . Now, what is the import command so that i import resources on an Already installed jasper reports server.

I referred to the jasper reports server chapter : configuring the import-export utilities but ididn't found an example so have any one tried exporting reports, resources from one installation instance to another