francesco334

Hello, I use iReport to generate my report mail. I have a problem with a text filed that contains a description that is too large. iReport, truncate this text field. I've attacched the 2 jrxml : (main.jrxml and comment.jrxml). The second is called by main.jrxml in the "DetailOptHeader" band. I've attacched also the xml (that is the source data xml of the report). The tag related to the text field (of Comment.jrxml) is the tag "Comment" : ...<Comment CommentOriginatorCode="0"> <Text>Visiterete sei attrazioni di New York City ad una tariffa incredibilmente bassa! Include i biglietti per l'Osservatorio dell'Empire State Building (ingresso all'ottantaseiesimo piano e ad un audio tour), il Museo Americano di Storia Naturale (include il Rose Center for Earth ......n finesettimana o una settimana!</Text> </Comment> My report result is this, where you can see that the descripion is truncated : ... Servizio 1 *** ESCURSIONE *** Data Escursione : 02/08/2011 Destinazione : New York (STATI UNITI ) Dettaglio Escursione : <b>Descrizione </b>: Visiterete sei attrazioni di New York City ad una tariffa incredibilmente bassa! Include i biglietti per l'Osservatorio dell'Empire State Building (ingresso all'ottantaseiesimo piano e ad un audio tour), il Museo Americano di Storia Naturale (include il Rose Center for Earth and Space ed uno Spettacolo Spaziale Hayden Planetarium), il Museum of Modern Art (MoMA), il Metropolitan Can you please help me? It's urgent for us. Thanks & Regards, Francesco

Hello, Can I invoke an axis WebServices (xml SOAP) from iReport? If yes, how can I make this? Is there any example or tutorial? Thanks, Francesco

Hello, I've a strange problem when I call my iReport app, from my java code. This is the code: " String reportFileName= this.URL_JASPERFILES + "mail/AirServices.jasper"; String outFileName = url+"/" + sPnrBasket + "_operativo" + ".txt"; this.logger.debug("RenderDocumentRQ WS: nome reportFileName: " + reportFileName); JRXMLDataSource jrxmlds = new JRXMLDataSource(xmlFileName,recordPath); HashMap hm = new HashMap(); Connection conn = getConnection(); hm.put("subreportDS",conn); hm.put("SUBREPORT_DIR", this.URL_JASPERFILES + "mail/"); this.logger.debug("RenderDocumentRQ WS: setto parametri connesione SUBREPORT_DIR: " + this.URL_JASPERFILES + "mail/"); try { JasperPrint print = JasperFillManager.fillReport( reportFileName, hm, jrxmlds); ... " I have Tomcat installed on d: partition on my pc, and when I run the app I have: " 16:07:54,560 DEBUG otalogger:2401 - RenderDocumentRQ WS: nome reportFileName: D:Tomcat 5.5webappsDocumentBookServiceWEB-INFclassesReportmail/AirServices.jasper java.net.MalformedURLException: unknown protocol: d at java.net.URL.<init>(Unknown Source) at java.net.URL.<init>(Unknown Source) at java.net.URL.<init>(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEntity(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source) at javax.xml.parsers.DocumentBuilder.parse(Unknown Source) at it.businesslogic.ireport.connection.JRXMLDataSource.<init>(JRXMLDataSource.java:30) at it.eminds.ws.report.DocumentBookServiceWs.mailBasket(DocumentBookServiceWs.java:2403) at it.eminds.ws.report.DocumentBookServiceWs.RenderDocumentRQ(DocumentBookServiceWs.java:302) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:388) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:283) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286) at java.lang.Thread.run(Unknown Source) " If I change the path of my xml file (to pass to iReport) in c:(mydir) .. all works! Can u helpme? Thanks & Regards, Francesco

But I need variable because I must show the variable on Summary band, and the value is not a simple string, but I must concatenate a string field in the detail band, and show the variable value in summary band. So, the parameter with only @ID is showed in my report. Is not that the problem. If I show the filed value on the detail band it appear well. If I want show that value on summary band it appear null. Seems that doesn't add string value (of detail band) into the variable. I haven't any idea! Francesco

hello, all is set as you wrote me. But nothing..the value is null. I don't understand 1 thing : - if I declare the Variable a Double, I set "Variable class type=Double" and Calculation Type="Sum" and "Variable expression=new Double (Double.parseDouble($F{SINVOICENUMBER}))" - if I declare the Variable a String, I set "Variable class type=String" and Calculation Type="Nothing" and "Variable expression=$F{SINVOICENUMBER}" In the first case, I can see the value of the variable (in double) on the exported report. In the other case I have always NULL. I think I wrong to assign the string value of the field $F{SINVOICENUMMBER} to the variable. Because if Double works, it means that iReport can read the field $F{SINVOICENUMBER} correctly. Can anyone help me?? I have noone idea! Thanks..Francesco

