aubrey.offer

I found the same solution, i have also refined it a bit. For A4 paper landscape, using Courier new (8), I am using the following settings which seem to work (Still to test the actual printing of the file) character Width 0, Character Height 0, Page width 175, page height 29. Hope this helps.

I am having a problem printing a report in text. The internal viewer shows the report correctly, and can be sent to the printer correctly. When I try and create the the text file in the previewer selection, and run the report I get an error. What are the settings for Courier new (8) if I am to set the pixel width and height of the characters as well as the page width and height in characters in the Export options? (who knows this stuff) How can I export text reports? This is now critical, as a complete project reports are about to be a waste of time. This did work, without any settings being set, then on reinstallation in now doesn't. I have stripped out all JAVA and iReports. cleaned registries and then reistalled JAVA and am still getting the same result. Please help. Regards Aubrey

not yet, I am trying to remove all traces of java and iReports and start again. Would be nice if we could find out how it picks up the formatting from the internal previewer and sets them in the export options.

Hi When I run a report where preview is set to text or text(ireports) it generates the report correctly, but the file exported is blank. iReports generates all other formats, but the text preview and the text(iReports) preview with return an error... If I try and insert values for the width and height (options, export options) I get output, but it is very largely spaced report. the default option for the export options is 0, but this returns the following error. Help please!! Exporting Text (JasperReports) to file... C:SubversionWMS_ReportstrunkreportsUnapproved_Orders_Report.txt! Error exporting print... Character width in pixels or page width in characters must be specified and must be greater than zero. net.sf.jasperreports.engine.JRException: Character width in pixels or page width in characters must be specified and must be greater than zero. at net.sf.jasperreports.engine.export.JRTextExporter.setReportParameters(JRTextExporter.java:271) at net.sf.jasperreports.engine.export.JRTextExporter.exportReportToWriter(JRTextExporter.java:333) at net.sf.jasperreports.engine.export.JRTextExporter.exportReport(JRTextExporter.java:221) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:1174) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Export running time: 15 Any assistance will be greatly appriciated. regards Aubrey

Thank you. Will look into this Ad Hoc Reporting.

Thanks for your input, it is appreciated.

Can end users use iReport if they don't know SQL, PL/SQL? As I have been tasked to assess iReport as an enduser reporting tool. I would like to know if compared to Oracle's Dicoverer if the user who is not a developer (ie does not do SQL etc) can select simply the columns they require without knowing the structure of the data. Regards Aubrey

In PL/SQL try the listagg function. Used this to do something similar. If you have many columns, it may be quite complex. (Mine had only 8 fields and I created a script about 50 lines long. If you need an example let me know and I will try and help with the example that I have done. Regards Aubrey

firstly, click on the subreport, look at the properties palette, near the bottom is a parameters property. Add the parameters that you need. Keep the names exactly the same from the main report and the sub report... ie don't even change the case, if the subreport has the many COMPANY_ID as the field then the passed parameter must be COMPANY_ID, cannot be Company_ID ... Two different variables. Hope this helps. Regards Aubrey

Messed up 2 : remove the colon ... I find that if the colon is there, it fails. Hope this helps.

I can output all files except a txt file. If I set the format to text preview, I get the following error Exporting Text (JasperReports) to file... C:SubversionWMS_ReportstrunkreportsInventory_Transactions_Report.txt! Error exporting print... Character width in pixels or page width in characters must be specified and must be greater than zero. net.sf.jasperreports.engine.JRException: Character width in pixels or page width in characters must be specified and must be greater than zero. at net.sf.jasperreports.engine.export.JRTextExporter.setReportParameters(JRTextExporter.java:271) at net.sf.jasperreports.engine.export.JRTextExporter.exportReportToWriter(JRTextExporter.java:333) at net.sf.jasperreports.engine.export.JRTextExporter.exportReport(JRTextExporter.java:221) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:1174) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Export running time: 16 This is the other Text(iReports) preview Exporting Text (iReport) to file... C:SubversionWMS_ReportstrunkreportsInventory_Transactions_Report.txt! Error exporting print... net.sf.jasperreports.engine.JRPrintText.getTextAlignment()B java.lang.NoSuchMethodError: net.sf.jasperreports.engine.JRPrintText.getTextAlignment()B at com.jaspersoft.jrx.export.JRTxtExporter.layoutGrid(JRTxtExporter.java:419) at com.jaspersoft.jrx.export.JRTxtExporter.exportPage(JRTxtExporter.java:300) at com.jaspersoft.jrx.export.JRTxtExporter.exportReportToWriter(JRTxtExporter.java:289) at com.jaspersoft.jrx.export.JRTxtExporter.exportReport(JRTxtExporter.java:257) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:1174) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Export running time: 16 Any other format (other than the above formats) are fine. Any assistance will be greatly appriciated. Regards Aubrey

