J_N

I am trying to make a report which consist of X x Y stickers. Detail band consists of X same fields. Fields 2..X have expression "new Boolean($P{REPORT_DATA_SOURCE}.next())" in "Print when expression", but fetched field value remains unchanged in whole detail band. Next() method works OK - next detail band starts after X positions. I only cannot make the fetched Field value properly respond to current rowset position. Any chance to get the Field value really 'right now' considering rowset position? Thanks.

My exploration went on and I ended in class net.sf.jasperreports.engine.util.DefaultFormatFactory on line format = NumberFormat.getNumberInstance(locale); locale is in both cases the same, but the resulting format is different. I can't go on further, because java.text.NumberFormat class ends in java runtime. The mystery remains.

I have number formatting problem - the same jasper report run on different PC stations, formats the number fields differently. - I did extensive search - traced the whole report from jasper source code and found out this - The problem lies in JRFillTextField.java class (jasperreports version 1.3.3), line 377: textFieldValue = format.format(textFieldValue); Few examples of textFieldValue variable (before calling format method, after on one station, after on other station): 1 -> 1.00 1,00 19047.6 -> 19,047.60 19047,60 All text fields have the same pattern #,##0.00 I wonder what can affect java.text.Format class, format method to behave like this.

Is it possible this ? : - To have one locale file (the same name as jrxml + locale extension, for example myreport_en.properties). When I don't find key there , go to one common locale file (arbitrary name, for example allreports_en.properties) and search the key there? Thanks.

It it possible to somewhat execute the ALTER SEESION command before SQL query from iReport? It is, when I call report from java code. I simply write conn.createStatement().execute("ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. '"); JasperPrint print = JasperFillManager.fillReport(report, parameters, conn); But if I want to do it from iReport I don't know how to do it. Please help. Thanks.

Because of problems of setting printer tractor paper dimesions (jasper classes ignore it), I would like to set page height dynamically. But height attribute is protected and I cannot find the right way to derive JasperReport class and set the value. Please help me, thanks.

How to post it as a BUG ? Post edited by: J_N, at: 2006/11/15 05:14

Printing from preview (via printer icon) do the same. Something's wrong somewhere in JR classes. JasperViewer.viewReport(print, true);

We print jasper reports this way: JasperPrint print = JasperFillManager.fillReport(report, parameters, connection); PrintService[] services = PrintServiceLookup.lookupPrintServices(null, null); PrinterJob job = PrinterJob.getPrinterJob(); DocFlavor flavor = DocFlavor.SERVICE_FORMATTED.PRINTABLE; // ?? PrintService service = services; // selected printer JRExporter exporter = new JRPrintServiceExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, print); exporter.setParameter(JRPrintServiceExporterParameter.PRINT_SERVICE_ATTRIBUTE_SET, service.getAttributes()); exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PRINT_DIALOG, Boolean.TRUE); exporter.exportReport(); Strange thing is that when we choose in Page Setup (an old Epson LX 400 printer) Tractor Feeder as Source and Folded 8.5x12" as Size, it still prints A4 size. It do the same, when printed from iReport's JRViewer. When exported and printed from Acrobat Reader or OpenOffice, all is OK. Does somebody have the same experience with tractor paper? Thanks.

I found out, that if I have 2 static text fields and one overlaps another, the one beneath is not generated when report is exported to excel. Is it a bug or is there some explanation ?

We call Jasper Reports from another application. We take over all printer settings (printer name, range, copies,...). But we can't select printer tray. Can anybody show us some example how to find out all avilable trays and select the one we choose (the one which was selected in another application ?

I am beginner in iReport, but I think I managed all the basic features such as manipulatong SQL by parameters, subreports, internationalization, running extrnal java code etc. I would like to learn more about these two features - Scriptlets and Subdatasets. Can some free tutorials or examples concerning these features be found somewhere? Thanks.

I have report with 4 subreports. It also uses external java class which retrieves data from database by report connection. When I run it from iReport, everything is OK. I also run it from small java application made in JDeveloper 10.1.3. When this line is processed JasperPrint print = JasperFillManager.fillReport(report, parameters, connenction); , whole application is aborted (in about 80% of cases) and dialog "Fatal Internal Error, Error code: I/EX399" is shown. I am not sure whether it is caused by Jasper or by JDeveloper. Has anybody seen this before too ?

I would like to know how the final SQL query (after substituting all parameters) look like. The result seems to have less pages than I would expect. Is it somehow possible (either from iReport or from java code) ? I tried intentionally damage the sql query, so I could see what's inside, but only "ErrorÂfillingÂprint... java.sql.SQLException:ÂORA-00900:Âinvalid SQL statement" is shown. Nothing helpful.

I would like to print report WITHOUT any dialog. Everything I want to pass as parameters - printer name, orientation, pages (from-to or list), copies. Some java code example would be welcomed. Thanks.