Hello, I've some problem to concatenate a String! I have just concatenate a Double fieldand all works. But with String it doesn't works. I have a DetailHotel band where there is the field $F{SINVOICENUMBER} that appear correctly, in the hoteldetail band when I create the pdf. Then, I have created a variable "VINV" that has this expression : $F{SINVOICENUMBER}.equals($F{INVOICENUMBER}) ? "ciao" : "NO" and I've put this variable on the Summary band. When I export the pdf, the value of this variable is always "null". I don't understand why? In my variable, I have set: Variable.Class type=String Reset Type=Report Calculation type=nothing Increment Type=None Where I wrong?? As you'll note seeing the other variables, I've just sum the double value correctly! I send the Fattura.jrxml, xml data source and the pdf result, in the zip file. Thanks in advance, Francesco [file name=Fattura-67252e547aaa54e87df130fe25516257.zip size=9475]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Fattura-67252e547aaa54e87df130fe25516257.zip[/file]

Hello, I've some problem to concatenate a String! I have just concatenate a Double fieldand all works. But with String it doesn't works. I have a DetailHotel band where there is the field $F{SINVOICENUMBER} that appear correctly, in the hoteldetail band when I create the pdf. Then, I have created a variable "VINV" that has this expression : $F{SINVOICENUMBER}.equals($F{INVOICENUMBER}) ? "ciao" : "NO" and I've put this variable on the Summary band. When I export the pdf, the value of this variable is always "null". I don't understand why? In my variable, I have set: Variable.Class type=String Reset Type=Report Calculation type=nothing Increment Type=None Where I wrong?? As you'll note seeing the other variables, I've just sum the double value correctly! I send the Fattura.jrxml, xml data source and the pdf result, in the zip file. Thanks in advance, Francesco [file name=Fattura-c03c680563cf3b27a161942f2012d37a.zip size=9475]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Fattura-c03c680563cf3b27a161942f2012d37a.zip[/file]

I have tried to split a detail band assigning $V{REPORT_COUNT}. If I create my new Group, and I want to split this, what I must assign to the group splitted?? Ex. MyGroup = "Booking" Expression=$F{BookingId} (my field) my splitted Group="Booking1" Expression=??? Thanks, Francesco P.S: i send you my xml datasource. [file name=ULMT0600000245_15fir265r62ew.xml size=12752]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/ULMT0600000245_15fir265r62ew.xml[/file]

Hello, I have a problem in my report when I try to split a group (that is not a Detail band) named "BookingFooter" created by myself! The main report is "AirServices.jrxml" and the subreports that gives me space problems are "FulFillment.jrxml" and "ProfilesFatt.jrxml". Can you help me? Thanks, Francesco [file name=mail-ff9d6d04fd8d4b43ace7312d0bd0e627.zip size=82681]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/mail-ff9d6d04fd8d4b43ace7312d0bd0e627.zip[/file]

Hello, when I try to export a report to Excel format, it add me always a column that I haven't add in report. So.. the problems are 2 : 1) in exported excel iReport adds the column "C" as you can see by "test.xls". 2) When a field or Textfield is too long, iReport adds two column for that field. How can I solve these problems? Thanks for all your response. Francesco P.S. I have sent a zip file containing jrxml,xml and xls file. [file name=Test.zip size=9989]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Test.zip[/file]

Hello All, I have the necessity,in iReport, to Sum much Variables or Fiels. It seems simple,with the Sum function of iReport,but my problemis this: 1)In the Details Band, I must Sum all the Amount (that can be stay in field BaseAmount or in field TaxAmount in case of Tax="True" or Tax="false") setting the value of the Amount field in a Variable "Total". 2) Then I'll show the value of Total, in the Summary band! How can I do??? I send you the jrxml and xml. Thanks for all your response! Francesco [file name=Fattura.zip size=9817]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Fattura.zip[/file]

Then CBox, if I try to reduce the height of detail band (with all the subreport in that band) I have this error when I export to pdf or txt : net.sf.jasperreports.engine.JRRuntimeException: Subreport overflowed on a band that does not support overflow. at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:1112) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:1203) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:1228) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:613) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) How can I do??? my problem is that when I add a subreport, the follow StaticText object is not written after the end of the subreport! Even if I change the PositionType=FLOAT the problem remain! Thanks, Francesco

Hello, thanks for your responses.... but.. I have tried to set PositionType=FLOAT, but that doesn't change much in my report. The empty space remain! A thing that I don't understand is why, if I add a subreport on a line, and I add a staticText on the second line of my report, when I export to pdf, the StaticText is overgrown by the subreport lines!!! How can I do for write Static text after the end of a subreport???!! Thanks for all, Francesco

Hello All, I have read many scripts in this forum about this problem! I have this problem in export report in txt file and pdf file. I have tried to make, from iReport, "Remove line when blank", and some blank lines have been deleted. But there is always some blank space, that I don't understand why!! I send you a zip containing txt file and the jrxml for to see the difference between report and exported file! I hope that anyone can help me!! Thanks, Francesco [file name=mail.zip size=5513]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/mail.zip[/file]

this is the xml. Database is a simple table! [file name=SearchBasketRS.xml size=25849]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/SearchBasketRS.xml[/file]

