fgar

Hi all , i have tried to update to new version of jasperreport my test server , i have put jasperreports-3.1.4 on mu install DIr /opt/jasperserver/apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib. and after i have restart the server ... . but with no success ... the server goes up ok, but when i execute a report .. i have some error.. There is some how to for upgrade the server to new package library ? thx

thx for the tips ..it's ok it work!

Hi all, i have report that is composed by one master it contain one subreport. In some situation expecially when the subreport (that execute one simple query) return no row i dont' see anything about the subreport.. my objective is to display something such "no data available"... so i have think to use the subreport expression usinh the return value REPORT_COUNT assign to a variable , and based on the return value do something like this.. $V(myreturnvalue)=0 ? "repo:showreportnodata.jrxml" : "repo:shownormalreport.jrxml"... this is my idea... Trying different expression i have see that when i have no data my variable is not 0 but is null... So i have change the expression but with no success... There is someone that know some kind of solution or tips to obtain that

Hi Thilina, thx for the tips.. on slackware x64 it work fine...

On ireport u can set a defined patter for your field ;right click on the field and check the property .leave the class expression as java.lang.Date and edit the pattern. Code:http://www.google.it/firefox?client=firefox-a&rls=com.ubuntu:en-US:official

hi ralf same problem in Ubuntu x64 ...i have post same problem around the forum but no kind of support or help...if u find the solutions please notify me. Bye

hi all, it's possibile to execute this query SELECT * FROM $P{TABLENAME} where $P{TABLENAME} is a dynamic param that have default param defined that can be the tablename present on db ?

Hi Mary thx for your reply ... i believe that the professional version include all the feature ... Just one question i will ask u about ireport it's possibile to execute this query SELECT * FROM $P{TABLENAME} where $P{TABLENAME} is a dynamic param that have default param defined that can be the tablename present on db ?

Hi just know if there is some kind of support after my company have buy jasperserver licence? there is something that not work on server such Foodmart Sample Analysis View SugarCRM Sample view SugarCRM Sample XMLA Analysis View all this kind of report return me this errror: Error Message: Product Feature is not licensed. Error Trace: com.jaspersoft.jasperserver.api.JSException: Product Feature is not licensed.

Ciao, dopo aver scaricato la nuova versione del server jasper, volevo vedere l'integrazione dei nuovi report con Open Flash Charts, ma quando apro il report ottengo questo errore: com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ofc:pieChart'. One of '{"http://jasperreports.sourceforge.net/jasperreports":component}' is expected.hai qualche idea su come si può risolvere ?

Hi all, there is some way for show very low decimal value on pie3d chart. suppose that i have this dataset STATUSGREEN=98.1670% STATUSRED=1.8164% STATUSYELLOW=0.0166%. With this value the pie that result have only two color , because the STATUSYELLOW it's very low .So there is some kind of tricks to explode the pie,or increase the angle of the color ?, or some other tricks to resolve this situation? THX to all

how u have resolved same error for me ?

Hi Sherman, i don't understand exactly what u mean, but i beleive u talking about on the server side.The subreport is not added as local resource in the main report. If u remember how Ireport 3.0 standalone work when u upload report/subreport ireport run jrxml validator for the subreport but this in the version for netbeans don't go. On the NB plugin just the main report is loaded on server, and return the error that i say on past post. Another thing i have see that there is the new release of ireport aka version 3.1.3,but i have some problem on ireport-nb3.1.3 plugin for NB 6.5 and ireport-nb3.1.3 standalone version. On NB 6.5 after i complete setup and update of platform i load the new plugin but i receive this kind of error. org.netbeans.ProxyClassLo ader]: Will not load class org.apache.xerces.jaxp.SAXParserFactoryImpl arbitrarily from one of org.netbeans.StandardModule$OneModuleClassLoader@625db9eb[org.netbeans.libs.xerces] and org.netbeans.StandardModule$OneModuleClassLoader@1e37504d[com.jaspersoft.ireport]; see http://wiki.netbeans.org/DevFaqModuleCCE GRAVE [org.openide.util.RequestProcessor] javax.xml.parsers.FactoryConfigurationError: Provider org.apache.xerces.jaxp.SAXParserFactoryImpl not found at javax.xml.parsers.SAXParserFactory.newInstance(SAXParserFactory.java:134) at org.netbeans.lib.uihandler.LogRecords.scan(LogRecords.java:127) at org.netbeans.modules.uihandler.Installer.getLogs(Installer.java:681) at org.netbeans.modules.uihandler.Installer.getThrownLog(Installer.java:933) at org.netbeans.modules.uihandler.Installer.getThrown(Installer.java:914) at org.netbeans.modules.uihandler.Installer$SubmitInteractive.createDialog(Installer.java:1814) at org.netbeans.modules.uihandler.Installer$Submit.run(Installer.java:1513) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572). And netbeans stop to work. if i work with ireport-nb3.1.3 standalone i have the same problem with subreport..... If u have any idea i will appreciate any suggest:thx Fabio

trying the two different kind of the tool that i mention on subject , i have found one problem on ireport-nb3.1.3.when i work with report/subreport on subreport expression tab i can define where is the subreport file on my disk, in this way when i deploy the "main" report , the subreport to i'ts deployed on the target server.But this not happen on ireportnb-3.1.3, and only the "main" it's deployes on the server.... some kind of idea?

Maybe on your server there was two instance of mysql and when u reboot it's come up the version with not the jasper database.Check on /etc/init.d if there is executable mysql, if yes remove the permission .In this situation when u reboot the initd process don't execute mysqld and u can run ./jasperctl.sh start... tricks to runjasperserver on boot ,put on bash file PATHTOJASPERSERVEREXECUTABLE start and save it on /etc/init.d and make it executable.