kalvarez

Hi Matt, Advanced Options is only available in professional edition, or in CE too? 'cause i have ireport 4.0.0 and this option is not available, or maybe is a bug??? thxs, Kelly.

why don't do it with a conditional expression??

Hi there, What i need is login in my php application and keep the user_id in a session variable and then pass the user_id as a parameter to my reports running on JasperServer, and fill the report with the information apropiated for this user_id, then in the IReport i have the query like "select * from my table where user_id = $P{parameter_from_login_php_userid}", is that possible, i'm not a big programmer but i need the user logged into my php application as a input parameter to my reports on Jasperserver. thanks for your help!!!

Me alegro pato!! Ohhh yes, i forgot to tell you, the measure variables must be created in the crosstab and not on general variables. Exactly the worst thing is resize the textfields each time that you put a new one...so you have to put all text fields that you're going to use and then create the measure variables... greetings, saludos Kelly

Heey Pato why don't you create 4 variable measure like this: Totalcolumn1 in bucket expression put: $F{ID4}.equals("SI")?$F{CANT}:0 Totalcolumn2 in bucket expression: $F{ID4}.equals("I")?$F{CANT}:0 Totalcolumn3 in bucket expression: $F{ID4}.equals("S")?$F{CANT}:0 Totalcolumn4 in bucket expression: $F{ID4}.equals("D")?$F{CANT}:0 Totalcolumn5 in bucket expression: $F{ID4}.equals("SF")?$F{CANT}:0 all of them are integer and to calculation sum, then in the total area paste 5 text field with the 5 variables and at header column a "subtotal" static text. I know is not elegant solution, but maybe can help you, for me this help me a lot in some hard reports that i had. good luck

And what about print percentages not int...i need something float, with 2 or 1 decimal precission like 45.22%, how can i do this? there is a way to get it?? Thanks

Hi!! The field is an integer, and you want to show a string, so you have to set the expression class as java.lang.string $F{int_field}==1?'TRUE': 'FALSE'

Hi!! I´m trying to create a crosstab sorting by measure, is there any way to do this, because i can sort by columns and rows but i'm not sure if i can sort by measure. I tried to do it from my query and check the option "data is pre-sorted" but with a wrong results. what i need to do is something like this. An evolution table by year : customers 2008 2009 2010 ------------------------------------------- customer D 2 3 5 customer A 4 1 3 customer C 0 2 2 customer B 1 3 0 I need the measure ordered descending only for the last year 2004, and 2004 is entry from parameter. Is there any way to do this? thanks in advanced!!

Thank you Carl, you´re right, the ireports treat numbers at the beginning as text but if set "data is pre sorted" even my text field is a string type, the sorting is correct, now my count variable works perfect... Univ 2004 (€) 2005 (€) 1. UNIV UA - 0 168.836 2. UNIV UAB - 2.008.197 0 3. UNIV UCOR - 0 733.932 4. UNIV UG - 5.504.078 30.010.964 5. UNIV UJI - 8.139.486 0 6. UNIV UL - 0 4.394.443 7. UNIV UPNAV - 0 6.618.546 8. UNIV UPVAL - 11.950.900 105.415 9. UNIV URJC - 358.605 8.487.824 10. UNIV USEV - 185.208 95.000 Total (€) 28.146.473 50.614.961 thanks :D!! Post Edited by kalvarez at 01/31/2011 08:45

for me is not necesary to reopen the report, just have to reopen the value expression of the new measure, do double click in your expression until refresh the fields or variables by the jasper and ok, it works for me. The error (1. The class of the expression is not compatible with the class of the measure......) dissapears, compile again and it works!!! :D

Hi everybody!! I´m using the ireport 4.0, and i like it, before i used the 3.6 and i see a lot of good changes. What I need is ordering the row group from a crosstab, i have a variable "count" to put the number at the begining of each rows and works ok, the problem is that number rows of the crosstab are in a wrong order. The bucket expression from my row group is: $V{Count Variable}+". "+$F{my field} order Ascending Where $V{Count Variable} is an integer that counts my field...and thats works Ok, but the order is wrong!! The result is something like this, you can see that the position 10 is in the second place, not in the tenth place how is right. Univ. 2004 (€) 2005 (€) 1. UNIV UA - 0 168.836 10. UNIV USEV - 3.000 0 2. UNIV UAB - 8.574 0 3. UNIV UCOR - 0 1.984 4. UNIV UG - 14.742 0 5. UNIV UJI - 50.000 0 6. UNIV UL - 0 782.855 7. UNIV UPNAV - 0 4.539 8. UNIV UPVAL - 133.100 0 9. UNIV URJC - 250.000 0 Total (€) 459.416 958.214 Any idea?, i think there is a simple solution but i can't find it... thks!!

Hi sallysimpson it´s no necesary to set the other bands to 0, just put the crosstab in summary band.. good luck!

thanks so much ndayan it works perfect!!!!!!

it was the same issue that happened to me, disappeared, and appeared when i pressed reset for a second, you say the solution is to update the version, now I have the 3.7.thanksEscucharLeer fonéticamente Diccionario - Ver diccionario detallado

I have the same issue, anybody know if the bug was fixed, in the actual version, I use the 3.7??? thanks..