swenf

problem solved. installed Ubuntu in the english version instead of the dutch. Jasperserver could be started after installation.

I've installed jasperserver on a Linux system with Ubuntu 12.04(64 bits on the root account). Jasperserver is installed with bundled Tomcat and Postgres. When starting the jasperserver ./ctlscript.sh start the following message/error apears(Postgres will not start): [: Illegal number: UID=0"root" execution of the PostgreSQL server is not permitted.The server must be started under an unprivileged user ID to preventpossible system security compromise. See the documentation formore information on how to properly start the server./opt/jasperreports-server-cp-5.5.0/postgresql/scripts/ctl.sh : postgresql could not be started Swen

I Designed a couple of reports which have to show Chinese characters. The chinese tradional characters are displayed in de the report but chinese simplefied characters are not visible in the PDF output. When I run the report in iReport all the characters are displayed correctly. iTextAsian.jar is installed and the following font is defined in the report: pdfFontname: MHei-Medium pdfEncodig: UniCNS-UCS2-H isEmbedded is true. Does anyone have a solution? Swen Post Edited by swenf at 02/12/2012 08:31 Post Edited by swenf at 02/12/2012 08:34

Problem solved by setting the variable to new BigDecimal($V{})

I read "You create a "report unit" in JasperServer that links the data source, the JRXML, scriptlet JARs, resource bundles, and report parameter definitions. This is stored in the repository and configured for the report when it needs to run." I created the report on Jasperserver(the reports works in iReport with a static XML as datasource). My question is how do I create a datasource for this report in Jasperserver? I would like to work with dynamics file names as datasource. In the reaction on this topic I read that working with XML datasource is possible but I'm stuck on how to define the datasource in Jasperserver. Could you help me? I'm working with jasperserver 4.2.1 ce. Swen

I have an existing report which is working on iReport 4.0.2 and Jasperserver 3.7. When i use the same report in iReport 4.1.1 or Higher or in Jasperserver 4.2 the report generates the following error: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigDecimal caused by the following code in a variable which is defined as BigDecimal and calculation type is SUM: $F{jaar}, $F{periode} $P{Boekjaar} and $P{Periode} are defined as an Integer. $F{soort} is defined as String $F{klant_omzet_onderdelen} is defined as an BigDecimal. Code: $F{jaar}==$P{Boekjaar} &&$F{periode}==$P{Periode} &&$F{soort}=="0" ?$F{klant_omzet_onderdelen}:0 Does anyone know what causes this error in the new versions of Jasperserver and how I can solve this wihtout redesign the report(It is not the only report)? Swen Code:Groovy code: $F{jaar}==$P{Boekjaar}&&$F{periode}==$P{Periode}&&$F{soort}=="0"?$F{klant_omzet_onderdelen}:0

This works. Thans

We installed jasperserver 4.2 and we imported the reports. We want to run the reports on jasperserver we get the following error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: com.mysql.jdbc.Driver We installed the mysql connector: "mysql-connector-java-5.1.18" in the.."/buildomatic/conf_source/db/mysql/jdbc/" directory. The datasource is defined as: Driver: com.mysql.jdbc.Driver url: jdbc:mysql://localhost/im8 When I test this in jasperserver I get the message "connection failed". When I test this in iReport de "connection test was succesfull" Can anyone help me?

Solution: I used a parameter for setting de database for each table in the query.

Does anyone know if it is possible to set database in a JDBC connection as a patameter or change it when starting de report on jasperserver? I have a lot of databases on MySQLserver with the same tables. I want to use one report to access different databases.

Does anyone know if it is possible to set database in a JDBC connection as a patameter or change it when starting de report on jasperserver? I have a lot of databases on MySQLserver with the same tables. I want to use one report to access different databases.