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..

I'm using both mozzila and IE, and i have the same problem, not only with the sample, i need to display a list of values and i can't 'cause only show the first value of the list. I think its a bug, cause a similar case happens when i try to use a list of value with radio option, in this case, the input control don't show nothing, but if you try the reset button it appears and disappears. I really need to use a list of value with radio option, can anyone help?

Here is the url, find it in Certified platform support, in the list of OS is not CentOS include. http://www.jaspersoft.com/sites/default/files/downloads/Jaspersoft-pro-vs-community-wp_0.pdf Thanks.

Hi Tony, thanks for your answer. I was reading some old threads, and there are people, who could install after solve some problems, so i think that we can...only we need to try harder! I´m attaching 2 logs, one of the CE instalation, and the other of the Professional version, and in both cases, the error is the same, all seems right, but the jasper table on MYSQL is not on the database. About the MYSQL existing (version 5.0.77), is because we are trying to install jasper in a virtual server, our VS provider works with Plesk Power Panel, and the mysql it's already installed 'cause Plesk needs to keep some internal databases for work, the same happen with TOMCAT 5.5 We have tried with the WAR file, and install using the buildomatic, and the results unfortunately were the same. I´m looking the pdf which says CentOS is not in the list of OS supported...As you imagine, we have a lots of docs, helps, tips, etc printed, just let me find the exactly url where says that. Ohhh, the platform is CentOs 5.4 - 64bit. Thanks and regards. Kelly.

Hi, We found some pdf documentation from Jaspersoft.com, it says that Jasperserver don´t run into CentOS platform, is this right??? it would be the reason that we can´t install jasperserver good. Buuuuttttt there are another pdf and says that jasperserver professional 3.7 is supported on CentOS 5.x Please we need that somebody, who know about it, can help us...it´s so important. thanks for your time.

Hi there, We installed Jasperserver in a virtual server running in CentOS (linux), we did by SSH conexion, we use a Tomcat and MySQL has already existing.....it seems that every was ok after the installing, the ports was ok, the login root user name ok. But the jasper table that had to be created on a MySQL database, is not there, and of course we couldn't log in. Can anybody help us? thanks.

Hi, I need to hide a ceratin value in a column of my crosstab but keep the final total is something like this what i have A B C TOTAL ____________________ BLUE 1 2 3 6 RED 2 2 1 5 ______________________ And I want this, hiding for example column B but keeping the result, A C TOTAL ____________________ BLUE 1 3 6 RED 2 1 5 ______________________ How can i get this??? can anybody help me please??? sorry for my english.