[Outputing a txt File]

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.

[Where are the settings that are used fro the internal previewer...]

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

 

[Outputing a txt File]

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.

[iReports not generating text files]

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

[Is iReport an enduser Tool?]

Thank you. Will look into this Ad Hoc Reporting.

[Is iReport an enduser Tool?]

Thanks for your input, it is appreciated.

[Is iReport an enduser Tool?]

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

 

[Horizontal Report Group Alignment]

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

[Passing field values between reports]

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

 

[how to fix UI bug?]

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

[Outputing a txt File]

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

[Cover Sheet]

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

[Cover Sheet]

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.

[Cover Sheet]

<?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}

 

[Cover Sheet]

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.

[Cover Sheet]

Hi All

I am trying to do what everyone else seems to do naturally :)

I want to have my title sheet as a cover sheet with the title of the report and the parameters used in the report.

If I remove the tick from the  property (title on new page)  this report runs, but the title page is on the same page as the report.

I have set thein the report parameter as ticked. This returns the error of 

Error filling print... java.lang.Integer cannot be cast to java.math.BigDecimal
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigDecimal 
    at net.sf.jasperreports.engine.fill.JRBigDecimalSumIncrementer.increment(JRBigDecimalIncrementerFactory.java:335) 
    at net.sf.jasperreports.engine.fill.JRAbstractExtendedIncrementer.increment(JRAbstractExtendedIncrementer.java:42) 
    at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:144) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:765) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:288) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) 
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Print not filled. Try to use an EmptyDataSource... 

[Looking for a Cross tab example - Newbie learning ... or trying to :)]

Thanks, am looking at that at the moment.

 

[Looking for a Cross tab example - Newbie learning ... or trying to :)]

[I am trying to write a report with horizontal and vertical totals across multiple fields]

Thanks Ajinkya.

 

 

[Missing toolbars ...]

Hi I have only just started to us iReports, so this may seem stupid, but all the tuts that I look at, have a toolbar. I Don't, I also don't have things like Crosstabs to access from the menu. I am running version 4.5.1

 Please help.... Thanks

 

 

[Jasper Reports vs Jasper iReport]

Thanks for this ... :)

 

[I am trying to write a report with horizontal and vertical totals across multiple fields]

 

I need to write a report in iReports that does the summation across the products (horizontally for two separate values) for various locations which have sublocations.

The Totals of the sumlocations is to be done vertically.

The Total for ALL the Locations is to be done at the end.

IS this possible in iReports … if so how?

I would assume that we are going to have three groupings.

The 1^st is the Locations

The 2^nd  is the subLocations.

The 3^rd is the products.

I assume that the Location Group header will have the Location field in it.

I assume that the Sublocation Group header will have the sublocation field in it.

I assume the products will be in the detail section

I assume the sublocation  Group footer will have the sublocation totals in it.

I assume the Location Group footer will have the Locations totals in it.

Where does one put the product totals in… as these are horizontal and not vertical?

Here is a general layout that I am trying to achieve.

 

LOCATION1

subLocation 1

HEADER1             HEADER2                             Totals                                     Totals

Code                      Product 1                               Product_total  1                    Product_total 2

Code                      Product2                                Product_total  1                    Product_total 2

etc

Sublocation  totals                                               SUM of PRODTotal 1          SUM of PRODTotal 2                         

 

SubLocation2

HEADER1             HEADER2                             HEADER3                             HEADER4

Code                      Product 1                               Product_total  1                    Product_total 2

Code                      Product2                                Product_total  1                    Product_total 2

etc

Sublocation  totals                                               SUM of PRODTotal 1          SUM of PRODTotal 2         

 

LOCATION2

subLocation 1

HEADER1             HEADER2                             HEADER3                             HEADER4

Code                      Product 1                               Product_total  1                    Product_total 2

Code                      Product2                                Product_total  1                    Product_total 2

etc

Sublocation  totals                                               SUM of PRODTotal 1          SUM of PRODTotal 2                         

 

SubLocation2

HEADER1             HEADER2                             HEADER3                             HEADER4

Code                      Product 1                               Product_total  1                    Product_total 2

Code                      Product2                                Product_total  1                    Product_total 2

Sublocation  totals                                               SUM of PRODTotal 1          SUM of PRODTotal 2         

 

LOCATION TOTALS                                           SUM of ALL ProdTotals1   SUM of ALL ProdTotals2   

[How do I create a Group in iReports 4.5.1]

Thanks, still new at this, but learning all the time.

 

[How do I create a Group in iReports 4.5.1]

I have looked at sample tuts for this and find that the tut is based on a version that looks nothing loke version 4.5.1

thanks