jenkins

Hello there, I would like to replace a list of special characters in case one or more appear in a text field. An example of the extended characters: äöü My expression looks like this: $F{Account}.replace( 'ä' , 'ae' ).replace( 'ö' , 'oe' ).replace( 'ü' , 'ue' ) As its certain that my list of extended characters will grow I would like to find a more elegant solution with an array. Any ideas how this can be impelmented in iReport?

I have basically solved this problem at the SQL level instead of at the text field expression level. The Account name is derived only from the field Surname taking up to the first 8 characters. For this I used: Select REPLACE(LOWER(LEFT(pePersons.`LastName`, 8)), ' ', '') AS Account If anyone has a better solution I'd be happy to hear it!

Hi there, In a nutshell: I would like to create a list of participants of an event. The list should contain at least the following 3 fields: Surname, Name and Account. Surname and Name are fields from the database whereas Account will be generated. The problem: The field Account should be lower-case and 8 characters long. Furthermore, it should be generated from the first 8 characters of Surname (and Name if Surname is too short). If anyone out there has already done something like this or knows how to go about it, help would be much appreciated!

In JasperServer 3.7 is there any difference between the menu options: view -> Reports and view -> Repository In 3.1 there was a clear difference!? cheers p

I've been running JasperServer with various reports on a test machine. Now that the "test phase" has been successful I plan to install JasperServer on an application server and port the reports from the test machine to this server. I want to test this process first. I've setup a test application server, installed JasperServer on it and its all up and running. Now, in iReport, I've added this new server to my Repository Navigator along side the original test machine and I though/hoped it would just be a matter of copying the reports from the test machine to the new server, which does not work. I was hoping to be able to move the reports without having to reconfigure all my input controls etc.. Any help with this matter would be much appreciated: moving reports from one server to another. Kind regards, pete

Found it alright, cheers!

Hi I've created a report with a subreport within it and was/am having problems with the formatting.. it looks terrible at the moment! I heard the using "Groups" is the way to go... went to click on the "Groups" Element on my Palette?? Not there! Looked in the menus, no joy. I have v3.1.3 & v3.5.0! Has the feature been discontinued?

Hi Matt, I have tried using the csv export (and will probably have to go with it), however, each record-block is packed between double-quote characters. I know its then just a matter of removing them but its quite possible that my exported fields also contain double-quotes, so I could only remove them at the start and end of the block.. its just an extra step which I'd like to avoid. Plus I'm not the end user. I'm exporting the following fields (surname, name, organisation, email address, institute, city, country) in the following format, so that they can then be inserted into a latex file: {\bf surname, name} & organisation\\ email address & institute\\ & city, country\\ & \\ With csv I get this (I tried it out on windows; I get the quotes and my new lines are ignored): "{\bf surname, name} & organisation\\ email address & institute\\ & city, country\\ & \\"

It would be pure genius if JasperServer had a plain text export. The simplest of things are often the most useful. Is there any non-commercial way (commercial: Aspose.Words) of implementing a txt export? Or might this be planned for a future release (I only read that OpenOffice ODF is in the pipeline)? Post Edited by jenkins at 10/08/2009 15:04

works like a charm, cheers!

I have the following two fields/variables in my report: $F{CostNeutral}: Field class: java.lang.Integer (0 or 1) $V{persondays}: Field class: java.lang.Integer (calculates the difference between two dates) I now want to enter a third field ($F{PD}: Field class: java.lang.Integer) with an if statement which should check the value in $F{CostNeutral} and then determine how to populate $F{PD}, i.e. with either "0" or "$V{persondays}". I have tried many variations of the following expression with no joy (still have to get up to speed on java!): $F{CostNeutral}.equals( "1" ) ? "0" : "$V{persondays}" Any help would be much appreciated!!

i'm in the process of designing a questionnaire that pulls data (which was entered online) from the database so that it can be printed and signed by the applicant in person. the on-line form has a number of check boxes which are represented as boolean data types in the database. my question: can check boxes be implemented in a report using ireport? e.g. database field = true; i get a ticked check box in my report!

I have installed iReport 3.5.0 on a German Linux OS. I would realy like to run iReport in English! Anyone know how to configure the required language for iReport? Thanks for your help!