Hello all, every times that I add a subreport in my main report, I have some problems: 1) the left margin of subreport doesn't equal to the left margin of the main report. How can I set left margin of subreport to the same left margin of main report?? 2) If subreport has repeated values, it add empty rows to the main report!! How can I do to solve this problem? I don't understand if I wrong in the subreport or in the main report! 3) Then, even in the same main report, in the detail band, when I repeat a block of data, it add much blank rows to the pdf!! (services like Hotel, Air, Insurance in my zip file example) I send you a zip, with the main ("AirServices") and subreport files jrxml (like "ProfilesFatt" in the Booking footer), and the pdf result! Thanks for all your response! Francesco [file name=Riepilogo.zip size=63918]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Riepilogo.zip[/file]

Thanks for your help Gulio, are u italian? if yes I'll speak in italian language! So..in java code, how can I pass the parameter to ireport? Can you please write me an example? I have this code : ... String xmlFileName = "c:/SearchBasketRS.xml"; String recordPath = "/SearchBasketRS/Baskets/Basket/Services/Service"; String outFileName = "C:\Fattura.pdf"; JRXMLDataSource jrxmlds = new JRXMLDataSource(xmlFileName,recordPath); HashMap hm = new HashMap(); try { JasperPrint print = JasperFillManager.fillReport( reportFileName, hm, jrxmlds); JRExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,outFileName); exporter.setParameter(JRExporterParameter.JASPER_PRINT,print); exporter.exportReport(); System.out.println("Created file: " + outFileName); } catch (JRException e) { e.printStackTrace(); System.exit(1); } catch (Exception e) { e.printStackTrace(); System.exit(1); } Then, in iReport I have created new parameter : MY_JDBC_CONNECTION and I must only add that code in the value of parameter. Right? Thanks, Francesco

Thanks for your help Gulio, are u italian? if yes I'll speak in italian language! So..in java code, how can I pass the parameter to ireport? Can you please write me an example? I have this code : ... String xmlFileName = "c:/SearchBasketRS.xml"; String recordPath = "/SearchBasketRS/Baskets/Basket/Services/Service"; String outFileName = "C:\Fattura.pdf"; JRXMLDataSource jrxmlds = new JRXMLDataSource(xmlFileName,recordPath); HashMap hm = new HashMap(); try { JasperPrint print = JasperFillManager.fillReport( reportFileName, hm, jrxmlds); JRExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,outFileName); exporter.setParameter(JRExporterParameter.JASPER_PRINT,print); exporter.exportReport(); System.out.println("Created file: " + outFileName); } catch (JRException e) { e.printStackTrace(); System.exit(1); } catch (Exception e) { e.printStackTrace(); System.exit(1); } Then, in iReport I have created new parameter : MY_JDBC_CONNECTION and I must only add that code in the value of parameter. Right? Thanks, Francesco

Hello all, Is possible in iReport to have 2 different datasource?? I have need that my main report have xml datasource, and my subreport have SyBase DB datasource. Can anyone show me, how to config the subreport connections and other parameter to work good! I have not problem with xml datasource in main report. But when main report calls a subreport (with Sybase datasource) I have error in deploy!! Can anyone helpme?? More details there are in post : "Report and Subreport with diferent datasource "

Hello, I have my "main" report with XML datasource. I want to call a subreport that have SQL datasoure. I have read previous post of jesteve, but when I export my main report in txt format, by java code, I have this error : java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(Unknown Source) I have create in iReport a parameter with value : java.sql.DriverManager.getConnection("jdbc:sybase:Tds:192.168.0.12:2638/lmt ", "user", "password") I think that the problem is the driver_name. Where I must define it in the parameter iReport?? The files jar of JDBS of Sybase have been copied into lib directory and works fine, testing they from "Connection property" of iReport. this is instead the java code, that deploy the report: String xmlFileName= "c:/basket/SearchBasketRS.xml"; String recordPath = "/SearchBasketRS/Baskets/Basket/Services/Service"; String reportFileName = "C:\Airservices.jasper"; String outFileName = "C:\Airservices.txt"; JRXMLDataSource jrxmlds = new JRXMLDataSource(xmlFileName,recordPath); HashMap hm = new HashMap(); try { JasperPrint print = JasperFillManager.fillReport( reportFileName, hm, jrxmlds); JRExporter exporter = new JRTextExporter(); Thanks for all your response. Francesco This is the previous POST of Juan Carlos Esteve of 14/09/2005: " By: Juan Carlos Esteve - jesteve RE: Report and Subreport with diferent datasource 2005-09-14 05:03 OK, I found one solution.... First, create a new parameter... Parameter Name: subreportDS (for example..) Parameter class tipe class: java.lang.Object Default value expresion: java.sql.DriverManager.getConnection("jdbc:oracle:thin:@host:1521:dbname", "user", "password") Then... in the subreport dialog ... at "Connection / Datasource expresion" choose "Use connection expresion" and in the texbox... $P{subreportDS} (the parameter name created) Compile and test Bye "