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.

I found a better solution - distribute subreports as .jrxml and silmply compile them: JasperCompileManager.compileReportToFile("subreport.jrxml", "subreport.jasper"); And last problem would be to find out the complete list of subreports (and subreport's subreports) which the main report contains. Does exist some java method to extract this info from JasperReport or I must do it by text searching ".jasper" in .jrxml file?

I did exactly as you said and tried to run thus modified report from iReport, but no subreport was shown. Of course, because subreport is described as $P{subReport} and 'subReport' parameter has no default value. I cannot put there file name as String, because parameter class type is net.sf.jasperreports.engine.JasperReport and not String. So what now? I would like to see both ways working - iReport and Java code too. Post edited by: J_N, at: 2006/10/17 07:44

I have report with 2 subreports. I successfully run the report from java code. InputStream input=new FileInputStream(new File("MyReport.jrxml")); JasperDesign design = JRXmlLoader.load(input); JasperReport report = JasperCompileManager.compileReport(design); ... I found out, that I must deploy main file as .jrxml file and subreports as compiled .jasper files. There's no need having any reference to them from java code. But could it be possible to have subreports as .jrxml files too? What then java code should look like? Thanks.

The are field and static text next to each other, but they have the same height are are top aligned. Strange - I deleted field and created it again and now all is ok - vertical space is gone.

I have rather complex SQL query. I need for fetch another field (which isn't in the main query). Can I make a subdataset with a query like this select something from another_table where key = $F{field_in_main_query} and fetch the 'something' value for every row and put it on report ? Is it possible or must I construct some workaround? Thanks.

Yes I have. Fields disappered on condition, but empty space remained on the former place and height of band is the same. I can describe it this way, on detail band there are fields a and b: a show b hide a show b hide a show b conditionally show (for example after every 3 a rows) a show b hide a show ... And the result should be a a a b a a a b but is a _ a _ a b a _ a _ a

I conditionally hide a field but I would like to hide all 'line' the field is on. It means reducing the height of the whole band. I see there checkbox 'Remove line when blank' but it seems to do nothing. What I like in other reporting applications and missing in iReport is possibility of adding multiple bands. Each of this band can be hidden separately. The above problem then would be solved by adding new detail band, making a condition which was formerly in field and then putting the field alone on it. It would be nice to have this feature. Thanks in advance for any comments.