yann22580

Hi cyyung1023, If it is ok without the parameters did you rechecked the type of your parameter $P{KEY} ? It looks like the $P{KEY} parameter is not passing a number value with this Oracle error. Let us know, Regards, Yann

Hi xmcamino, What is the type of your field ? For a double or a Big Decimal you can use this : String.format("%,.2f",$F{field_name}) .2f is for a dot as a separator then 2 floating point on a decimal number. But my locale is 'France' on my PC so the dot become a comma. Examples : System.out.format("%.3f%n", pi); // --> "3.142"System.out.format("%10.3f%n", pi); // --> " 3.142"System.out.format("%-10.3f%n", pi); // --> "3.142"System.out.format(Locale.FRANCE,"%-10.4f%n%n", pi); // --> "3,1416" https://docs.oracle.com/javase/tutorial/java/data/numberformat.html You can check on your locale or set the locale directly in the format function. Hope it will help you, Yann

Hi aodhomeachair, With the $X{IN} format you don't need the $P{} structure for the 1st parameter, just the name. For your example just write : select * from r_daybook where $X{IN,Customer,Customer_multi_select } Regards, Yann

I precise I read the TIB_js-jrs-ce_7.5_Admin-Guide.pdf, ch 5.5.2 without success : "The LoggedInUser and LoggedInUsername parameters are always available for query input controls; they'realways available to reports, as well, even if an input control isn't defined for them. The standard parameters are also provided for reports if they're defined as parameters in the JRXML." Oh, it works fine in a simple report with the LoggedInUsername parameter ! But I need it to work in a report book. I gonna try to create the same parameter in the main report and send it to the report where I need it and let you know. Edit: tested ok, in a report book you need to create the parameter in the main then send it to the others reports.

Randomly this happens when your report contains resources pointing to the repository as you said. You make changes in your report and sometimes it is ok, sometimes you will have the Report Publishing Wizard... I don't know why but it is true with older versions of the Studio. I'm using 6.11 but 6.10 and previous before with the same behaviour unfortunately... In my case I would say it comes from the pictures, in the Report Publishing Wizard it always offers me this path "repo:/image_name.jpg" instead of the full path "repo:/Resources/Images/.../image_name.jpg" for example.

Hi, I use a report book but in debug mode I can find in the log one of my jrxml : 2020-09-23T17:21:36,289 DEBUG EntityPrinter,pool-10-thread-8:109 - com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource{parent=com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFolder#610, updateDate=2020-06-19 13:00:39.205, name=B_II_amelioration_creation.jrxml, description="repo:/reports/... Debug mode : in JRS : Server parameters -> the 2nd line, the one with no name in JRS 7.5.0 -> Debug Hope it will help, Yann

Hi, Easy answer, well I thought. I'd need to get the LoggedInUsername in my report to dispaly a correct image depending on the user logged in. Before we could use a $P{LoggedInUserName} parameter but I get only a null value in 7.x release. I tried with "$P{LoggedInUser}.getUsername()" too. What is the new way to get these values ? Is this link outdated anymore ? https://community.jaspersoft.com/wiki/built-parameters-logged-user Thanks beforehand, Yann

Idem in JRS 7.5

I thought I got the error because I was trying to use "-keystore C:Users<myname>" so I changed it to : keytool -genseckey -keystore C:Jaspersoftjasperreports-server-cp-7.5.0buildomatic.jrsks -storetype jceks -storepass storepw -keyalg AES -keysize 128 -alias importExportEncSecret -keypass myimportexportpw[/code]The command generates a .jrsks file but I have a warning : "The JCEKS file use a proprietary format. you should migrate to PKCS12 wich is a standard format using "keytool -importkeystore -srckeystore C:Jaspersoftjasperreports-server-cp-7.5.0buildomatic.jrsks -destkeystore C:Jaspersoftjasperreports-server-cp-7.5.0buildomatic.jrsks -deststoretype pkcs12" I did nothing for the warning this time and I just tried to list the key in the keystore : keytool -list -v -keystore C:Jaspersoftjasperreports-server-cp-7.5.0buildomatic.jrsks -storetype jceks It asks me for the keyfile password, so I wrote 'myimportexportpw' (isn't it?) but I still have the same issue : "erreur keytool : java.io.IOException: Keystore was tampered with, or password was incorrect " Yeah, great... I understand 'myimportexportpw' is used as an ecryption key but there is no password to list the keys in the keystore, just type 'enter'.. Then I js-import my .jrsks on the Windows and Linux environments and import my report (new export because of the new key) on the linux one, success!

Hi, it seems you have a compatibility issue. In your apex, what is the release of your JRL (Jasper Reports Library) ? Should be at least 6.0 if you use Jasper studio 6.0. Maybe I miss a thing...

Hi, As far as I know there is no chart like you expect in Jasper CE (maybe in Jasper Pro releases..). The chart that looks like a bit like the one you want will be a bar chart with 'orientation' = 'horizontal' in the "Chart Plot" section and you will need to set -50 and +50 to min and 'max axis value' in the 'Value Axis' part. regards ps : you can add tags to your post to specifiy release and software concerned

On 2 JasperReports Server 7.5.0 environments I need to export from one to import on the 2nd. The answer should be here (or in the security guide) : https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v7/using-custom-keys If I understand correctly I have 2 files in my home directory (.jrsks and jrsksp) from the installation. But to build a new same key to share in your 2 environments you need to generate it like this, cf security guide : (keytool command is in jasper/java/bin directory) keytool -genseckey -keystore C:users<you> -storetype jceks -storepass storepw -keyalg AES -keysize 128 -alias importExportEncSecret -keypass myimportexportpw Problem is I get an error : erreur keytool : java.io.IOException: Keystore was tampered with, or password was incorrect Is anyone have an idea ? I am blocked to import new reports or updates on production environment (it was not planned to migrate to version 7.5.0 before the tests...) Thanks guys, Yann

I tried too, the answer should be here : https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v7/using-custom-keys You should have 2 files (.jrsks and jrsksp) in your home directory, ex : C:users<you>. But to build a new same key to share in your 2 environments you need to generate it like this, cf security guide : (keytool command is in jasper/java/bin directory) keytool -genseckey -keystore C:users<you> -storetype jceks -storepass storepw-keyalg AES -keysize 128 -alias importExportEncSecret -keypass myimportexportpwProblem is I get an error : erreur keytool : java.io.IOException: Keystore was tampered with, or password was incorrect

Hi Andriy, Thanks for your answer, it works. Ttoo bad it tooks so long just because of that.. Regards, Yann

JasperReport Server you mean. Did you look at the docs ? The answer is here : TIBCO JasperReports Server Authentication Cookbook https://community.jaspersoft.com/js-docs/restricted-doc/71181