Hi Sanbez, Thanks for your efforts, this is what I have discovered as a workaround ... 1. If I make a subreport and pass in the parameters, I can get everything to work, on the condition that no calculated fields are on the MASTER report. 2. If the master report has calculated fields that are set to java.math.BigDecimal, then I can set this up as a subreport, that is put into a dummy Master report. Believe it or not this works :) 3. Or, if I change ALL the variables that are set as java.math.BigDecimal except the query its self to java.lang.double it works as long as I don't have a number with more than four decimal places. (######.####) Hope this helps you to help others as well. Thanks again. Aubrey

Hi Sanbez, All the variables, and fields and Text Fields in the report are set to java.math.BigDecimal. The Table fields are Number(16,4) on an oracle 11g database. I have made a sub report and tried to run it that way, but the same problem arises. If I change all values to integer, it works, but then the data is not correct as all the values are now displayed as integers as opposed to real numbers eg 161.255 will be shown as 161 and the totals will be the sum of the integer values, not the real values.

<?xml version="1.0" encoding="UTF-8"?> ]]></defaultValueExpression></p><p> </parameter></p><p> <parameter name="DESPATCH_WHSE" class="java.lang.String"></p><p> <defaultValueExpression><![CDATA[ "C:\Users\aubrey.offer\Documents\Reports\" select lh.company_id,</p><p> loh.recv_whse_code,</p><p> (select whse_desc</p><p> from inv_whses whses</p><p> where whses.whse_code = loh.recv_whse_code) Recieving_Whse,</p><p> loh.transacting_whse,</p><p> (select whse_desc</p><p> from inv_whses whses</p><p> where whses.whse_code = loh.transacting_whse) Despatch_Whse,</p><p> oh.actual_despatched_date,</p><p> loh.order_no,</p><p> loh.despatch_number,</p><p> lol.product_code,</p><p> ip.product_desc,</p><p> sdh.container_no,</p><p> im.move_from_location Loct,</p><p> lol.load_pqty Quantity,</p><p> lol.load_sqty Tons,</p><p> user</p><p> from lds_load_hdr lh,</p><p> lds_load_order_hdr loh,</p><p> ord_order_hdr oh,</p><p> lds_load_order_lines lol,</p><p> inv_movements im,</p><p> inv_products ip,</p><p> inv_whses iw,</p><p> SOR_DESP_HDR@Serenity sdh</p><p> where lh.load_id = loh.load_id</p><p> and loh.order_id = oh.order_id</p><p> and loh.load_order_id = lol.load_order_id</p><p> and lol.product_code = ip.product_code</p><p> and loh.load_order_id = im.ref_doc_id</p><p> and iw.whse_code = lh.whse_code</p><p> and oh.order_id = sdh.ordr_id(+)</p><p> and lh.load_type = 'XFER'</p><p> and lh.load_status = 'COMPLETED'</p><p> and oh.order_status = 'INTRANSIT'</p><p> and im.move_type = 'XFER'</p><p> and loh.recv_whse_code = $P{RECIEVING_WHSE}</p><p> and loh.transacting_whse = $P{DESPATCH_WHSE} $F{QUANTITY} 0 $F{TONS} 0 $F{QUANTITY} 0 $F{TONS} 0 $F{TRANSACTING_WHSE} $F{RECV_WHSE_CODE} Recieving Warehouse $F{RECIEVING_WHSE} $V{REC_TOTAL_QTY} $V{REC_TOTAL_TONS} Total for Recieving Warehouse $F{RECV_WHSE_CODE} Despatching Warehouse $F{DESPATCH_WHSE} $F{TRANSACTING_WHSE} Despatch Date Order No Despatch No Product Code Product Description Container Quantity Tons Total for Despatching Warehouse $V{DESP_TOTAL_QTY} $V{DESP_TOTAL_TONS} $V{COLUMN_COUNT} $P{RECIEVING_WHSE} $F{USER} $P{REPORT_CONNECTION} $P{SUBREPORT_DIR} + "Transfer_Order_in_Transit_Coversheet.jasper" Transfer Orders in Transit Report new java.util.Date() $F{ACTUAL_DESPATCHED_DATE} $F{ORDER_NO} $F{DESPATCH_NUMBER} $F{PRODUCT_CODE} $F{PRODUCT_DESC} $F{CONTAINER_NO} $F{QUANTITY} $F{TONS} "Page "+$V{PAGE_NUMBER}+" of" " " + $V{PAGE_NUMBER}

If I change ALL my variables (which should be java.math.BigDecimal) to integer this then works. The Problem is that the values pulled in (from an oracle database) are of the variable type number(16,4). Which should be java.math.BigDecimal according to the conversion of SQL to JAVA (unless this has changed) ... This means that my data is now not correct.