xavier.bonislawski

Hello, I Had a repport that worked fine in JasperServer 7.1 After upgrading to 7.5 the same repport doesn't work anymore. I got the following error message : "ERROR IntrusionException,pool-5-thread-521:55 - [sECURITY FAILURE Anonymous:null@unknown -> /ExampleApplication/IntrusionException] INTRUSION - Mixed encoding (2x) detected " " Error during report execution com.jaspersoft.jasperserver.api.JSSecurityException" I understand that a security check causes the exception, and I found the SQL instruction that causes the problem SELECT REGEXP_REPLACE(CODE_ANALYTIQUE,'^(.){4}(.*)([[:digit:]]{3}$)','2-3') AS PROJET FROM MYTABLE and if I modify my query like this SELECT SUBSTRING((CODE_ANALYTIQUE,....)-SUBSTRING((CODE_ANALYTIQUE,....) It works fine. But I prefer to use the REGEXP_REPLACE statment rather than the SUBSTRING So what is the cause of tis exception, and how can I fix it ? Thanks

Thanks for your answer, No the users have a standard role (I mean non administrator) I think it's a bug I will try to upgrade to 7.2, hope il will solve my problem Regards Updade on november the 28th I have upgraded to 7.1 it works fine now Regards

Hi everybody, (Jasperserver 6.2) I created a scheduled job with an admin account but unfortunately all the users have the right to delete my job :( They can not modify the scheduled job They can not launch the report itself because of the permissions But they are allowed to delete the job. Any idea of what to do ? Regards

Hi all, very old post.... I had the same problem when I realized that the file used by my server was jasperserver_config_fr.properties and not jasperserver_config.properties I think that Zellmer's server worked with config_de Hope that helps.

Hi I have a crosstab but I do not want all the values (rows) returned by the query for exemple SALES State jan Feb TotalTexas 10 5 15 California 10 10 20 Arizona 5 5 10 25 20 45 And I do not want the datas for California so the crosstab should be State jan Feb TotalTexas 10 5 15 Arizona 5 5 10 151025 And the total is also modified Is it possible to do that without modifing the SQL Query ? (The name of the state is a field value returned by the query) Regards

Hello The topic is old but it may be usefull... Use the "PROPER" text buil-in function in jaspersoft studio Regards

Thank you, unfortunately it doesn't work. The query returns some rows so the input control is filled by these rows. And the first of them is selected by default. available : 8 selected : 1 (900 in this case) and I whish to have none selected by default. Thank you for your help.

Hello, I got a query-based input control in my report, the first choice is selected by default (default value) Is it possible to deselect this line so there is no default value for this input control. On the contrary is it possible to have all the choices (all the lines) selected by default. Regards