prsam

Do you find a solution? I have the same problem....and on a forum you can only find this: "Pass the datasource...." So if you don't know how too pass the datasource, I think, you should go to another report maker, because this forums are only for a pro members. prsam

Hi! I use IReport for creating jasper reports. But I have a big problem with a subreport. In IReport my report works fine and shows data also in a subreport, but when I run my report in a web app. i got this: net.sf.jasperreports.engine.JRException: Unable to get next record. at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:99) at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:856) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:774) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1106) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:763) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:669) . . . com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10120][10898] Invalid operation: result set is closed. As I understand it is problem with a datasource, because I use only one in main and in a subreport. I saw on forum that I should use a second datasource for the subreport, but I don't know how to do this! Can someone explain me how to do this? Thanks and regards Miro I use the latest IReport.

prsam wrote: Hi I create a report with a subreport in a detail band. The subreport has always 10 columns with a data. When I run only a subreport it looks OK - as I need to be. But when I start a report, the subreport put data in one to three columns, not in 10 as is designed in a subreport, and in a more rows as I wish to be... What am I doing wrong?:(

Hi I create a report with a subreport in a detail band. The subreport has always 10 columns with a data. When I run only a subreport it looks OK - as I need to be. But when I start a report, the subreport put data in one to three columns, not in 10 as is designed in a subreport, and in a more rows as I wish to be... What am I doing wrong?:( [file name=ireport1.gif size=32639]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/ireport1.gif[/file] Post edited by: prsam, at: 2007/06/11 11:55

I find out that when I use Code: FontKey key = new FontKey("ean13", false, false); //(String fontName, Boolean bold, Boolean italic) PdfFont font = new pdfFont("/fonts/ean13.TTF",BaseFont.IDENTITY_H,true); to generate a report for printing ean code it works on linux only if you: -use portrait orietation of the paper, -do not rotate the text of the ean13 code. Anything else will not work if you use font size more than 14 (for ean code). But I need higher size and landscape printig, because I need to print labels on A4 page... Can anyone help me?

Hi I have the same problems. I try also with the ean13.ttf. But when the font size is > 14 is not working any more under linux...

I post the same question on itext and I got the answer: That's a JasperReports issue. Now I try also with the barcode tool and I get the same thing: on linux is not working - I get only the barcode, the text under is missing.... Post edited by: prsam, at: 2007/03/27 10:26

I post the same question on itext and I got the answer: That's a JasperReports issue.

The image: [file name=ean13.jpg size=9445]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/ean13.jpg[/file]

Hi! I have a very strange problem! I made a report and I'm using ean13 font for barcodes: Code: FontKey key = new FontKey("ean13", false, false); //(String fontName, Boolean bold, Boolean italic) PdfFont font = new pdfFont("/fonts/ean13.TTF",BaseFont.IDENTITY_H,true); //(String pdfFontName, String pdfEncoding, Boolean isPdfEmbedded) fontMap.put(key,font); It is working normal on windows and I can use font size up to 24. But when I install web application on linux (rh 4) the report is doing strange things. On the same page it cut some barcodes the others are ok - see image. The max. size for ean13 font that is workin OK is 14, but I need at least size 18. Did someone have similar problems? Post edited by: prsam, at: 2007/03/21 08:27 Post edited by: prsam, at: 2007/03/21 08:28

Yes, I was asking about generating a pdf file based on a jasper reports - I put a wrong word in a question. But, I find a solution...

I need to open a PDF document with ean13.ttf font. If I used this: Code:FontKey key = new FontKey("ean13", false, false); //(String fontName, Boolean bold, Boolean italic) PdfFont font = new PdfFont("C:\WINDOWS\Fonts\ean13.TTF",BaseFont.IDENTITY_H,true); //(String pdfFontName, String pdfEncoding, Boolean isPdfEmbedded) fontMap.put(key,font); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRPdfExporterParameter.CHARACTER_ENCODING, "UTF-8"«»); exporter.setParameter(JRPdfExporterParameter.FONT_MAP, fontMap); JasperReport jasperReport = getCompiledReport(reportFileName); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, fontMap, conn); exporter.setParameter(JRPdfExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRPdfExporterParameter.OUTPUT_FILE_NAME, "C:\testean13.pdf"«»); exporter.exportReport(); I got the pdf document, but it is saved. How can I open this file directly? I tried several times, with differents code (generatePDFOutput, bytes...), but I never got what I need - the part with ean13.ttf font is always missing, I see only the letters and no ean13 code...