Aristide

There is may be a bad solution that is : 1) create a variable "MyTotal" in your report that calculate the sum 2) create a subreport with a parameter map expression that send MyTotal in your subreport as a parameter 3) in the query of your subreport use a request like : SELECT amount_to_words(MyTotal) As MyTotalToWord Best solution - I think - would be to re-create your function in java and use it in ireport/jasperreport

Hi Giulio, If you don't have time enough for the new implementation of barcode, then just go back to the "old barbecue" !!!! We just need the barcodes ... Thanks

Hi, Same problem for me. I've got a industrial application printing labels for logistic. If I don't have Barcode Support I must stay at the 2.0.5 version. thanks for telling us ...

What is the database you are using (ORACLE, SQL server, ...)?

It's a little like adding JTextField on a JFrame in swing. The simpliest is to look at the example in "Demo" directory of JasperReport. See "demosamplesnoxmldesignNoXmlDesignApp.java" Examine the method : "private static JasperDesign getJasperDesign" especialy see some code like : Code: field = new JRDesignField(); field.setName("FirstName"«»); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); When you see the whole code, you understand that you have to get the section as desingsection, then construct a field as designfield and after add your field to the desing section. It takes time but it worth it regards

Thank you very much, it works ... :laugh: By the way, I didn't knew that it was possible to use an interface in this way.

Hi, If it works with less rows, it is may be possible to split the total recordset (6000 ...) in several recordsets between 500 and 1000 rows that you manage to put into a subreport. For example if there is a date column or a client acount column in your recordset you could do as folow : 1) I suppose : - table name is "MyTable" - a field (column) in this table has name "ClientAcount" 2) create a main report with a SQL command like SELECT DISTINCT ClientAcount FROM MyTable 3) insert your actual report as subreport of the main report in the detail section 4) connect main and subreport through the parameters with value $F{ClientAcount} (see documentation for main and subreport) Your database (Oracle) will recieve several little queries (one for each ClientAcount) instead of one big query. So I suppose it doesn't need so much ressources ...

Hi, In an earlier version of JasperReport I was constructing my report with java. So I was constructing a JRDesignTextField with borders like this : Code: JRDesignTextField Jrdtf = new JRDesignTextField(); Byte b = Byte.valueOf("5"«»); Color c = new Color(-16777216); Jrdtf.setLeftBorder(b); Jrdtf.setLeftBorderColor(c); Jrdtf.setRightBorder(b); Jrdtf.setRightBorderColor(c); Jrdtf.setBottomBorder(b); Jrdtf.setBottomBorderColor(c); Jrdtf.setTopBorder(b); Jrdtf.setTopBorderColor(c); now, I am using version 2.0.5 and get warnings that the methods setLeftBorder, setRightBorder are deprecated. :( The documentation tells me to use JRBaseLineBox. But this is a class and not a method.:evil: So I have really no idea of how to set a border to a JRDesignTextField. If somebody could show me through a code sample I would be thankfull. :)