tom_45

Hi, Whenever I try to use a built-in function in Jaspersoft studio, I have an error like this one: Error evaluating expression for source text: UPPER($F{nett_content_value}) I have this in the Expression field of a text field: UPPER($F{nett_content_value}) Is the syntax wrong?

Hi, I'm having a hard time working out the correct syntax for a text variable that I want to convert to a date (because I want to compare it to the current date). While I'm toying around with the expression (simpledateformat), and changing value class name from java.util.date to/from java.lang.string, and running my report again in jasperstudio, it sometimes suddenly starts to work, and then fails again with the error "Error evaluating expression for source text: new SimpleDateFormat("yy-MM-dd").parse(new Date()) Now my question: is it possible that some changes take some time to be effective, so that I am seeing the effects of a cached version or something? Or is everything I change in jasper studio always active the momentI change a parameter ? Just wondering because it's driving me nuts...

Hi, The locale used by me is dutch (belgium). I've set it in the server connection settings. When I login however in jasper server, that locale is not listed. Is there a way to add missing locales to jasper server? Belgian(dutch) in my case? Thanks for your extensive reply.

Hi guys, I have installed the jasperstudio CE 6.6.0, and on the same server, jasper server 7.1.0 (Windows server 2016) I am not a programmer, that's probably one of the biggest problems I have here. Let me explain. I managed to create a pricelist report that correctly outputs prices via jasper studio. To that end, I created a text field because there are some calculations behind it: ( $P{prijslijst}.equals(0) ? "€ " +$F{base_sales_price-LAT_BE-EUR} : ( $P{prijslijst}.equals(1) ? "€ " + ($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export1_discount_pct})) : ( $P{prijslijst}.equals(2) ? "€ " + ($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export2_discount_pct})) : ( $P{prijslijst}.equals(3) ? "€ " + (($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export1_discount_pct})) + (($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export1_discount_pct}))*$F{export3_surcharge_pct} )) : ( $P{prijslijst}.equals(4) ? "€ " + (($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export1_discount_pct})) + (($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export1_discount_pct}))*$F{export3_surcharge_pct} )+((($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export1_discount_pct})) + (($F{base_sales_price-LAT_BE-EUR} + ($F{base_sales_price-LAT_BE-EUR} * $F{export1_discount_pct}))*$F{export3_surcharge_pct} ))*$F{export4_surcharge_pct})) : 0 ) )))) In jasperstudio, this is correctly output e.g. € 56.63 Then, with a lot of effort, I managed to get jasper server running and was able to upload the report to the server. When I run the same report on the server, the € 56.63 has suddenly become € 5663.0 Same with quantities: 3 kg in jasper studio becomes 30000 kg on jasper server. I'm beginning to understand it may have something to do with localisation, but I don't understand: - what locale I am using in jasper studio (how can I see this ?) - what steps do I have to take to ensure that the report displays consistently accross jasper studio and jasper server? Thanks in advance for your valuable output. Tom

Hi, I've been looking around in the file, but I don't see any clues as to what I should change. I assume I need to add something from this link: http://jasperreports.sourceforge.net/config.reference.html ? Further info would be most welcome. Thanks, Tom

Hi, When I run my report in jasper server, the numbers are in a different format than in studio. Example: In Studio: 3 kg On Jasper Server: 30000 kg In Studio: 34.98 EUR On Jasper Server: 3498.0 EUR What do I need to do to have the output on the server the same as in studio (studio output = correct) ?

Hi, I found it. It was on Windows BTW. An RAS adapter was active, and so the regular LAN ip was apparently blocked.

Hi, I have installed Jasper Server 7.0 and localhost access is fine, but I can't get to the login page from a remote host. I assured no firewall blocks the traffic, but when I try to access the server via ip address (even from the localhost itself), I still get a "This page can't be displayed" error message. I used the stock install file. no errors are shown in the tomcat logfiles. Netstat -an reports that the server is listening on 0.0.0.0:8080 which should indicate that it listens on all network addresses. Any ideas? Thanks, tom

Hi, I downloaded jasperreports server 7. The install succeeded, and I can login perfectly. Then - on the same server - I tried to publish a report to the server. I get to the window "report publishing wizard', but no jasperreports server is shown. What do I need to enable to see my (localhost) jasperreport server ? Thanks,

Hi, I want to print a line under each record in the detail band. This work fine, except when one of the fields overflows, in this case the line is printed in the middle of the record. How do I tell Jasper to stick to the bottom of the detail band?

Hi, Thanks I don't know if this would work with excel (can't use sql). But I got the same result using this in the expression editor: ( $P{taal}.equals("NL") ? $F{short_title-nl_BE} + " " + ($F{baseline-nl_BE}!=null?$F{baseline-nl_BE}:"") : ( $P{taal}.equals("FR") ? $F{short_title-fr_FR} + " " + ($F{baseline-fr_FR}!=null?$F{baseline-fr_FR}:"") : ( $P{taal}.equals("DE") ? $F{short_title-de_DE} + " " + ($F{baseline-de_DE}!=null?$F{baseline-de_DE}:"") : $F{short_title-en_US} + " " + ($F{baseline-en_US}!=null?$F{baseline-en_US}:"") )))

Hi, I have an excel file that contains a few columns with article descriptions like short_title_NL,short_title_EN, short_title_DE I want to generate a report in the language that a user has chosen via a prompted parameter. e.g. the user types in NL for the variable Language, and the chosen column to display in the report would be the description in dutch, so the field short_title_NL would have to be printed. I've tried to create a text field like this: $F{"short_title_" + P{Language}} in the hope that it would evaluate to $F{short_title_NL} But I get the error 'Field not found: "short_title_" + P{Language --- net.sf.jasperreports.engine.design.JRDesignExpression Can someone point me in the right direction? Please bear in mind that this is an excel file. Thanks, Tom