chenny

Hi, Josh, Migrating from 3.1 to 4.5 can be huge challenge. 1. download from 3.1 and upload to 4.5 using ireport 4.5 To me ...trackling one by one rather than a bunch of 400 problems. Once you have noticed the workaround, the rest ll be smooth. May sound crazy ...its work fine with me. Chen

LK, Since your jrxml contains an image, what is your image expression ? It must not contains any local path otherwise JS invalidate your jrxml. You need to upload the image separately. Hope this works ! Chen

Interesting ..... Error 5321 ...looks your harddisk space running out ? How do you create your jrxml file ? If you are using ireport ....what is your version ? Best choice is iReport 4.5 on JS4.5 Is the user permission to database correctly set ? I assume you are using postgresql ! What is the JVM settings ? can u upload your jrxml ?

LK, You did not indicate that you are unable to upload jrxml file via website. Yr JS should report any error unless you have disabled the logging. As you have said that there is no error in JS, then you try to degrade your iReport. If your JS is v4.0, have you try the iReport 4.0.2, 4,1 or even 3.7.6 or below? If your JS is 3.1, any major release of iReport other than ir3.0 may not work. have you uninstall, delete all residual files and re-install as NEW ? My experience is that I can download and cannot update or upload. Classpath, JVM Settings needs to be checked and corrected in the iReport. Otherwise ...hold on the working version. Chen Post Edited by chenny at 02/29/2012 01:21

My jrxml is more 100kb ..... I currently used the latest jasperserver 4.5 and Jaspersoft iReport Designer 4.5.0. My experience was JS 4.0.1 was problematic and so moved back to js3.7 Now testing JS4.5 ! Post Edited by chenny at 02/28/2012 13:06

Well, I guess you can copy the user data from js31 database

Did you try to upload via web browser ? What was the error given in the server log file ?

It is more likely the installation of JS 4.5 database is corrupted or incompleted. Try to delete the database and re-installed.

All you need to do ....you are manually insert war into tomcat6 after you manually edited all required settings to run as jasperserver2.

I do encounter the same problem. There is a huge compatibility problems from 3.1 to 4.5 in particular of your jrxml files. I do recommend you to install as new, maintain the existing 3.1 and transfering your jrxml files.

Hi, I am glad to see the great improvement on the functionality of $X{IN, param1, param2}. However I am unable to get things work. case 1. <parameter name="CountryList" class="java.util.List"/> <queryString><![CDATA[ SELECT * FROM Orders WHERE $X{IN, ShipCountryid, CountryList} ]]></queryString> case 2. <parameter name="CountryList" class="java.util.Collection"/> <queryString><![CDATA[ SELECT * FROM Orders WHERE $X{IN, ShipCountryid, CountryList} ]]></queryString> I got an error in both cases. The error is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying. Then I noticed that param1 must be a character varying. Please guide me ... David Post Edited by chenny at 02/27/2012 06:48

Suggest to check on FAQ. Most of us is defaultly set db server to localtime and JVM's timezone is defaulted to CET (unawared). You need to change these parameters to GMT as well in jasperserver otherwise it won't work correctly. The best solution is to convert your date/timestamp into text in SQL..... then In your reports convert text back into date. rgds

Andrea, Just modify your sql query into query within query. Rgds

Hi, I am using iReport 3.0.0 and JasperServer 3.0.0 with Postgresql 8.3. My report query is select rapiderp.findstartperiod($P{periodID}) , rapiderp.findendperiod($P!{periodID})::date as aging_run_date, ar.customerid as aging_customerid, cu.name as customers_name,cu.name_ch as name_chinese, cu.agentgroupid as customers_agentgroupid, ag.groupname, sum(case when ar.period_id<$P{periodID} then ar.amount else 0.00 end) as aging_openingbalance, sum(case when ar.period_id<=$P{periodID} then ar.amount else 0.00 end) as aging_closingbalance, sum(case when ar.period_id=$P{periodID} and ar.sourcetype='IN' and iv.invoice_balance is not null then iv.totalamount-coalesce( (select sum(rd.amount) from rapiderp.receiptdetails rd, rapiderp.receipts rr where rr.receiptid=rd.receiptid and rd.sourceidapplied=iv.invoiceno and rr.period_id<=$P{periodID}),0.00)::numeric else 0.00 end)........... IF the periodID is 152 ....it should result in the rapiderp.findendperiod($P{periodID}) as '2008-07-31'::date. But it always display as 2007-07-30 in the reports. or perodID=153 ..-> 2008-08-31 .....print out as "2008-08-30". Please assist .. Regards David