ggovedar

I know the following is really to long, but please bear with me.... I’m developing a report with two groups Group 1 – broker Group2 – product It’s a YTD report so in the column header I have 200701, 200702, 200703… My date looks something like this Broker_name Month Product Value Broker 1 2007January a 100 Broker1 2007JFebruary b 50 Broker1 2007JMarch b 50 Broker2 2007January a 10 Broker2 2007February a 10 I need to show sums by broker by product by month In product group footer I’ have a variable summing up all values by broker/product as this Variable name sumJan new Double (($F{Month}.equals("2007January") ? $F{Value}.doubleValue() : 0.00 )) calculation type: sum rest type: group reset group: product this all works fine and I get correct sum per broker/per product Broker Name Product 200701 200702 200703…. Broker 1 a 100 0 0 b 0 50 50 TOTAL 100 100 150 Broker2 a 10 10 0 TOTAL 10 20 0 The problem comes when I try and sum by product by month, the sums seem to be MULTIPLIED by what seems the position of declared sum variable..more or less So for broker 1 I’ll get 100 in the sum for 200702, and 150 for 200703 in this variable..the… multiplication number seems to go up for each month so for May it is what actuall sum for that month should be multiplied by 5…. Variable name: sum_sum_jan $V{sum_jan} calculation type: sum rest type: group reset group: broker It seems to me like there is a loop that adds all the fields together an by the time it gets to for example May it has already added all the values 4 times, so I end up with the total 5 times more than it should be… I hope this makes sense.. Anyone has any idea how can I stop this from happening?? Thanks in advance Goran

Hi, trying to do a WAR Jasper Server install in Weblogic 8.1 but not getting far with it. Can anyone give me some pointers as to how to do it? We've created new Weblogic domain, but when trying to upload the WAR file we get the following <24-Apr-2007 10:53:53 o'clock BST> <Notice> <WebLogicServer> <BEA-000360> <Serve r started in RUNNING mode> <24-Apr-2007 10:53:53 o'clock BST> <Notice> <WebLogicServer> <BEA-000355> <Threa d "ListenThread.Default" listening on port 7001, ip address *.*> <24-Apr-2007 10:54:25 o'clock BST> <Warning> <HTTP> <BEA-101248> <[Application: 'C:bea8.1user_projectsdomainsJasperServermyserverupload', Module: 'ji-pro' ]: Deployment descriptor "web.xml" is malformed. Check against the DTD: org.xml. sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'web-ap p'. (line 1, column 219).> <24-Apr-2007 10:54:25 o'clock BST> <Warning> <HTTP> <BEA-101168> <The security-r ole-assignment references an invalid security-role: tomcat.> Anyone got any idea what is going wrong? Thanks in advance Goran

Managed to solve it if anyone has same probblem, I took all timezone info off the data source definition screen (choose blank line) this seems to work, dates are now matching Goran

Hi, thank you for the fast reply! I did look at the timezone info in JS, my data source is at Europe /London Greenwich Mean Time... which should be correct as I am in London.. This is also the timezone on the Login screen.. Is there anywhere else where the timezone info is stored? The database is storing real times, not offsets, and the correct date/time should be 18/04/2007... Any other suggestions would be much appreciated Thanks, Goran

Strange date problem between iReport 1.3.1 and jasper server 1.2 If I execute the same report a date field comes back different, in iReport I get back 18/04/07 00.00 executing exactly the same report on the server I get back 17/04/2007 22.00.00 I've even tried getting the report from the server via the plugin and execute and the difference is still there! Anyone has any idea what is going on here? Thanks Goran