markos17

ok, it works now. I use such formula: ($V{wylMeasure}.toPlainString() == "0") ? null: $V{wylMeasure} Thanks a lot!!!

delete Post Edited by markos17 at 05/13/2010 14:12

sure, sure :) i'm attaching Excel

hehe, i know that distinguishing is a matter, but any clues, how to help my fantasy :)

It almost works! There is just one issue. It also cut off cells with actual value of zero: "0.0000".

thanks for the hint. It doesn't show error any more, but also still doesn't bring any effect. Now the formula is: ($V{wylMeasure} == new BigDecimal(0)) ? null : $V{wylMeasure} but still shows "0" It looks like, the formula can't find the "0". When I swaped formula into: ($V{wylMeasure} == new BigDecimal(0)) ? $V{wylMeasure} : null then all cell are empty. I also tried many other combination, like new BigDecimal("0") and so on.. When I change BigDecimal into String, then it works fine, show empty cells instead of "0", but the in the TOTAL column there are values from the previous column. I attach Excel File with an example. Any ideas, as I'm startin to give up :/ Post Edited by markos17 at 05/13/2010 11:12

unfortunately, I have errors with types. how can i cast 0 from Int to BigDecimal? java:154: incomparable types: java.math.BigDecimal and int value = (java.math.BigDecimal)((((java.math.BigDecimal)variable_wylMeasure.getValue()) == 0) ? null

I use Crosstable in which i show some values in different periods. I used to use Java.lang.string and eveyrthing was ok. When in database position didn't have any value, then in report it was the same. Last time, I wanted to use summary column, that'd sum all values in rows and columns. I had to change type to java.math.Bigdecimal. Since then instead of " ", it shows 0. Is there any way to solve it out?

Yes, I'm using Row Group. It's essential in my case. I found some option->JasperReport Properties->PROPERTY_COLLAPSE_ROW_SPAN, it's set on false by deafault, but still cells are merged :/ Post Edited by markos17 at 04/22/2010 14:09

anybody can help?

I use crosstables in iReport. I have some problems. 1) Now, crosstabs merge my cells, I've attached screenshot with an example. Look at column B, I'd like to have spare names in every cell, like in colum N. 2) How to use default value for cells with no value? Now, when there is no data, crosstable shows "0" (eg. L49,L50,L51,L52). In database I set "0" for "d" and then crosstable shows "0.0000" (L53) Is it possible, to set some value, like "-" in case there is no data? 3) Last thing, which bothers me, is blocking cells/rows in Excel. I'd like to block the top row, so it's always visible, when I scroll XLS document down. Is this possible at all? Thanks in advance, for any help!

I'm creating some reports in excel format. I'd like to block the top row, so it's always visible, when I scroll document down. Is such option available in Ireports 3.7.0?

Thanks, it works in ireport, but in my application it generates such error: "javax.servlet.ServletException: java.lang.Exception: an error occur during report generation: org.xml.sax.SAXParseException: cvc-complex-type.3.2.2: Attribute 'ignoreWidth' is not allowed to appear in element 'crosstab'" Do you think, that I have to do some soft updates?

Hi, Recently, I was generating some reports and have notice some issue. When I use collection parametr, it generates a couple of columns. When there are plenty of them, some of them are moved under the first ones. Is it possible to display all columns in one level in Excel? Now, it looks like this: 2009-08-01 2009-08-02 2009-08-03 2009-08-04 2009-08-05 2009-08-06 A 0 0 0 0 0 0 B 0 0 0 0 0 0 2009-08-07 2009-08-08 SUM A 0 0 0 B 0 0 0 I'd like to change it into this: 2009-08-01 2009-08-02 2009-08-03 2009-08-04 2009-08-05 2009-08-06 2009-08-07 2009-08-08 SUM A 0 0 0 0 0 0 0 0 0 B 0 0 0 0 0 0 0 0 0

I am giving up :) all the time I get message: "Cannot cast from String to Boolean". The thing is, that Boolean class is set in my_field: ($F{my_field}==Boolean.TRUE?"Yes":"No") I also tried to use variable, all the time the same error. EDIT: Problem solved. I had to change class of the field in report into String. Post Edited by markos17 at 08/13/2009 12:02