sara.machado

yeah pure magic indeed!! :P Now it is working and I do not see how it didn't before. Thanks so much Ernst Cheers

That it is already what I had (your magic formula :P)....and the issue is here. My output is different because all the values are being calculated but not rounded. How did you managed to put rounded values on your output without messing the calculation? if I put pattern it happens the problem that originated this question..I am not understanding the difference indeed. Thanks sum without round0.5344508.564509.10508.49589999999969.83471,087.43

Yes, it is exactly what I need, the sum of unrounded values. I use the pattern before so what is the difference between what you have done? I even manipulatted my XML to look similar at yours and even so I do not drive to the same solution. can you address your solution in steps please? when I use your entire XML I get an error: Error loading the report template: org.xml.sax.SAXParseException; lineNumber: 2; columnNumber: 479; cvc-complex-type.3.2.2: Attribute 'uuid' is not allowed to appear in element 'jasperReport'.

hello Ernst, thanks for your input. However I may not been able to properly explained the issue, let me try to put it another way. Back to my example for the sake of explanation: Basically what I need is to do the sum exactly like column 1 in order to give a more precise total amount and afterwards print all the values of the column 1 with just 2 decimal points like the layout of column 2. If I use pattern (that I tried before) it will calculate and print like column 2 which is not ok if you want to minimize the differences when we put it with other amounts. Do you think is possible to calculate and print different stuff in ireport? thanks sum without round (column 1)sum with round (column 2) 0.53440.53 508.564508.56 508.495899999999508.50This value is the same but the second column is rounded 69.834769.83 TOTAL1,087.431087.42Thus I find a small difference that I do not want to exist

I am trying throught subdataset's to arrive to the total rounded without affecting the calculation, but no success so far. Additionally, I find a little bit odd not find any solution so far regarding this issue. Basically I do not want to use the Pattern option since it is influencing the rounded total values (as you can see in the example above). What I pretend is to guarantee the 2 digits after decimal point but that being only about final layout and not imposing to any calculation. Since I am new to ireport functionality can someone give me any special advise? thanks in advance