[jasperreports-questions] JasperViewer from a modal dialog wizard. How?
Hi, We've started using JasperReports a few days ago and have been very pleased at the product and our progress. However, I am currently struggling to provide a Print Preview of the report before the user confirms and actually prints. Currently I'm building a report Request for Quotiation. The user gathers some information in a Wizard, and has options such as Preview and Print before it finishes. The problem is that the Wizard is a modal dialog, so when we start the Report Viewer (a JFrame) - it does become visible, but we can't control it because all focus remains on the wizard. When we close the Wizard we can use the viewer to inspect the new document - however that is not very useful. I've considered creating HTML and displaying that in a browser, but I would prefer the native viewer to provide a more accurate representation of a printout. Are there any other options for providing a print preview from a modal dialog?? I thought about stealing the JPanel from the ReportViewer, and displaying that in a dialog - but that seems too extreme. Any suggestions are appreciated. Many thanks, -Damian --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid0709bid3057dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] trying to create a printable image from an AWTimage.
I have some that generates an AWTImage . I am trying to figure out how to convert into a format that I can print/display in a iReport created jasper report. I am sure that there is somthing in the mail lists but I cannot find it. (the downside of having a sucessful project is that there are lots of questions and it makes it hard to find just the right answer ) -- Alvin Starr || voice: (416)585-9971 Interlink Connectivity|| fax: (416)585-9974 [EMAIL PROTECTED] || --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] running many queries in a report?
Check out the Custom DataSource section, if there is any. Basically you need to implement the JRDataSource and do your stuff in there and return a collection of Maps. Jasper Engine will use that for the report rendering. Don't forget to declare Fields and Parameters as required. Regards, Raffi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dan Adams Sent: Monday, April 24, 2006 11:49 PM To: [EMAIL PROTECTED] Cc: jasperreports-questions@lists.sourceforge.net Subject: Re: [jasperreports-questions] running many queries in a report? Sorry, If I'm kind of new to this, but could you elaborate on getting the datasource to run the queries and put them in parameters? I have the jasper ebook and have read through it so I can reference that if need be. On Mon, 2006-04-24 at 11:03 -0700, Manfred Moser wrote: Dan Adams wrote: I have a report I want to do that, while it runs one main query, needs to run many other small queries where it really only cares about getting one result from the query (such as a count or average). How is this done without creating a ton of subreports that don't print anything and just return a result? You can just set parameters with these values. Just get your data source to run all the queries and put the results in different parameters. If you use subreports or not is a different issue. manfred -- Dan Adams Software Engineer Interactive Factory 617.235.5857 --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Hide a field based on the previous row
Adriano dos Santos Fernandes wrote: Andy Dines wrote: On the Common tab of the Date field's properties, untick the Print repeated values option. That works but have one big problem. My Date field is inside the detail, but the report have one group. When the first date of a group is equal to the last date of the previous group, the date not printed. Is there a way to solve that problem? Ops... I just solved that using Print when group changes. :-) Adriano --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Hide a field based on the next row
Hi! This is a similar problem of the other I post, but I need to show/hide a field based on the value of the next record. If the date field of the next record is equal to date of current record, I want to hide the remainder field. If the date field of the next record is different or if there isn't a next record, I want to show it. I'm solving that with a custom JRDataSource. Is there a way to do that directly? Adriano --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Charts: Show Integer Values
As far as I have been able to determine, all numeric axis values are converted to java.lang.Number values and you have no control over their format. Sorry! Andy -- View this message in context: http://www.nabble.com/Charts%3A-Show-Integer-Values-t1372652.html#a4002273 Sent from the jasperreports-questions forum at Nabble.com. --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] cell data in Excel reports
Try selecting the Stretch with overflow on the Text Field tab for the field's properties. The text wraps in the Excel cell, but you do get to see all of the data. Regards Andy -- View this message in context: http://www.nabble.com/cell-data-in-Excel-reports-t1468408.html#a4003233 Sent from the jasperreports-questions forum at Nabble.com. --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Hide a field based on the previous row
On the Common tab of the Date field's properties, untick the Print repeated values option. Regards Andy -- View this message in context: http://www.nabble.com/Hide-a-field-based-on-the-previous-row-t1454642.html#a4003472 Sent from the jasperreports-questions forum at Nabble.com. --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] export all cols of query (generic report)
Hi Is there anything like a export everithing in the result set report in jasper ? So i do not need to write a report template for every select * from TABLE_XYZ query ? We have some reports that just require export of tabular data to CSV or Excel and i would like to create a general report template that just exports all the columns/rows that are present in the datasource ? Is this possible ? if yes: how ? if no: can i do something about it J Thanks for your help and have a nice day. Greets from switzerland pascal
[jasperreports-questions] RE: Subreports problem
Hi Francisco, I also designed a report with two subreports embedded. Concerning your first problem with the Connection, I cannot say much, since my master report executed a query. And I guess, you already passed the connection via the connectionExpression to the subreport. Your second problem is that the two reports overlay? Or what do you mean with appear one under another? If I understood this right, it might help if you specifiy a positionType with value Float in the second subreport's reportElement, as you can see in the example code below. HTH, Marc !-- subreport for Domain -- subreport reportElement isPrintRepeatedValues=false x=0 y=20 width=325 height=20 isRemoveLineWhenBlank=true backcolor=#ffcc99/ subreportParameter name=parentId subreportParameterExpression![CDATA[$F{id}]]/subreportParameterExpression /subreportParameter subreportParameter name=DomainSubreport subreportParameterExpression![CDATA[$P{DomainSubreport}]]/subreportParameterExpression /subreportParameter subreportParameter name=TaxonomySubreport subreportParameterExpression![CDATA[$P{TaxonomySubreport}]]/subreportParameterExpression /subreportParameter subreportParameter name=parentColumn subreportParameterExpression![CDATA[fk_domain]]/subreportParameterExpression /subreportParameter subreportParameter name=indentation subreportParameterExpression$P{indentation}/subreportParameterExpression /subreportParameter subreportParameter name=level subreportParameterExpressionnew Integer(1)/subreportParameterExpression /subreportParameter connectionExpression![CDATA[$P{REPORT_CONNECTION}]]/connectionExpression subreportExpression class=net.sf.jasperreports.engine.JasperReport![CDATA[$P{DomainSubreport}]]/subreportExpression /subreport !-- subreport for Taxonomy -- subreport isUsingCache=false reportElement positionType=Float isPrintRepeatedValues=false x=0 y=40 width=325 height=20 isRemoveLineWhenBlank=true backcolor=#ffcc99/ subreportParameter name=parentId subreportParameterExpression![CDATA[$F{id}]]/subreportParameterExpression /subreportParameter subreportParameter name=TaxonomySubreport subreportParameterExpression![CDATA[$P{TaxonomySubreport}]]/subreportParameterExpression /subreportParameter subreportParameter name=parentColumn subreportParameterExpression![CDATA[fk_domain]]/subreportParameterExpression /subreportParameter subreportParameter name=indentation subreportParameterExpression$P{indentation}/subreportParameterExpression /subreportParameter subreportParameter name=level subreportParameterExpressionnew Integer(1)/subreportParameterExpression /subreportParameter connectionExpression![CDATA[$P{REPORT_CONNECTION}]]/connectionExpression subreportExpression class=net.sf.jasperreports.engine.JasperReport![CDATA[$P{TaxonomySubreport}]]/subreportExpression /subreport _ Diese Information ist ausschliesslich fuer den Adressaten bestimmt und kann vertraulich oder gesetzlich geschuetzte Informationen enthalten. Wenn Sie nicht der bestimmungsgemaesse Adressat sind, unterrichten Sie bitte den Absender und vernichten Sie diese Mail. Anderen als dem bestimmungsgemaessen Adressaten ist es untersagt, diese E-Mail zu lesen, zu speichern, weiterzuleiten oder ihren Inhalt auf welche Weise auch immer zu verwenden. Wir verwenden aktuelle Virenschutzprogramme. Fuer Schaeden, die dem Empfaenger gleichwohl durch von uns zugesandte mit Viren befallene E-Mails entstehen, schliessen wir jede Haftung aus. The information contained in this email is intended only for its addressee and may contain confidential and/or privileged information. If the reader of this email is not the intended recipient, you are hereby notified that reading, saving, distribution or use of the content of this email in any way is prohibited. If you have received this email in error, please notify the sender and delete the email. We use updated antivirus protection software. We do not accept any responsibility for damages caused anyhow by viruses transmitted via email. --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net
[jasperreports-questions] crosstabs-error
Am trying to use crosstabs for the first timeI get such an error .pls help me to resolve this error Errorfillingprint...net.sf.jasperreports.engine.JRException:Crosstabdatahasalreadybeenprocessed. atnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280) atnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634) atnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) atnet.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:730) atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:632) atnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) atnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) atnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) atit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674) atjava.lang.Thread.run(Thread.java:536)NESTEDBY:net.sf.jasperreports.engine.JRException:Crosstabdatahasalreadybeenprocessed. atnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280) atnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634) atnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) atnet.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:730) atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:632) atnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) atnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) atnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) atit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674) atjava.lang.Thread.run(Thread.java:536)NESTEDBY:net.sf.jasperreports.engine.JRRuntimeException:Errorincrementingcrosstabdataset atnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:638) atnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) atnet.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) atnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:730) atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:632) atnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) atnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) atnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) atit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674) atjava.lang.Thread.run(Thread.java:536)Causedby:net.sf.jasperreports.engine.JRException:Crosstabdatahasalreadybeenprocessed. atnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280) atnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634) ...12morePrintnotfilled.TrytouseanEmptyDataSource...! Regards,Vidhya.C Insurance Solutions Development CenterHCL ,Chennai - 600 034. "The future belongs to those who believe in the beauty of their dreams"-Eleanor roosevelt Disclaimer:The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its associates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you
Re: [jasperreports-questions] export all cols of query (generic report)
Wouldn't it be easier to use the source database application to generate the output in CSV format? It is also possible to create an Excel template that imports the data from the database into a sheet. Andy -- View this message in context: http://www.nabble.com/export-all-cols-of-query-%28generic-report%29-t1479472.html#a4005741 Sent from the jasperreports-questions forum at Nabble.com. --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Cross tab sample required
Dear Friends, Can anyone help me with a cross tab example.I want to use dynamic growing rows and columns but i dont know how to go along with crosstabs,the example given isnt working fine for me.please do sent me a sample.Thanks in advance. Regards,Vidhya.C
Re: [jasperreports-questions] A.2. Installing Appendix A. JasperReports Samples - LIB_JASPERREPORT
I don't use Ubuntu/Eclipse, but I do use Websphere/Rational which is based on Eclipse. A ClassPath variable (which, I think, is what you're referring to) is created under Windows/Preferences/Java/Build Path/ClassPath variables (at least, that's the location in Rational). Click the Add button and enter in LIB_JASPERREPORTS and find the file or location you want using the File or Folder buttons then click OK to add it and click OK to close preferences. You can now use LIB_JASPERREPORTS in your project. If you need to use this in another workspace, you should export your preferences and import them into the new workspace - the buttons to do this are on the preferences dialog. Regards Andy -- View this message in context: http://www.nabble.com/A.2.-Installing-Appendix-A.-JasperReports-Samples---LIB_JASPERREPORTS-variable-t1471815.html#a3982012 Sent from the jasperreports-questions forum at Nabble.com. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] PDF /XL export
Hi I am having 20 columns report. when I export to the PDF only 10 columns are visible in PDF file. Gridelines are not visble.. How this can be enabled? Is it possible to enable Horizondal scroll bar or Can we change the font size? Also In excel export, How to enable gridelines in the cell? Advanced thanks Looking forward your feedback. Thanks __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Re: with out memory filling big reports
a a wrote: hello i have solved my problem i don't know, but have changed the version of jasper to 1.2 and run perfect, but i have ohter problem o no problem question, when i call the method JasperFillManager.fillReportToFile( jasperReport, tmpFileLlenar.getPath(), parameters, ds ); this use a memory? when i call this with a small reports no problem but when i call with a big reports i have a java.lang.outOfMemory, i thought that this no have diference between small report and big reports how the fill is into a file not into a object in memory. fillReportToFile is nothing more than a shortcut method for filling a report in memory and then saving it into a file. Currently the fill process is not streamable, it always fills the whole report in memory (but when you use a virtualizer, part of that memory gets virtualized). This is because in the general case streaming is not possible (e.g. if you have page x of y on each page, even the first page is finished only after all the report has been generated). Therefore, if you have large reports to fill and not enough VM memory, you should use a virtualizer. some one know why? thanks alvaro tovar Regards, Lucian Chirita __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Novice - Help. (nearly) My first Jasper Report !!!
Hello, I'm constructing my first Jasper Report, and all is going quite well except I don't quite understand something. I have used iReports and successfully parsed and compiled our design. I have created a JRDataSource object that is ready to supply the data. I've got a map full of parameters ready to go. Now I want to use something like JasperPrint jp = JasperFillManager.fillReport(jasperReport, parameters, dataSource); The point I don't understand is how do I get the jasperReport After compilation withiReports I have various files such as BasicRFQ.jasper and various versions of BasicRFQ_11453453453_234234.java. Do I put one of these in a folder, and pick it up as a File and pass it as the jasperReport??? If possible, I want to place the jasperReport in a specific run time directory with other data files, and NOT inside the application's jar. It does not quite sound right. I'm sure I'm missing something simple. I've been scratching around all the samples but I have not discovered anything. I would appreciate any guidance. Thanks, -Damian --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Re: with out memory filling big reports
hello i have solved my problem i don't know, but have changed the version of jasper to 1.2 and run perfect, but i have ohter problem o no problem question, when i call the method JasperFillManager.fillReportToFile( jasperReport, tmpFileLlenar.getPath(), parameters, ds ); this use a memory? when i call this with a small reports no problem but when i call with a big reports i have a java.lang.outOfMemory, i thought that this no have diference between small report and big reports how the fill is into a file not into a object in memory. some one know why? thanks alvaro tovar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] Re: with out memory filling big rep orts
Hi, My suggesstion is to implement the JRDataSource and do some paging mechanism in the next() and getFieldValue() methods instead of fetching all the records at a time. Or there might me some configuration in JasperReports itself to setup the fetch size and which in turn does a paging. I am not sure about the second option. Regards, Raffi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of a a Sent: Wednesday, April 19, 2006 12:36 AM To: jasperreports-questions@lists.sourceforge.net Subject: [jasperreports-questions] Re: with out memory filling big reports hello i have solved my problem i don't know, but have changed the version of jasper to 1.2 and run perfect, but i have ohter problem o no problem question, when i call the method JasperFillManager.fillReportToFile( jasperReport, tmpFileLlenar.getPath(), parameters, ds ); this use a memory? when i call this with a small reports no problem but when i call with a big reports i have a java.lang.outOfMemory, i thought that this no have diference between small report and big reports how the fill is into a file not into a object in memory. some one know why? thanks alvaro tovar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Excel format
Dear All, Am using subreports in my reports but those subreports are not getting displayed in excel,i hav etried my maximum in aligning ,still the subreport part doesnt get displayed.Kindly help on this regard. Regards,Vidhya.C "The future belongs to those who believe in the beauty of their dreams"-Eleanor roosevelt
Re: [jasperreports-questions] troubles with version 1.2.1
Remove or rename your config file (userhome/.ireport/config.xml). I think the problem comes with your Look and Feel. Giulio Il Togno wrote: Hi, I just downloaded the latest iReport version (1.2.1), but I have problems starting it. Running iReport.bat I have nullPointerException at com.digitprop.tonic.SplitPaneDivider.oneTouchExpandableChanged (SplitPaneDivider) Till today, I haven't problems with previous versions. Any suggestion? Thanks. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] please help its urgent
hii am working with jasper report but when i compile it i get some errorsthe errors areApr 12, 2006 10:38:18 AM org.apache.commons.digester.Digester getParserSEVERE: Digester.getParser: org.xml.sax.SAXNotRecognizedException: Feature: http://apache.org/xml/features/validation/dynamic at org.apache.crimson.parser.XMLReaderImpl.setFeature (XMLReaderImpl.java:219) at org.apache.crimson.jaxp.SAXParserImpl.setFeatures(SAXParserImpl.java:150) at org.apache.crimson.jaxp.SAXParserImpl.init(SAXParserImpl.java:133) at org.apache.crimson.jaxp.SAXParserFactoryImpl.newSAXParserImpl (SAXParserFactoryImpl.java:113) at org.apache.crimson.jaxp.SAXParserFactoryImpl.setFeature(SAXParserFactoryImpl.java:141) at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java :185) at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138) at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71) at org.apache.commons.digester.Digester.getParser(Digester.java:692) at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899) at org.apache.commons.digester.Digester.parse( Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load (JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.engine.JasperManager.loadXmlDesign (JasperManager.java:971) at spym.member_ledger.show_report_button_actionPerformed(member_ledger.java:252) at spym.member_ledger_show_report_button_actionAdapter.actionPerformed(member_ledger.java:502) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl (Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent (Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl (Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents (EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)java.lang.NullPointerException plese get me some results that really helps meyou can reply me at [EMAIL PROTECTED]
Re: [jasperreports-questions] text rotation
Hi, This is not yet possible in JR. Thank you, Teodor Johan Andries wrote: Hi all, Can anyone give a clue about how to rotate text to non-standard angles (other than NONE, LEFT or RIGHT), e.g. 70 degrees clockwise, without having to mess with the iText classes in Javacode? Checked the documentation, samples, Google, but couldn't find any clues - besides messing with iText directly.. Any help would be greatly appreciated, kind regards, Johan --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] calculations and initial values on variables
Hi, This is not a bug. Or at least it was meant for it to work this way. The initial value for the variable is not part of the series. That initial value is used by the engine to display instead of null, before the calculations begin. If you want the -15 to be subtracted, you should make the subtraction part of the text field expression or use an additional variable. I hope this helps. Teodor Justin Lee wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 This seems like a bug to me, but perhaps someone can tell me what I'm doing wrong. Say I want to sum up a sales ticket with a discount of $15. I declare a variable of calc type sum on the price field with an initial value of -15 (new Double(-15)). If I print that variable in the column header, it correctly shows -15. But when I print it in the detail band, it shows the price of the first item. that is, it resets that variable to 0 and adds the first price. Subsequent sums correctly show the sum of the prices but still without the -15 added in. Here's how I'm declaring it when it's *not* working: variable name=total class=java.lang.Double resetType=Page calculation=Sum variableExpression![CDATA[$F{price}]]/variableExpression initialValueExpression ![CDATA[new Double(-15)]] /initialValueExpression /variable To correctly sum this column with the $15 discount, i had to declare my variable like this: variable name=total class=java.lang.Double resetType=Page calculation=Nothing variableExpression ![CDATA[$V{total} + $F{price}]] /variableExpression initialValueExpression ![CDATA[new Double(-15)]] /initialValueExpression /variable Now that's extremely non-intuitive. Any ideas what I'm doing wrong? Or is that really a bug? - -- Justin Lee http://www.antwerkz.com AIM : evan chooly Skype : evan chooly -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2.1 (Cygwin) iD8DBQFENUm+JnQfEGuJ90MRA5QaAKDLvUueBMl4otXQAo3vKHVJSO/G0wCfdUDP oVGYrwntvFdfVj5YlZSHcfo= =Asvg -END PGP SIGNATURE- --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] calculations and initial values on variables
Unfortunately the documentation is a little thin on this subject. In fact the documentation would lead one to believe that using the initial value expression would do exactly what Justin expected (from the online tutorial): variable name=QuantitySum class=java.lang.Double resetType=Page calculation=Sum variableExpression$F{Quantity}/variableExpression initialValueExpressionnew Double(0) /initialValueExpression /variable Our variable will be initialized with zero at the beginning of each new page. perhaps this should be amended to include the little tidbit that any initial value will be tossed away when the first variableExpression is evaluated. -jason On Apr 10, 2006, at 8:45 AM, Teodor Danciu wrote: Hi, This is not a bug. Or at least it was meant for it to work this way. The initial value for the variable is not part of the series. That initial value is used by the engine to display instead of null, before the calculations begin. If you want the -15 to be subtracted, you should make the subtraction part of the text field expression or use an additional variable. I hope this helps. Teodor Justin Lee wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 This seems like a bug to me, but perhaps someone can tell me what I'm doing wrong. Say I want to sum up a sales ticket with a discount of $15. I declare a variable of calc type sum on the price field with an initial value of -15 (new Double(-15)). If I print that variable in the column header, it correctly shows -15. But when I print it in the detail band, it shows the price of the first item. that is, it resets that variable to 0 and adds the first price. Subsequent sums correctly show the sum of the prices but still without the -15 added in. Here's how I'm declaring it when it's *not* working: variable name=total class=java.lang.Double resetType=Page calculation=Sum variableExpression![CDATA[$F{price}]]/variableExpression initialValueExpression ![CDATA[new Double(-15)]] /initialValueExpression /variable To correctly sum this column with the $15 discount, i had to declare my variable like this: variable name=total class=java.lang.Double resetType=Page calculation=Nothing variableExpression ![CDATA[$V{total} + $F{price}]] /variableExpression initialValueExpression ![CDATA[new Double(-15)]] /initialValueExpression /variable Now that's extremely non-intuitive. Any ideas what I'm doing wrong? Or is that really a bug? - -- Justin Lee http://www.antwerkz.com AIM : evan chooly Skype : evan chooly -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2.1 (Cygwin) iD8DBQFENUm+JnQfEGuJ90MRA5QaAKDLvUueBMl4otXQAo3vKHVJSO/G0wCfdUDP oVGYrwntvFdfVj5YlZSHcfo= =Asvg -END PGP SIGNATURE- --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] custom export format
Hi I am new to jasperreports. We have a custom (almost) XML format which we need to support for export. I found out i can write a JRExporter implemention but dont know how i can plug it in ? how do i select this export format ? Thanks for your help pascal
[jasperreports-questions] help
help Mit freundlichen Grüßen / Best regards Quirin Maier Softwareentwicklung PCM / Software Development PCM / IT 141 Lisa Dräxlmaier GmbH Landshuter Str. 100 D-84137 Vilsbiburg phone: +49 87 41 47-14 97 fax: +49 87 41 47-17 56 mailto:[EMAIL PROTECTED] http://www.draexlmaier.de
Re: [jasperreports-questions] [ANN] JasperServer 0.9.0 released
Hello, Manfred We hope that this new open source product will solve many of the issues that existing JasperReports users have faced along the way. The most common was the lack of infrastructure around JasperReports as a library so that reporting functionality be readily available to end users. We think that JasperServer will close this gap and be useful to the community. As usual, feedback and contributions are always welcomed. This is what open source is all about. Thank you, Teodor Manfred Moser wrote: Teodor Danciu wrote: JasperServer 0.9.0 released JasperServer/JasperIntelligence home page: http://jasperintel.sourceforge.net This is awesome. I already have a servlet for creating my reports (about 30 with 100 sub reports) and continuously get requests for features just like the JasperServer implements (or got on the roadmap). I will definitely look at using it rather than reinvent the wheel. And I suppose you are not opposed to user suggestions/contributions ;-) manfred --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] [ANN] JasperServer 0.9.0 released
Title: RE: [jasperreports-questions] [ANN] JasperServer 0.9.0 released Hello Teodor, Can it be possible to integrate the Jasper Viewer i.e. swing application into web application in the form of servlet so that all the features of pagination, zoom, print etc. will be available. We are looking at solid powerful jasper viewer so as avoid exporting of jrprint each time. Thanks, Kalpesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2006 9:37 PM To: Teodor Danciu Cc: 'jasperreports-questions@lists.sourceforge.net' Subject: Re: [jasperreports-questions] [ANN] JasperServer 0.9.0 released Hi! I just finished the download. I am going to try check it all out with JBoss on Windows. One question.. are you going to abstract away from MySQL and support other db servers? Manfred Teodor Danciu wrote: Hello, Manfred We hope that this new open source product will solve many of the issues that existing JasperReports users have faced along the way. The most common was the lack of infrastructure around JasperReports as a library so that reporting functionality be readily available to end users. We think that JasperServer will close this gap and be useful to the community. As usual, feedback and contributions are always welcomed. This is what open source is all about. Thank you, Teodor Manfred Moser wrote: Teodor Danciu wrote: JasperServer 0.9.0 released JasperServer/JasperIntelligence home page: http://jasperintel.sourceforge.net This is awesome. I already have a servlet for creating my reports (about 30 with 100 sub reports) and continuously get requests for features just like the JasperServer implements (or got on the roadmap). I will definitely look at using it rather than reinvent the wheel. And I suppose you are not opposed to user suggestions/contributions ;-) manfred --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk=110944=241720=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] [ANN] JasperServer 0.9.0 released
Manfred, Our current metadata repository implementation is using Hibernate. So there should not be a problem to store metadata information into other databases. Is just that for the moment we tested with MySQL. Thank you, Teodor Manfred Moser wrote: Hi! I just finished the download. I am going to try check it all out with JBoss on Windows. One question.. are you going to abstract away from MySQL and support other db servers? Manfred Teodor Danciu wrote: Hello, Manfred We hope that this new open source product will solve many of the issues that existing JasperReports users have faced along the way. The most common was the lack of infrastructure around JasperReports as a library so that reporting functionality be readily available to end users. We think that JasperServer will close this gap and be useful to the community. As usual, feedback and contributions are always welcomed. This is what open source is all about. Thank you, Teodor Manfred Moser wrote: Teodor Danciu wrote: JasperServer 0.9.0 released JasperServer/JasperIntelligence home page: http://jasperintel.sourceforge.net This is awesome. I already have a servlet for creating my reports (about 30 with 100 sub reports) and continuously get requests for features just like the JasperServer implements (or got on the roadmap). I will definitely look at using it rather than reinvent the wheel. And I suppose you are not opposed to user suggestions/contributions ;-) manfred --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] [ANN] JasperServer 0.9.0 released
Hi Manfred, All the MySQL access should be going through Hibernate, and its just a matter of using the right dialect to work with other DBs. We will be officially certifying on a wide range of databases, both open source and commercial. We are also going to do more testing on other app servers to try to make sure we works will all the popular ones. -Barry On Apr 7, 2006, at 9:06 AM, Manfred Moser wrote: Hi! I just finished the download. I am going to try check it all out with JBoss on Windows. One question.. are you going to abstract away from MySQL and support other db servers? Manfred Teodor Danciu wrote: Hello, Manfred We hope that this new open source product will solve many of the issues that existing JasperReports users have faced along the way. The most common was the lack of infrastructure around JasperReports as a library so that reporting functionality be readily available to end users. We think that JasperServer will close this gap and be useful to the community. As usual, feedback and contributions are always welcomed. This is what open source is all about. Thank you, Teodor Manfred Moser wrote: Teodor Danciu wrote: JasperServer 0.9.0 released JasperServer/JasperIntelligence home page: http://jasperintel.sourceforge.net This is awesome. I already have a servlet for creating my reports (about 30 with 100 sub reports) and continuously get requests for features just like the JasperServer implements (or got on the roadmap). I will definitely look at using it rather than reinvent the wheel. And I suppose you are not opposed to user suggestions/ contributions ;-) manfred --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] [ANN] JasperServer 0.9.0 released
Hi, Kalpesh I would be fairly easy to introduce the applet viewer as a possible output to JasperServer. In our JasperReports distribution we supply a smaller JAR that could be used in Web applications to view reports on the client side using the Swing viewer. In this first release of JasperServer, the applet viewer is not included, but there is no reason for not doing so in the future. Thank you, Teodor Kalpesh Chordia wrote: Hello Teodor, Can it be possible to integrate the Jasper Viewer i.e. swing application into web application in the form of servlet so that all the features of pagination, zoom, print etc. will be available. We are looking at solid powerful jasper viewer so as avoid exporting of jrprint each time. Thanks, Kalpesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 07, 2006 9:37 PM To: Teodor Danciu Cc: 'jasperreports-questions@lists.sourceforge.net' Subject: Re: [jasperreports-questions] [ANN] JasperServer 0.9.0 released Hi! I just finished the download. I am going to try check it all out with JBoss on Windows. One question.. are you going to abstract away from MySQL and support other db servers? Manfred Teodor Danciu wrote: Hello, Manfred We hope that this new open source product will solve many of the issues that existing JasperReports users have faced along the way. The most common was the lack of infrastructure around JasperReports as a library so that reporting functionality be readily available to end users. We think that JasperServer will close this gap and be useful to the community. As usual, feedback and contributions are always welcomed. This is what open source is all about. Thank you, Teodor Manfred Moser wrote: Teodor Danciu wrote: JasperServer 0.9.0 released JasperServer/JasperIntelligence home page: http://jasperintel.sourceforge.net This is awesome. I already have a servlet for creating my reports (about 30 with 100 sub reports) and continuously get requests for features just like the JasperServer implements (or got on the roadmap). I will definitely look at using it rather than reinvent the wheel. And I suppose you are not opposed to user suggestions/contributions ;-) manfred --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] [ANN] JasperServer 0.9.0 released
Sweet. Just the answer I hoped for ;-) manfred Teodor Danciu wrote: Manfred, Our current metadata repository implementation is using Hibernate. So there should not be a problem to store metadata information into other databases. Is just that for the moment we tested with MySQL. Thank you, Teodor Manfred Moser wrote: Hi! I just finished the download. I am going to try check it all out with JBoss on Windows. One question.. are you going to abstract away from MySQL and support other db servers? Manfred Teodor Danciu wrote: Hello, Manfred We hope that this new open source product will solve many of the issues that existing JasperReports users have faced along the way. The most common was the lack of infrastructure around JasperReports as a library so that reporting functionality be readily available to end users. We think that JasperServer will close this gap and be useful to the community. As usual, feedback and contributions are always welcomed. This is what open source is all about. Thank you, Teodor Manfred Moser wrote: Teodor Danciu wrote: JasperServer 0.9.0 released JasperServer/JasperIntelligence home page: http://jasperintel.sourceforge.net This is awesome. I already have a servlet for creating my reports (about 30 with 100 sub reports) and continuously get requests for features just like the JasperServer implements (or got on the roadmap). I will definitely look at using it rather than reinvent the wheel. And I suppose you are not opposed to user suggestions/contributions ;-) manfred --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- Manfred Moser - [EMAIL PROTECTED] CardioComm Solutions Inc. 201-3060 Cedar Hill Rd. Victoria BC V8T 3J5 Canada Phone: (250) 744 1822 Ext. 230 Fax: (250) 744-1866 http://www.cardiocomm.com --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] [ANN] iReport 1.2.1 released!
The iReport Team is pleased to announce the new iReport release: 1.2.1. iReport Release 1.2.1 April 7, 2006 The following changes have been made to software since release 1.2.0 * Full support for JasperReports 1.2.1 * New handling of conditional style * New dockable interface * New subreport wizard * New styles library * New translation status plugin * New date and percentage tools * New load/save query buttons * Serveral bug fixes and improvements See details on iReport 1.2.1 What's new? page! (http://ireport.sourceforge.net/index.php?p_module=pagepageid=32) iReport home page: http://ireport.sf.net Download it now: http://sourceforge.net/project/showfiles.php?group_id=64348 --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Urgent help needed-Formatting issue
Hi all, I have a report which needs stretch with overflow to be true else the data gets truncated. However, when I make it true, it removes the vertical line from the formatting as shown in certain columns of the attached file. Would anybody please suggest me as to what can I do so that the formatting doesn't distort. Please help, it's very urgent. Thanks Regards, MS PS: please see the attached file Report2.pdf Description: Adobe PDF document
RE: [jasperreports-questions] Urgent help needed-Formatting of re ports
Hi, You are talking about the lines, which are the borders of the cells right? I could see most of the vertical lines in report2, what you have attached. Try to enlarge a bit and see. May be you can try to increase the border thickness... I could observe few cells cross over the horizontal line, which can control by increasing the height of that cell and check with a max value what that cell can hold. Regards, Raffi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Meenakshi Singh Sent: Friday, February 24, 2006 3:30 PM To: JasperreportsQuestions (E-mail) Subject: [jasperreports-questions] Urgent help needed-Formatting of reports Hi all, These are the format of my report which I have included as pdf files. If u see report 1 then u would find all the horizontal vertical lines. In first report data is truncated. So, I checked the stretch with overflow option to be true. After that the data is being shown, however the formatting went wrong. If u look at report 2 then u would find many of the vertical lines missing. in the html version none of the vertical lines are showing. Would anybody suggest/tell me how can I control this, so that my report shows all the vertical lines alongwith the horizontal lines. Please help at the earliest, it's very urgent. Thanks Regards, MS --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] [PRINT] How to print whitout having the windos driver configuratin frame ?
Hello, I have to develop an application wich generate labels (3-4 lines of text and a bar code) one by one. Each label have to be printed before the next is generated. Labels have to be printed whitout human manipulation. So I have to not display the windows configuratin driver frame. Is it possible with jasper report ? how to do this ? (I already how to create report since I use jasper report into another more standard application) thanks :) -- yves piel --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Re: Field Alias
Hi Everyone, I saw the email below in the archives and I'm having the same problem: the iReport doesn't acknowledge the aliases at runtime. The report SQL is automatically parsed fine and all fields are parsed fine with the correct alias names. But at runtime it throws an exception about Unknown column name: THE_ALIAS I get that error only if I use the new version 1.2.0, if I use the old version that I have 0.4.0 it works fine, and since I'm using the same driver from the same jconn3.jar, I'm thinking it has to do with iReport. Anyone else having the same issue? Alex From: Barry Klawans [EMAIL PROTECTED] Re: Field Alias 2005-10-28 12:04 That sounds like the field names did not get set to the alias name correctly, so that the report engine doesn't see a declaration of the field named tableA_name. In iReport bring up the Report Query window and check what the lower half shows as the field names. I bet they show name twice. If so, make sure that Automatically Retrieve Fields is selected. If it is selected, and you have the aliases in the query but they aren't showing up in the field list, that means the JDBC driver you are using isn't showing the aliases correctly. If that is the problem, the fix is pretty easy. Leave the Query window and bring up the Report Fields window. (Go to the View menu and select Report Fields. In this window you should see a field called id, and possible one or two named name. Rename one to tableA_name and the other to tableB_name. If the list only shows one field called name simply add a new one. One last thing to watch out for. Some drivers map alias names to all lower case (like the PostgreSQL driver) so the names may need to be tablea_name. -Barry Klawans On Oct 27, 2005, at 5:38 PM, Sigit Purnomo M wrote: Hello.. I'm new in Java and JasperReports. But I already try to create / design some report using iReport 0.5.1. But I found a problem: How can I use some field with the same name? For example I have this query: select a.id, a.name as tableA_name, b.name as tableB_name from tableA a, tableB b where a.id = b.id When I compile report with that query, it return this error: net.sf.jasperreports.engine.JRException: Report design not valid : 1. Field not found : tableA_name . So, is there anyone can help me? Thanx in advance Sigit Purnomo M Indonesia --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Charts: Show Integer Values
Hello,I have a simplchart in the report.I would like to:1. Show values as IntegersMy data contants values of0,2,4,6 that are java.lang.Integers and categories of X, Y, Z that are strings. The values on the y axis show up as numbers with a decimal point (0.0, 2.5, 5.0, 7.5, 10.0). Is there a way I can make Integers show up there? (0, 2, 4, 6, 8 10)? Thanks Regards,Meenakshi.
[jasperreports-questions] Error in creating a jasper report
Hi I have created a jrxml and subsequently a jasper file using iReports. The report also comes nicely in the iReports Execute using active connection mode. However, when i try to incorporate this jasper file into my project ( I am using Oracle JDev 9.0.5 on Windows XP ), i get the error as mentioned in the attached error file. My Source code is also attached. Pls help. thanks Manish -- - Imagination is more important than knowledge. -- Albert Einstein06/03/30 12:38:12 Hibernate: select payroll0_.payrollid as payrollid, payroll0_.date as date9_, payroll0_.startday as startday9_, payroll0_.endday as endday9_, payroll0_.hoursworked as hourswor5_9_, payroll0_.grosspay as grosspay9_, payroll0_.deductions as deductions9_, payroll0_.netpay as netpay9_, payroll0_.empid as empid9_ from payroll payroll0_ 06/03/30 12:38:15 java.lang.NoSuchMethodException: Unknown property 'empid' 06/03/30 12:38:15 at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1175) 06/03/30 12:38:15 at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772) 06/03/30 12:38:15 at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:801) 06/03/30 12:38:15 at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:104) 06/03/30 12:38:15 at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:800) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:986) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) 06/03/30 12:38:15 at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:428) 06/03/30 12:38:15 at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:409) 06/03/30 12:38:15 at net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:257) 06/03/30 12:38:15 at com.cde.payroll.Common.actions.GenPayrollReportAction.execute(GenPayrollReportAction.java:68) 06/03/30 12:38:15 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) 06/03/30 12:38:15 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) 06/03/30 12:38:15 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1485) 06/03/30 12:38:15 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:509) 06/03/30 12:38:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) 06/03/30 12:38:15 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 06/03/30 12:38:15 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) 06/03/30 12:38:15 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source) 06/03/30 12:38:15 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604) 06/03/30 12:38:15 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) 06/03/30 12:38:15 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790) 06/03/30 12:38:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) 06/03/30 12:38:15 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) 06/03/30 12:38:15 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) 06/03/30 12:38:15 at java.lang.Thread.run(Thread.java:534) 06/03/30 12:38:15 NESTED BY : 06/03/30 12:38:15 java.lang.NoSuchMethodException: Unknown property 'empid' 06/03/30 12:38:15 at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1175) 06/03/30 12:38:15 at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772) 06/03/30 12:38:15 at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:801) 06/03/30 12:38:15 at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:104) 06/03/30 12:38:15 at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:800) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:986) 06/03/30 12:38:15 at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) 06/03/30 12:38:15 at
Re: [jasperreports-questions] Using LDAP as a datasource ?
Jack, Thanks for making the suggestion. But I am not really interested in rolling my own custom code here. You see im not a developer, just an end user. So if JasperReports does not provide this functionality 'out-of-the-box', then I guess that Im just going to have to look at some other solution here. Perhaps I should take a look at BIRT or Pentaho ? Thanks for the help, Sincerely, John Smith. On 3/20/06, Jack Bakker [EMAIL PROTECTED] wrote: John, In your own code you could select from the LDAP source and return a custom datasource to JasperReports. I've used this mechanism for bringing together data from multiple sources (relational dbs, ldap, etc.). For OpenLDAP, there is a JDBC-LDAP tool that might work (haven't tried it). I suggest the custom datasource approach above. .. Jack - www.iable.ca - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Smith Sent: March 20, 2006 10:54 AM To: jasperreports-questions@lists.sourceforge.net Subject: [jasperreports-questions] Using LDAP as a datasource ? Hi. I was wondering if JasperReports provides the capability to produce query's and design reports based on the contents of an LDAP server, by using LDAP as the datasource ? Please note that I am not talking about authenticating the users of JasperReports to/in LDAP, but really about reporting on the ldap content itself. For example, would it be possible to use JasperReports to report on : - The amount of new entries created/modified/deleted in LDAP - Wheter certain entries or object types in LDAP (like usernames or the dn/cn of inetOrgPerson objects) meet/don't meet certain criteria (like naming conventions) - Whether any 'groupOfNames' entries have any 'member' entries that dont't exist anywhere else in the LDAP tree anymore (groups that have non-existing users as a member) - etc. etc. ? Thanks for the feedback, Sincerely, John Smith. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=kkid0944bid$1720dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] [ANN] iReport 1.2.0 released!
Title: RE: [jasperreports-questions] [ANN] iReport 1.2.0 released! Hi, I am trying to run iReport 1.2.0 using the modified iReport.bat file. My modified iReport.bat file is - @echo off cd . set JAVA_HOME=D:\j2sdk1.4.0 set ANT_HOME=D:\Jasper\apache-ant-1.6.1-bin\apache-ant-1.6.1 set IREPORT_HOME=. rem %ANT_HOME%\bin\ant javadocs echo === echo Ant script for iReport. Ant 1.6 or greater required. echo === echo %ANT_HOME%\bin\ant iReport ~~ While running this bat file from command prompt,I am getting following error at init main frame component. === Ant script for iReport. Ant 1.6 or greater required. === ECHO is off. Buildfile: build.xml prepare: compile: iReport: [java] TinyLaF v1.3.03 [java] 'Default.theme' not found - using YQ default theme. [java] java.lang.NullPointerException [java] at javax.swing.JToolBar$Separator.getPreferredSize(JToolBar.java:676) [java] at javax.swing.JToolBar$Separator.getMinimumSize(JToolBar.java:654) [java] at javax.swing.BoxLayout.checkRequests(BoxLayout.java:426) [java] at javax.swing.BoxLayout.preferredLayoutSize(BoxLayout.java:244) [java] at javax.swing.JToolBar$DefaultToolBarLayout.preferredLayoutSize(JToolBar.java:749) [java] at java.awt.Container.preferredSize(Container.java:989) [java] at java.awt.Container.getPreferredSize(Container.java:973) [java] at javax.swing.JComponent.getPreferredSize(JComponent.java:1264) [java] at java.awt.BorderLayout.preferredLayoutSize(BorderLayout.java:569) [java] at java.awt.Container.preferredSize(Container.java:989) [java] at java.awt.Container.getPreferredSize(Container.java:973) [java] at javax.swing.JComponent.getPreferredSize(JComponent.java:1264) [java] at java.awt.BorderLayout.preferredLayoutSize(BorderLayout.java:564) [java] at java.awt.Container.preferredSize(Container.java:989) [java] at java.awt.Container.getPreferredSize(Container.java:973) [java] at javax.swing.JComponent.getPreferredSize(JComponent.java:1264) [java] at javax.swing.JRootPane$RootLayout.preferredLayoutSize(JRootPane.java:801) [java] at java.awt.Container.preferredSize(Container.java:989) [java] at java.awt.Container.getPreferredSize(Container.java:973) [java] at javax.swing.JComponent.getPreferredSize(JComponent.java:1264) [java] at java.awt.BorderLayout.preferredLayoutSize(BorderLayout.java:564) [java] at java.awt.Container.preferredSize(Container.java:989) [java] at java.awt.Container.getPreferredSize(Container.java:973) [java] at java.awt.Window.pack(Window.java:415) [java] at it.businesslogic.ireport.gui.MainFrame.initComponents(MainFrame.java:3553) [java] at it.businesslogic.ireport.gui.MainFrame.init(MainFrame.java:313) [java] at it.businesslogic.ireport.gui.MainFrame.main(MainFrame.java:6685) ~~ Can anybody please help me in using the iReport 1.2.0 ? I have copied tools.jar to lib folder. Thanks, Kalpesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 01, 2006 7:32 AM To: ireport-questions; JasperreportsQuestions (E-mail) Subject: [jasperreports-questions] [ANN] iReport 1.2.0 released! The iReport Team is pleased to announce the new iReport release: 1.2.0. - Full support for JasperReports 1.2.0 (conditional styles, new evaluation time auto, crosstab header cell,...) - Improved report wizard to use non-JDBC datasources (like Hibernate datasource) - Full support for HQL (Hibernate query language) - Support for the new CSV datasource provided by JasperReports - New one-click subreport access - _expression_ editor populated according with the context - New popup menu for the crosstab object list - New formatting tools for cell elements - Serveral bug fixes and improvements And much more... See details on iReport 1.2.0 What's new? page! (http://ireport.sourceforge.net/index.php?p_module=page=31 http://ireport.sourceforge.net/index.php?p_module=page=31) iReport home page: http://ireport.sf.net Download it now: http://sourceforge.net/project/showfiles.php?group_id=64348 --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk=110944=241720=121642 ___ jasperreports-questions mailing list
Re: [jasperreports-questions] JasperFillManager.fillReport very very slow
Hi, How much memory to you allow the JVM to use? You say sometimes it takes up to 5 minutes. If the response times are not consistent from one execution to the next, this is a clear indication that there is not enough memory available and the JVM spends to much time trying to garbage collecting things. I hope this helps. Teodor Richard Walton wrote: Hi All I am having a problem with JasperFillManager.fillReport I’m using Jasper 1.1 running on tomcat ( I have a web application that creates the reports and then serves them to the user over the web ) Code looks like this System.out.println(Before getcompiledreport : +System.currentTimeMillis()); JasperReport jasperReport = JasperHelper.getCompiledReport( reportName, getServletContext()); System.out.println(Before parameters.put(jasperReport, jasperReport) : +System.currentTimeMillis()); parameters.put(jasperReport, jasperReport); System.out.println(Before fillReport : +System.currentTimeMillis()); jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn); So when I do the jasperPrint = JasperFillManager.fillReport(jasperReport,parameters, conn); it takes sometimes up to 5 mins to come back to me with the jasperPrint object!!! Any ideas anyone? Oh yeah and the data coming back isn’t that big and the query that I run in the report takes less than 1 second to execute when I run it on the ms sql server Any ideas anyone? Rich --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] About page number
Hello, My name is Curt Huang. I have a question here. In JasperReport 0.6.0, we can have batch export using parameter JRExporterParameter.JASPER_PRINT_LIST. After we export three reports which contains page number to one file, the file still keeps the original page numbers of each report. I suggest this exported file may generate the page numbers again for all pages. Thus all pages in the exported file has continus page numbers. Thank you! Curt ___ 最新版 Yahoo!奇摩即時通訊 7.0,免費網路電話任你打! http://messenger.yahoo.com.tw/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Logical fonts (Dialog, DialogInput, Serif, SansSerif, Monospaced) don't work if different from size 10
Hi, Try to use isStretchWithOverflow=true or increase the height of your text elements when you change the font size. I hope this helps. Teodor Geoffrey De Smet wrote: Java has 5 logical fonts, which have a very nice feature: Any platform (Win/Linux/Mac/...) have a font mapped to them. But when I use any of those 5 fonts (Dialog, DialogInput, Serif, SansSerif, Monospaced) they show up blank if the size is different from 10: Does work: reportFont ... fontName=Dialog size=10 .../ reportFont ... fontName=Times New Roman size=12 .../ !-- unsure about non windows systems... -- Shows up blank: reportFont ... fontName=Dialog size=12 .../ Here is my full definition: reportFont name=ggg isDefault=false fontName=Dialog size=12 isBold=false isItalic=false isUnderline=false isStrikeThrough=false isPdfEmbedded=true / Using Jasperreports 1.2.0 Thanks for a great product btw. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Manually setting locale and excel to stream
How can I manually set a Locale to a report? I have looked extensively and have been unable to find one. Why don't the excel reports support streaming? Is it really necessary to create the file first? Thanks Srgjan --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Inheriting a font in subreports
Is it possible to inherit a report font in a subreport? For example my master reports defines: reportFont name=bodyNormal isDefault=false fontName=Times New Roman size=12 isBold=false isItalic=false isUnderline=false isStrikeThrough=false pdfFontName=Times-Roman pdfEncoding=Cp1252 isPdfEmbedded=false/ and my subreport should be able to use the report font bodyNormal. Thanks for any and all help. -- With kind regards, Geoffrey De Smet --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Problem with Hibernate: Unknown HQL return alias
from Report p join p.notary join p.instrumentsnet.sf.jasperreports.engine.JRRuntineException: Unknown HQL return alias "affidavits"the query works in hibernate but in jasper reports gives that error any suggestions ?
[jasperreports-questions] jasperreports 1.1.0 with jre 1.4.2_05 on winxp brings down windows spooler
Hello, I have a standalone server generating reports using jasperreports. The server is supposed to generate about 1-15000 reports per day. But after a few hours ( I cannot exactly tell the number of reports done till then ) the reports are no longer printed. At the same time, other processes, doing normal windows printing, stop printing too. When I restart the server running jasperreports, all printing works ok again. I assume that the jasperreport server consumes some printer resources so that the printer system ultimately comes to a stop. Not being a windows expert, I don't have any idea what kind of resource this could be and how these resources could be freed. Here is the code segment of my jasperreport server doing the actual printing. As you can see, a filled in JasperPrint object and a printer name is passed in: private void printReport ( JasperPrint jasperPrint, String printerName ) throws JRException { PrintRequestAttributeSet printRequestAttributeSet = new HashPrintRequestAttributeSet (); printRequestAttributeSet.add (MediaSizeName.ISO_A4); PrintServiceAttributeSet printServiceAttributeSet = new HashPrintServiceAttributeSet (); printServiceAttributeSet.add(new PrinterName(printerName, null)); //printServiceAttributeSet.add(new PrinterName(HP LaserJet 4P, null)); JRPrintServiceExporter exporter = new JRPrintServiceExporter (); exporter.setParameter (JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter (JRPrintServiceExporterParameter.PRINT_REQUEST_ATTRIBUTE_SET, printRequestAttributeSet); exporter.setParameter (JRPrintServiceExporterParameter.PRINT_SERVICE_ATTRIBUTE_SET, printServiceAttributeSet); exporter.setParameter (JRPrintServiceExporterParameter.DISPLAY_PAGE_DIALOG, Boolean.FALSE); exporter.setParameter (JRPrintServiceExporterParameter.DISPLAY_PRINT_DIALOG, Boolean.FALSE); exporter.exportReport (); } Should I do some cleanup on the exporter object? I welcome any suggestions. Thanks and kind regards Christoph --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] How to compile jasperreports in a application container?
How do you compile jasperreports in a application container? As a standalone, i dont have any problem compiling jasperreports. But when inside a container, (Resin 3.0.17), I always encountered this following error: et.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. The type java.lang.Object cannot be resolved. It is indirectly referenced from required .class files public class BasicReport_1141811849656_333469 extends JREvaluator - 1 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:131) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:211) ... ... I am using jasperreports-1.2.0.jar, I included all the libraries in the distributions to make sure that all required files are included. Does anyone encountered the same problem? I hope there is someone there who have some ideas. Russel Montaos --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] PDF Question
Jasper uses iText (http://www.lowagie.com/iText/) for PDF generation. There is a new line in iText (a static member of the Chunk class) so you might need to use that in your report. I should think you could import com.lowagie.text.Chunk and then use Chunk.NEWLINE on your report. Hope this helps. Doug James From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, March 03, 2006 1:55 PMTo: jasperreports-questions@lists.sourceforge.netSubject: [jasperreports-questions] PDF Question Dear Jasper Report Experts:I have a need to force a newline character in a PDF formatted Jasper Report. I tried putting "\n" in the output of the query string but I just get "\n" in the text. Any ideas?Thanks,Gary Weik *** This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic information about individuals and businesses subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 *** If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to [EMAIL PROTECTED] with 'No Promotional E-mails' in the SUBJECT line. ***BENEFITFOCUS.COM CONFIDENTIALITY NOTICE: This electronic message is intended only for the individual or entity to which it is addressed and may contain information that is confidential and protected by law. Unauthorized review, use, disclosure, or dissemination of this communication or its contents in any way is prohibited and may be unlawful. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please notify the original sender immediately by e-mail or telephone, return the original message to the original sender or to [EMAIL PROTECTED], and destroy all copies or derivations of the original message. Thank you. (BFeComNote Rev. 08/01/2005)***
[jasperreports-questions] Parameter becomes null without warning !
Hi everybody, I'm using JasperReports 1.2.0 and iReport 1.2.0 also. I have a report which is made of one main report and two subreports. I have defined a Date parameter (in my case $P{BEG_DATE} ) which is passed by the application. when I display the main report the date is fine and when I display the subreport only, the date becomes null. Has anyone seen something like this ? Any idea ? Here is a jrxml snippet : title band height=40 isSplitAllowed=true textField isStretchWithOverflow=false pattern= isBlankWhenNull=false evaluationTime=Now hyperlinkType=None hyperlinkTarget=Self reportElement mode=Transparent x=0 y=10 width=610 height=20 forecolor=#00 backcolor=#FF key=textField-19 stretchType=NoStretch positionType=FixRelativeToTop isPrintRepeatedValues=true isRemoveLineWhenBlank=false isPrintInFirstWholeBand=false isPrintWhenDetailOverflows=false/ box topBorder=None topBorderColor=#00 leftBorder=None leftBorderColor=#00 rightBorder=None rightBorderColor=#00 bottomBorder=None bottomBorderColor=#00/ textElement textAlignment=Left verticalAlignment=Top rotation=None lineSpacing=Single font fontName=Arial pdfFontName=Helvetica size=10 isBold=false isItalic=false isUnderline=false isPdfEmbedded =false pdfEncoding =Cp1252 isStrikeThrough=false / /textElement textFieldExpression class=java.lang.String![CDATA[$P{BEG_DATE}.toString()]] /textFieldExpression /band /title Thanx in advance, Farid. --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Swing viewer with frozen headers
We have a Swing rich client app that, among other things, is used to view JasperReport output. Currently, we just slapped the supplied Swing viewer into our app, but now our users want this built in viewer to freeze the header and the first left column of the report when scrolling. Apparently, they are envisioning zooming in on a report page and scrolling around while keeping the header and left column frozen in place. Just curious if anyone else has come across such a requirement, and if there are any open source solutions? :) Thanks! --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] Dynamic grouping
hi, It is possible to pass a parameter in to your template which will run the query accordingly and fill ur report. For example: parameter name=Flag class=java.lang.String/ queryString![CDATA[select * from ...group by $P{Flag}]]/queryString I hope that this is what you were looking for. Thanks -Amar -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 8:02 PM To: jasperreports-questions@lists.sourceforge.net Subject: [jasperreports-questions] Dynamic grouping We have a report that is currently implemented in a different reporting product. To satisfy our user requirements we have ended up with 3 different report templates to support the 3 different grouping that can be requested. For example: One template groups by city, another by state and the final by area code. Is it possible to pass a parameter into a Jasper Report template that would allow for one template and the 3 different groupings. We would like to be able to call the report and pass in the city flag or the state flag etc. Thanks for the assistance! Doug James Software Engineer Benefitfocus.com, Inc. BENEFITFOCUS.COM CONFIDENTIALITY NOTICE: This electronic message is intended only for the individual or entity to which it is addressed and may contain information that is confidential and protected by law. Unauthorized review, use, disclosure, or dissemination of this communication or its contents in any way is prohibited and may be unlawful. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please notify the original sender immediately by e-mail or telephone, return the original message to the original sender or to [EMAIL PROTECTED], and destroy all copies or derivations of the original message. Thank you. (BFeComNote Rev. 08/01/2005) *** --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Dynamic grouping
Hi You can create a variable to hold the value used for grouping: variable name=groupVal class=java.lang.Object variableExpression $P{grpHeader}.equals(city) ? $F{city} : ($P{grpHeader}.equals(state) ? $F{state} : ... ) /variableExpression /variable and then group by $V{groupVal} Note that specifying a group in a report does not sort the data set, so you will probably need to sort it depending on your parameter value: queryselect ... order by $P!{grpHeader}/query Then, in the group header you can use printWhenExpression to decide which header to show (city, state, etc). HTH, Lucian Doug James wrote: Amar, thanks for the reply. My apologies for not explaining things completely. What I would like to do is change the field in a grouping band on the actual report as well as in the query. So in the jrxml I have something like: group name=groupedgroupExpression![CDATA[$F{$P{grpHeader}}]]/groupExpr ession I hope this helps explain things further. Doug -Original Message- From: Amar Patel [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 4:53 AM To: Doug James; jasperreports-questions@lists.sourceforge.net Subject: RE: [jasperreports-questions] Dynamic grouping hi, It is possible to pass a parameter in to your template which will run the query accordingly and fill ur report. For example: parameter name=Flag class=java.lang.String/ queryString![CDATA[select * from ...group by $P{Flag}]]/queryString I hope that this is what you were looking for. Thanks -Amar -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 8:02 PM To: jasperreports-questions@lists.sourceforge.net Subject: [jasperreports-questions] Dynamic grouping We have a report that is currently implemented in a different reporting product. To satisfy our user requirements we have ended up with 3 different report templates to support the 3 different grouping that can be requested. For example: One template groups by city, another by state and the final by area code. Is it possible to pass a parameter into a Jasper Report template that would allow for one template and the 3 different groupings. We would like to be able to call the report and pass in the city flag or the state flag etc. Thanks for the assistance! Doug James Software Engineer Benefitfocus.com, Inc. BENEFITFOCUS.COM CONFIDENTIALITY NOTICE: This electronic message is intended only for the individual or entity to which it is addressed and may contain information that is confidential and protected by law. Unauthorized review, use, disclosure, or dissemination of this communication or its contents in any way is prohibited and may be unlawful. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please notify the original sender immediately by e-mail or telephone, return the original message to the original sender or to [EMAIL PROTECTED], and destroy all copies or derivations of the original message. Thank you. (BFeComNote Rev. 08/01/2005) *** --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions BENEFITFOCUS.COM CONFIDENTIALITY NOTICE: This electronic message is intended only for the individual or entity to which it is addressed and may contain information that is confidential and protected by law. Unauthorized review, use, disclosure, or dissemination of this communication or its contents in any way is prohibited and may be unlawful. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please notify the original sender immediately by e-mail or telephone, return the original message to the original sender or to [EMAIL PROTECTED], and destroy all copies or derivations of the original message. Thank you. (BFeComNote Rev. 08/01/2005) *** --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding
Re: [jasperreports-questions] isStretchWithOverflow VS. RH Linux
I thought I'd add some observations here. I found this thread while googling for a solution to my own problem. My problem is that if I generate a JasperPrint output on our Linux server (running Java 1.5), serialize that JasperPrint to a Swing client running on a Windows XP box, and display that JasperPrint using the provided Swing viewer, then the stretch areas will almost always chop off the last line of text. I believe this is because isStretchOnOverflow is something that is computed at report fill time and a hardcoded size is placed into the final JasperPrint (the hardcoded size having been computed using the font installed on the Linux box). So, if my stretch area needs to stretch in order to show the last two lines of text, for example, it won't quite be big enough to hold both lines of text when viewed on a windows box. It appears that the Swing viewer is not rendering the last line of text unless it is completely containable within the alloted area. Now, if I then export to PDF from the Swing rich client, the resulting PDF (which was generated from the Swing rich client itself, not the server) will properly show the text! If I understand this thread correctly, then one solution would be to copy the Windows font over onto our Linux server and point the JVM to it. This is, of course, the most accurate solution. But for those who don't have access to the font or don't want to deal with any legal ramifications of this option, I wonder if a fudge factor could be configured? Something along the lines of a multiplier by which the Jasper fill engine should multiple the computed height of each line of text (say 1.05, for example). This could be configured at runtime by the system, and would default to 1.0 so as to be 100% compatible with current behavior. I realize that such a fudge factor is really a quick and dirty hack, but it could be a useful crutch for those who don't want to copy a font. What do you think? - Andy Chris Edwards wrote: John, Thank you very much! Adding JAVA_FONTS and associated fonts worked like a charm. Thank you so much for your time and help with this. Great explanation too (and easier than modifying font.properties...) Thanks again. John Bindel wrote: The tag used tells the client platform which font to use. On the client machine, a font that is closest to the desired font (e.g., arial) is chosen when the PDF is rendered. What I have seen happen on Linux is that the Lucida font (not Verdana as I accidently wrote below), does not have the same shape. If you copy the Arial font files (or FreeSans) and the Lucida font to some directory accessible by the machine creating the PDF, AND set the environment variable JAVA_FONTS to point to that directory, this should allow the JVM running on Linux to use a better font than the Lucida font it has. When JasperReports generates the PDF, it first creates a JasperPrint object, and the sizes of all fields are determined when the JasperPrint object is created. JasperReports uses the AWT to figure out how much space is needed to render some particular piece of text, but when the PDF is displayed, X or Windows uses all of its available fonts to render the text, so the size of the text at client render time is not necessarily the size that JasperReports thought it was when it asked the JVM and AWT for the size. Now the problems I have had with this were that my JVM and AWT were allocating too much space for the text that appeared, and when I generated the PDF on Linux, there would be extra vertical space in the report output, but it was perfect when the PDF was generated by Windows. It could be that when you generate the report on Linux, JasperReports doesn't think there is enough space, though I'm not sure why it wouldn't just be wrapping the text. Does it appear that your element positions are floating at all? Are the text boxes floating at all? Elements will float only if they do not normally overlap. E.g., If last_name is shown to the right of first_name, then the last_name x position must be specified to be greater than or equal to first_name.x + first_name.width. On Tue, Feb 21, 2006 at 01:48:13PM -0600, Chris Edwards wrote: John, Thank you for the insight. Isn't the PDF font specified by the pdfFontName attribute of the font tag? Changing that attribute to other fonts doesn't work either. Thanks again. John Bindel wrote: If you install Microsoft's Arial font in your Java VM, the rendering should work much better. The JVM ships only with the Verdana font, and it does not seem to have the same font metrics as the Arial font you are using in your PDF. You may also try the FreeSans font if you don't wish to install Arial. On Tue, Feb 21, 2006 at 07:51:36AM -0600, Chris Edwards wrote: Please help, 1. uname -a gives: Linux asg-rh-webdev 2.6.9-11.ELsmp #1 SMP Fri May 20 18:26:27 EDT 2005 i686 i686 i386 GNU/Linux 2. JDK 1.5.0_04 3. JasperReports 1.1.1 4.
[jasperreports-questions] Problem with Exporting Data Into Excel using Jasper Reports.
Title: Problem with Exporting Data Into Excel using Jasper Reports. Hi, I am Using Jasper Reports In my project and i have created .jrxml file and i am able to Export the report in to PDF ( with data) but same code i am not able export in EXCel . The File is getting generated with No data . Please Guide me Regarding this. I want to know why it is generating an empty Excel file without data. Please help me. This Is My File (stockroom.jrxml) ?xml version=1.0 encoding=UTF-8? !DOCTYPE jasperReport PUBLIC -//JasperReports//DTD Report Design//EN http://jasperreports.sourceforge.net/dtds/jasperreport.dtd jasperReport name=DataSourceReport pageWidth=595 pageHeight=842 columnWidth=515 leftMargin=40 rightMargin=40 topMargin=50 bottomMargin=50 style name=Arial_Normal isDefault=true fontName=Arial fontSize=12 isBold=false isItalic=false isUnderline=false isStrikeThrough=false pdfFontName=Helvetica pdfEncoding=Cp1252 isPdfEmbedded=false/ style name=Arial_Bold isDefault=false fontName=Arial fontSize=12 isBold=true isItalic=false isUnderline=false isStrikeThrough=false pdfFontName=Helvetica-Bold pdfEncoding=Cp1252 isPdfEmbedded=false/ style name=Arial_Italic isDefault=false fontName=Arial fontSize=12 isBold=false isItalic=true isUnderline=false isStrikeThrough=false pdfFontName=Helvetica-Oblique pdfEncoding=Cp1252 isPdfEmbedded=false/ field name=STOCKROOM_ID class=java.lang.Integer /field field name=STOCKROOM_NAME class=java.lang.String /field field name=STOCKROOM_DESC class=java.lang.String /field pageHeader band height=20 staticText reportElement mode=Opaque x=0 y=5 width=55 height=15 forecolor=#ff backcolor=#33 style=Arial_Bold/ textElement textAlignment=Center/ text![CDATA[STOCKROOM_ID]]/text /staticText staticText reportElement mode=Opaque x=55 y=5 width=205 height=15 forecolor=#ff backcolor=#33 style=Arial_Bold/ text![CDATA[STOCKROOM_NAME]]/text /staticText staticText reportElement mode=Opaque x=260 y=5 width=255 height=15 forecolor=#ff backcolor=#33 style=Arial_Bold/ text![CDATA[STOCKROOM_DESC]]/text /staticText /band /pageHeader detail band height=15 textField bookmarkLevel=2 reportElement x=0 y=0 width=50 height=15/ box leftBorder=Thin bottomBorder=Thin leftPadding=10 rightPadding=10/ textElement textAlignment=Right/ textFieldExpression class=java.lang.Integer![CDATA[$F{STOCKROOM_ID}]]/textFieldExpression /textField textField isStretchWithOverflow=true reportElement positionType=Float x=50 y=0 width=200 height=15/ box leftBorder=Thin bottomBorder=Thin leftPadding=10 rightPadding=10/ textElement/ textFieldExpression class=java.lang.String![CDATA[$F{STOCKROOM_NAME}]]/textFieldExpression /textField textField isStretchWithOverflow=true reportElement positionType=Float x=250 y=0 width=265 height=15/ box leftBorder=Thin bottomBorder=Thin rightBorder=Thin leftPadding=10 rightPadding=10/ textElement/ textFieldExpression class=java.lang.String![CDATA[$F{STOCKROOM_DESC}]]/textFieldExpression /textField /band /detail /jasperReport --- And This My Java Jasper Program for PDF: import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import net.sf.jasperreports.engine.JRResultSetDataSource; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.view.JasperViewer; public class JasperReportDemo { public static void main(String[] args) throws SQLException, FileNotFoundException, IllegalAccessException, ClassNotFoundException,Exception { try { final String driverClass = xx; final String connectionURL = ; final String userID = xxx; final String userPassword = ; Connection con = null; Statement stmt = null; ResultSet rset = null; Class.forName(driverClass).newInstance(); con = DriverManager.getConnection(connectionURL, userID, userPassword); String queryString = SELECT STOCKROOM_ID, STOCKROOM_NAME, STOCKROOM_DESC + FROM stockroom ; stmt = con.createStatement(); rset = stmt.executeQuery(queryString); InputStream input = new FileInputStream(new File(c:/stockroom.xml)); JasperDesign design = JRXmlLoader.load(input); JasperReport report = JasperCompileManager.compileReport(design); JRResultSetDataSource jasperReports = new JRResultSetDataSource(rset); JasperPrint print = JasperFillManager.fillReport(report, new HashMap(), jasperReports); long start = System.currentTimeMillis(); OutputStream output = new FileOutputStream(new File(c:/output/JasperReport.pdf));
[jasperreports-questions] ireport javabean set datasource
Hi, In iReport I 've added a javabean set datasource to a collection of javabeans and tested it. The test works. I 've also set the active connection. But when I try to run report using the connection the report contains only null values. When I try the same jxrml with jasperreports directly, everything works. Any ideas? Thanks for any and all help. -- With kind regards, Geoffrey De Smet --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] Chart and export question
Ta muchly to everyone who answered, I'll try the suggestions. Would that also allow the chart to be exported to Excel, or is this irrelevant? -Original Message- From: S, Mohamed Raffi (Mohamed) [mailto:[EMAIL PROTECTED] Sent: 16 February 2006 06:38 To: Yiannis Mavroukakis; 'jasperreports-questions@lists.sourceforge.net' Subject: RE: [jasperreports-questions] Chart and export question Hi, I guess you have the chart in the detail section, try moving it to header section. Hope that helps. Raffi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Yiannis Mavroukakis Sent: Wednesday, February 15, 2006 9:40 PM To: jasperreports-questions@lists.sourceforge.net Subject: [jasperreports-questions] Chart and export question Hello, I've been looking at the mailing list archives and I couldn't find an answer to my issue. When I fill in a barchart via a SQL query (it returns 13 records as a tuple) I get the chart rendered with the correct information, but I also get 13 pages of the same chart. Is there something I need to do, to display the chart as one page only? Secondly, is it possible for a chart to be exported to Excel? Thank you! Y. Note:__ This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Jaguar Freight Services and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. This e-mail has been scanned for all known viruses. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions This e-mail has been scanned for all known viruses. Note:__ This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Jaguar Freight Services and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. This e-mail has been scanned for all known viruses. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid3432bid#0486dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Chart and export question
Hello, I've been looking at the mailing list archives and I couldn't find an answer to my issue. When I fill in a barchart via a SQL query (it returns 13 records as a tuple) I get the chart rendered with the correct information, but I also get 13 pages of the same chart. Is there something I need to do, to display the chart as one page only? Secondly, is it possible for a chart to be exported to Excel? Thank you! Y. Note:__ This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Jaguar Freight Services and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. This e-mail has been scanned for all known viruses. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid3432bid#0486dat1642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] Chart and export question
Hi, I guess you have the chart in the detail section, try moving it to header section. Hope that helps. Raffi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Yiannis Mavroukakis Sent: Wednesday, February 15, 2006 9:40 PM To: jasperreports-questions@lists.sourceforge.net Subject: [jasperreports-questions] Chart and export question Hello, I've been looking at the mailing list archives and I couldn't find an answer to my issue. When I fill in a barchart via a SQL query (it returns 13 records as a tuple) I get the chart rendered with the correct information, but I also get 13 pages of the same chart. Is there something I need to do, to display the chart as one page only? Secondly, is it possible for a chart to be exported to Excel? Thank you! Y. Note:__ This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Jaguar Freight Services and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. This e-mail has been scanned for all known viruses. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Setting style at run-time
I am using iReport 0.5.3 with JasperReports 1.1.1. I have defined a style in my report using iReport and applied it to some text fields (let's call this style 'col_header'). When I run the report from my java program, it works well and also shows the text fields with the applied style. Now, is there a way, where I can get col_header style from report during run-time and modify some of it's properties. I have tried the following way, but this did not work. It still shows the text fields with earlier style. Basically I want to externalize the style for my reports(similar to css in HTML). Any help on this will be greatly appreciated.//Code Snippet JasperPrint jasperPrint = jasperPrint(dataSource, reportParameters, templateLocation);JRStyle style = jasperPrint.removeStyle("col_header");//Altering few properties in style style.setFontSize(12); style.setForecolor(new Color(50,50,50));//Adding the modified style to the report jasperPrint.addStyle(style);JasperExportManager.exportReportToPdfFile(jasperPrint, "/sample.pdf"); //Thanks,Pushkar
Re: [jasperreports-questions] dynamic xls report
Hi, yes, there. Use the crosstab. See example on http://jasperreports.sourceforge.net/samples/index.html Unfortunately yet not exist design graphic tool to draw the crosstab, but you can edit you xml and create it. Manuel Grau Aracil wrote: Hi! I need to make an excel report with dynamic fields and I don't know how. I need to generate a table, but I can't do a design before because the number and name of the colums are variable.Is there a method to do this with Jasper Reports? --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] dynamic xls report
Hi! I need to make an excel report with dynamic fields and I don't know how. I need to generate a table, but I can't do a design before because the number and name of the colums are variable.Is there a method to do this with Jasper Reports?
[jasperreports-questions] export numbers to .xls
Hi, I have problem with exporting numbers to excel files. In my report I want to show java.lang.Double number with pattern #,##0.00 and I want to export this number to excel with this pattern. But when I export this with this pattern, in excel it is not a number, but it is a text. So I have to export numbers without pattern now. Can someone help me, how to export this number to excel like number with pattern #,##0.00 niko __ http://www.email.azet.sk - 2 000 MB na Vase e-maily! --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] HTML tags support in PDF ... feature request
Hi, We only support a few HTML tags in styled-text. I don't think we are going to support all the standard HTML tags, at least not very soon. Thanks, Teodor Kalpesh Chordia wrote: Are there any chances of supporting all standard HTML tags in PDF Exporter and support of HTML in text field in near future ? --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Error MEssage printing using JasperPrint Object
Hi, (sorry for my English, it's terrible) If you try do this, maybe solve you problem: JasperPrint jPrint = JasperFillManager.fillReport(reportFile.getPath(),parameters,con); if(jPrint.getPages().size() 0) { //JasperExportManager.exportReportToPdf(jPrint); //or JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT jPrint); ByteArrayOutputStream baos = new ByteArrayOutputStream(); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, baos); exporter.exportReport(); byte[] bytes = baos.toByteArray(); . } else { //empty report handler } []'s Meenakshi Singh wrote: Anybody...PLEASE HELP me solve this problem. Hi all, I am using JasperPrint.getPages().size() to determine if the report has data in it or not. Depending on the result I m forwarding it to an error page if it doesn't have data. It works fine with html and excel format. However, if I am unable to use it in my pdf report as in my pdf report it doesn't return a jasper print object , it returns bytes. Below is the code for my pdf servlet. Would anybody please help me as to how can I determine if teh report has any data or not in my pdf format. Thanks Regards, Meenakshi. bytes = JasperRunManager.runReportToPdf( reportFile.getPath(), parameters, con); response.setContentType(application/pdf); response.setContentLength(bytes.length); ServletOutputStream ouputStream = response.getOutputStream(); ouputStream.write(bytes, 0, bytes.length); ouputStream.flush(); ouputStream.close(); } --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- Henrique Rogerio de Oliveira Desenvolvedor de Software W3S Solutions www.w3s.com.br +55 11 4052-9376 Ramal: 302 +55 11 2626-7181 Ramal: 302 +55 16 3331-2125 Ramal: 302 +55 16 9777-7495 [EMAIL PROTECTED] --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] RE: Web Application using Jasper Report on Oracle AS running on Redhat linux3.0 Enterprise Server
Hi, I have a web-application using JasperReport I'm having the same problem with my images in the sense the pdf versionis ok without any problems, but the html version of my report isdisplayed without images and bands. The web- application is developedusing Jdeveloper, on Jdeveloper when executed using OC4J it the pdf isfine but the html is without the images, but when deployed on OracleAS running on Redhat Linux3.0 Enetrprise Server nothing works. Does anyone have a soution for this? Thanks and Regards,Ragunatha Reddy Kummetha.
RE: [jasperreports-questions] Empty image map value
Hi Teodor, JFreeChart is used for the chart generation if that is what you mean. I have not written any custom JRRenderable, and I thought it should be fairly straightforward. Here is a little snippet from my prototype report servlet, also showing how the map content was printed: --snip JasperCompileManager.compileReportToFile(jrxmlFile, jasperFile); JasperPrint jasperPrint = JasperFillManager.fillReport( jasperFile, new HashMap(), dbConnection); JRExporter exporter = new JRHtmlExporter(); StringBuffer htmlBuffer = new StringBuffer(); Map imagesMap = new HashMap(); request.getSession().setAttribute(IMAGES_MAP, imagesMap); exporter.setParameter( JRHtmlExporterParameter.IMAGES_MAP, imagesMap); exporter.setParameter( JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter( JRExporterParameter.OUTPUT_STRING_BUFFER,htmlBuffer); exporter.setParameter( JRHtmlExporterParameter.IMAGES_URI, /imageservlet?image=); exporter.exportReport(); for(Object key : imagesMap.keySet()) System.out.println( map entry: key=+key+, value=+imagesMap.get(key)); --snip I'm running it on Tomcat5.5/JDK1.5.0_06/WinXP, if that could provide any further answers. The jrxml file was generated with iReport. What makes it really strange is, as I said, storing the chart image on disk is no problem. Regards, Kjetil -Original Message- From: Teodor Danciu [mailto:[EMAIL PROTECTED] Sent: 12. januar 2006 19:50 To: Kjetil Hoem Cc: jasperreports-questions@lists.sourceforge.net Subject: Re: [jasperreports-questions] Empty image map value Hi, Are you using our chart component or is something custom-made? I'm interested in the JRRenderable implementation behind the scenes. Thanks, Teodor Kjetil Hoem wrote: Hi all, I have a problem that I have been unable to find any information on either in the manual, faqs, forums and this list's archives: The image map (JRHtmlExporterParameter.IMAGE_MAP) populated by the html exporter contains null for what was supposed to be my chart image. A printout of all the items contained in this map looks like this: map entry: key=px, [EMAIL PROTECTED] map entry: key=img_0_0_1, value=null As you can see, the px entry contains an object, and I can confirm that it is the correct image data object, which works fine. The img_0_0_1 entry, on the other hand, contains nothing even though the KEY obviously is present. When I tell the exporter to store the images on disk, everything seems to be fine, and the chart is plotted wonderfully correct. But I don't want to store the images on disk. Does anyone have any idea what may cause this strange behavior? Regards, Kjetil Hoem --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] IS_IGNORE_PAGINATION paramete
Hi IS_IGNORE_PAGINATION is a fill-time parameter, therefore you'll have to set it when filling the report: params.put(JRParameter.IS_IGNORE_PAGINATION, Boolean.TRUE); JasperFillManager.fillReport(jasperReport, params, ..); Note that since the parameter is used at fill time, the JasperPrint object will have no pagination and no exports will be paginated. HTH, Lucian Marco Mistroni wrote: hello all, i m writing a report which needs to be exported in html and csv when the output is csv i want to ignore pagination... i found out that there is a parameter called IS_IGNORE_PAGINATION that needs to be set to true... but i don't know where to call it... shall i call it before JasperFillManager.fillReport? or before exportReport? and on which class i can call it? i tried, when exporting to Csv, to define a parameterMap which contained JRParameter.IS_IGNORE_PAGINATION and JRCsvExporterParameter.FIELD_DEL.IMITER the field delimiter worked fine, but the report completely ignored the IS_IGNORE_PAGINATION anyone could help? thanks and regards marco --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] performane question
hi guys, i'm new here... im just curious how many out there is using jasperreports in a web-based production environment and/or mission-ciritical systems? I might run JasperReports for billing of at least 1200 customer, w/c will result in at a minimum of 3 pages per customer. so that will be 3600 page reports, this will be done twice a month. how do you think JasperReports will scale up? has any one experience any memory leak? any gotcha's that i might expect if I use JasperReports? thanks more power, Richard --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] JUST A TEST
please delete this! I am only trying if i can receive msgs from the list. thanks... --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How to embed the true type font to pdf file with JasperReport
Hi, Thank for your help! My project run! It can export to pdf file with TTF very good! Thank you very much! Cheers, Quang On 12/23/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi Quang, you just need the TTF directory in the classpath and set the filename of the font as pdfFontName=your font name file.ttf, e.g. pdfFontName=Arial.ttf. You have to look for the filename at the directory you add to your application classpath. Or don't you use a jrxml template file? Don't forget to set isPdfEmbedded=true. Kind regards, Marco Hi Marco, I see, but I'd like to know how to write java code use jasper report to export the report to pdf file with embeded true type fonts. Merry Christmas and Happy New Year :-) Regards, Quang On 12/23/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi Quang, I use iReport 0.5.2 and do it like the following: 1. The TTF font directory you like to use has to be in the classpath (startup of iReport and/or start application that creates PDF) 2. In iReport choose tab Font in properties editor, select External TTF font for PDF font name and choose your font below with drop down box True Type font. In the jrxml file just set pdfFontName=your font name file.ttf 3. Choose PDF embedded checkbox to embed the font. In the jrxml file just set isPdfEmbedded =true Also Merry Christmas and a Happy New Year to all out there. Kind regards, Marco Hi all, I'm working with JasperReport on export to pdf file function. My report is in Vietnamese so it can't be read in Adobe Reader.\ I don't know how to write code to embed the true type font (such as Times New Roman, Arial, and so on) to a pdf file. if possible, can you send me a small example? Thank you very much. Merry Christmas and Happy new Year! Best regards, Quang. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Richard Johnson is out of the office.
I will be out of the office starting 12/26/2005 and will not return until 01/03/2006. I will respond to your message when I return. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] compile with ant task
I'm trying to compile with ant task, but a have this error, what mean? ERROR = jasperreports: [echo] + = + [echo] + + [echo] + Compiles the Jasper Reports code + [echo] + + [echo] + = + [jrc] Compiling 3 report design files. [jrc] File : C:\Documents and Settings\vns\Escritorio\eclipse\workspace\campusip\webapp\mantenimiento\beca\becas_report.jrxml ... FAILED. [jrc] Error compiling report design : C:\Documents and Settings\vns\Escritorio\eclipse\workspace\campusip\webapp\mantenimiento\beca\becas_report.jrxml [jrc] net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: [jrc] C:\Documents and Settings\vns\Escritorio\eclipse\workspace\campusip\becas_report.java:4: package net.sf.jasperreports.engine does not exist [jrc] import net.sf.jasperreports.engine.*; [jrc] ^ [jrc] C:\Documents and Settings\vns\Escritorio\eclipse\workspace\campusip\becas_report.java:5: package net.sf.jasperreports.engine.fill does not exist [jrc] import net.sf.jasperreports.engine.fill.*; [jrc] ^ [jrc] C:\Documents and Settings\vns\Escritorio\eclipse\workspace\campusip\becas_report.java:14: package net.sf.jasperreports.engine does not exist [jrc] import net.sf.jasperreports.engine.*; [jrc] ^ - ANT TASK target name=jasperreports depends=javac echo+ = +/echo echo+ +/echo echo+ Compiles the Jasper Reports code +/echo echo+ +/echo echo+ = +/echo taskdef name=jrc classname=net.sf.jasperreports.ant.JRAntCompileTask classpath=${build} classpathref=project.lib/ jrc compiler=net.sf.jasperreports.engine.design.JRJavacCompiler src fileset dir=${webapp}/ include name=**/*.jrxml/ /fileset /src /jrc /target === --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] exit server on close jasper viewer!
Hi Quang, I use iReport 0.5.2 and do it like the following: 1. The TTF font directory you like to use has to be in the classpath (startup of iReport and/or start application that creates PDF) 2. In iReport choose tab Font in properties editor, select External TTF font for PDF font name and choose your font below with drop down box True Type font. In the jrxml file just set pdfFontName=your font name file.ttf 3. Choose PDF embedded checkbox to embed the font. In the jrxml file just set isPdfEmbedded =true Also Merry Christmas and a Happy New Year to all out there. Kind regards, Marco Hi all, I'm working with JasperReport on export to pdf file function. My report is in Vietnamese so it can't be read in Adobe Reader.\ I don't know how to write code to embed the true type font (such as Times New Roman, Arial, and so on) to a pdf file. if possible, can you send me a small example? Thank you very much. Merry Christmas and Happy new Year! Best regards, Quang. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Text cutting off for PDF exports (Linux only)
When exporting a report to PDF under Linux I end up loosing the last few lines of a large text area . This does not happen under Windows and it does not happen in JasperAssistant's preview. It happens through JasperAssistant's export and through my webapp...so it shouldn't be my code. I have tried messing with fonts but nothing helps. Any Ideas? Thanks. -Alan --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] isStretchWithOverflow in Subreports?
Make sure the report that is including the subreport also has stretch set. [EMAIL PROTECTED] wrote: Hi! I have a subreport which consists only of the detail band. The height of the detail band is exactly the height of the textfied it contains. For that textfield I set isStretchWithOverflow to true. But the textfield doesn't stretch. It rather truncates its contentents. Any clues? Regards, Tobias --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- Larry Singer Smart Health Solutions Pty Ltd 39 Phillip Street, Sydney, 2000 Phone (02) 9247 3799 http://www.smarthealth.com.au --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] How to use Sub-Report using iReport.
Hi, I am new to iReports. I am trying to create a sample report with a sub-report. The parent and child reports are simple reports without any datasource. They simply display some static text. When I run the parent report I can only see the content of the parent report and not the child report. Can any one help me with this problem? I am sending the two templates I have used for the sample. Thanks in advance. Venkat ?xml version=1.0 encoding=UTF-8 ? !-- Created with iReport - A designer for JasperReports -- !DOCTYPE jasperReport PUBLIC //JasperReports//DTD Report Design//EN http://jasperreports.sourceforge.net/dtds/jasperreport.dtd; jasperReport name=Parent columnCount=1 printOrder=Vertical orientation=Portrait pageWidth=595 pageHeight=842 columnWidth=535 columnSpacing=0 leftMargin=30 rightMargin=30 topMargin=20 bottomMargin=20 whenNoDataType=NoPages isTitleNewPage=false isSummaryNewPage=false property name=ireport.scriptlethandling value=0 / import value=java.util.* / import value=net.sf.jasperreports.engine.* / import value=net.sf.jasperreports.engine.data.* / background band height=0 isSplitAllowed=true /band /background title band height=50 isSplitAllowed=true staticText reportElement mode=Opaque x=186 y=7 width=161 height=36 forecolor=#00 backcolor=#FF key=staticText-1 stretchType=NoStretch positionType=FixRelativeToTop isPrintRepeatedValues=true isRemoveLineWhenBlank=false isPrintInFirstWholeBand=false isPrintWhenDetailOverflows=false/ box topBorder=None topBorderColor=#00 leftBorder=None leftBorderColor=#00 rightBorder=None rightBorderColor=#00 bottomBorder=None bottomBorderColor=#00/ textElement textAlignment=Center verticalAlignment=Top rotation=None lineSpacing=Single font fontName=Arial pdfFontName=Helvetica size=10 isBold=false isItalic=false isUnderline=false isPdfEmbedded =false pdfEncoding =Cp1252 isStrikeThrough=false / /textElement text![CDATA[Parent Report]]/text /staticText /band /title pageHeader band height=50 isSplitAllowed=true /band /pageHeader columnHeader band height=30 isSplitAllowed=true /band /columnHeader detail band height=492 isSplitAllowed=true subreport isUsingCache=false reportElement mode=Opaque x=14 y=13 width=512 height=475 forecolor=#00 backcolor=#FF key=subreport-1 stretchType=RelativeToBandHeight positionType=Float isPrintRepeatedValues=true isRemoveLineWhenBlank=false isPrintInFirstWholeBand=false isPrintWhenDetailOverflows=false/ subreportParameter name=company_name subreportParameterExpression![CDATA[from_parent]]/subreportParameterExpression /subreportParameter subreportExpression class=java.lang.String![CDATA[Child.jasper]]/subreportExpression /subreport /band /detail columnFooter band height=30 isSplitAllowed=true /band /columnFooter pageFooter band height=50 isSplitAllowed=true /band /pageFooter lastPageFooter band height=50 isSplitAllowed=true /band /lastPageFooter summary band height=50 isSplitAllowed=true /band /summary /jasperReport ?xml version=1.0 encoding=UTF-8 ? !-- Created with iReport - A designer for JasperReports -- !DOCTYPE jasperReport PUBLIC //JasperReports//DTD Report Design//EN http://jasperreports.sourceforge.net/dtds/jasperreport.dtd; jasperReport name=Child columnCount=1 printOrder=Vertical orientation=Landscape pageWidth=425 pageHeight=283 columnWidth=397 columnSpacing=0 leftMargin=14 rightMargin=14 topMargin=14 bottomMargin=14 whenNoDataType=NoPages isTitleNewPage=false isSummaryNewPage=false property name=ireport.scriptlethandling value=0 / import value=java.util.* / import value=net.sf.jasperreports.engine.* / import value=net.sf.jasperreports.engine.data.* / parameter name=company_name isForPrompting=true class=java.lang.String defaultValueExpression ![CDATA[from_child]]/defaultValueExpression /parameter background band height=96 isSplitAllowed=true staticText reportElement mode=Opaque x=26 y=7 width=349 height=82 forecolor=#00 backcolor=#FF key=staticText-2 stretchType=NoStretch positionType=FixRelativeToTop isPrintRepeatedValues=true isRemoveLineWhenBlank=false isPrintInFirstWholeBand=false isPrintWhenDetailOverflows=false/ box topBorder=None topBorderColor=#00 leftBorder=None leftBorderColor=#00 rightBorder=None rightBorderColor=#00 bottomBorder=None bottomBorderColor=#00/ textElement textAlignment=Center verticalAlignment=Top rotation=None lineSpacing=Single font fontName=Arial pdfFontName=Helvetica
Re: [jasperreports-questions] 2 details band
I see. I would create one array for detail band you want, ie one for Schools, one for Hospitals, etc. The Arrays should either be of JavaBeans or of Maps. If you use JavaBeans, follow the naming conventions in the Beans specs to expose specified fields in the beans. If you use a Map, each entry consists of a key that is the field name and the value.When you have your array, wrap it in either a JRMapArrayDataSource or a JRBeanArrayDataSource. Both of these objects implement the JRDataSource interface, and can be used as the source of data. When you include the subreports be sure to specify a dataSourceExpression that evaluates to the correct object.-BarryOn Dec 7, 2005, at 3:50 AM, neqo seppuku wrote:at that time, what should be the subreportParameterExpression let me explain how I take the data to my masterreport from java, I have created a list and object array, and these objects to list, and send this list to the report. let say there are 3 fields in the master report: Object[] obj = new Object[3] and in for loop list.add(obj); that puts the data in report. now does an Object can take a list of data, and in connection _expression_ can I use $F instead of $P ? thanks...On 12/6/05, Barry Klawans [EMAIL PROTECTED] wrote: Hmm, I'd say that depends on the amount of data in each sub report. You could pull out the data in your code and convert it into an array of beans, and pass those to the subreports to use as a data source.-BarryOn Dec 5, 2005, at 12:17 AM, neqo seppuku wrote:in the subreport, there should not be sql query, I want to passes all fields to subreport with datasource, how can I do this ? does subreportParameter has to be only one value, how can I pass more than one parameters to subreport ? thanks...On 12/3/05, Barry Klawans [EMAIL PROTECTED] wrote: Create a subreport for Schools and a subreport for Hospitals. A subreport is basically a report that can be placed inside another report. You author it just like any other report, but don't set the page size to be bigger than you need for editing. Then create a new report, place both subreports inside it, and you are done. Take a look at the "subreport" sample include in the distribution.-BarryOn Dec 2, 2005, at 5:21 AM, neqo seppuku wrote: hi all, I need to design my report with two details band, like this, there sholud be two parts in the report that dynamically grow :for example : SCHOOLS school name school id location school1 1 city1 school2 2 city2 .. HOSPITALS hospital address phone #of doctors hospital1 adres1 1 5 hospital2 adres2 2 6 these two information parts should include in the same report, the number of records are dynamic, so how can I solve this problem. is it possible to do this in jasperreports? thanks...
[jasperreports-questions] report analysis
Hi all, is it possible to load a give report design xml template, and find out programmatically how many parameters the report has, and there Report Labels? Kind regards Juergen Hoffmann signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
[jasperreports-questions] [Fwd: JRLoader.loadObject parameter]
What is the fileName parameter? JRLoader.loadObject(String fileName) fileName = file or fileName = c:/file is complete path or relative pls help --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] how to logging
how to logging, configure my project for debug help --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Crosstab headers...
Hi, I'm working with JasperReports in a litle custom report generator, from an web user interface. My question is, when I implement a crosstab report, why I can´t add headers for the rowgroups and the columngroups? (view figure). My only chance to add headers to the rowgroups and column groups is modify the source code, is rigth?. Sorry by my poor english, and best regards. Sent from the jasperreports-questions forum at Nabble.com: Crosstab headers...
[jasperreports-questions] linux jasper error
hi all, I have an application which is developed using websphere studio uses jasper reports 1.1.0. The hasper reports works fine in websphere. However, the application needs to be deployed on Linux. When I try to deploy the application on Linux itwas giving me the following error given below: [11/29/05 11:39:13:076 IST] e9353f0 WebGroup E SRVE0026E: [Servlet Error]-[Can#39;t connect to X11 window server using #39;:0.0#39; as the value of the DISPLAY variable.]: java.lang.InternalError: Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable. at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method) at at sun.awt.X11GraphicsEnvironment.clinit(X11GraphicsEnvironment.java:161).null(Unknown Source) at java.lang.Class.forName1(Native Method) at java.lang.Class.forName(Class.java(Compiled Code)) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:90) at net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer Now Even after executing these commands, #xhost +also add -Djava.awt.headless=true argument on start script of your application.I am getting the following error: [11/30/05 11:03:40:448 IST] 6712a646 WebGroup E SRVE0026E: [Servlet Error]-[sun/awt/X11GraphicsEnvironment]: java.lang.NoClassDefFoundError: sun/awt/X11GraphicsEnvironment at java.lang.Class.forName1(Native Method) at java.lang.Class.forName(Class.java(Compiled Code)) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:90) at net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer.java:58) at net.sf.jasperreports.engine.fill.JRBaseFiller.init(JRBaseFiller.java:412) at net.sf.jasperreports.engine.fill.JRVerticalFiller.init(JRVerticalFiller.java:91) at net.sf.jasperreports.engine.fill.JRVerticalFiller.init(JRVerticalFiller.java:73) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:113) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:57) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at com.mind.tms.report.HtmlServlet.service(HtmlServlet.java:127) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) Please help Thanks Regards, Meenakshi
[jasperreports-questions] exit server on close jasper viewer!
Hi, I have tried with your solution: JasperViewer.viewReport(jasperPrint,false); but it still stop server, I don't know why! Do you have another solution? Thank you so much! Regards, Quang --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] JasperReports Book
A couple questions: 1. Does the eBook available at http://jasperreports.sourceforge.net/more.docs.html cover the 1.x version of JasperReports? 2. Are there any other books about JasperReports available? TIA, Jim McLean --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637_id=16865=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] JasperReports Book
We update the book every time there is a new release, so the current version covers up through the 1.1 release. We will be offering an annual subscription service soon which will allow you go get all the new versions of the doc for a year. That should be available in a week or two.I'm not aware of any other JasperReports book.-Barry KlawansOn Nov 23, 2005, at 12:58 PM, Jim McLean wrote:A couple questions: 1. Does the eBook available at http://jasperreports.sourceforge.net/more.docs.html cover the 1.x version of JasperReports? 2. Are there any other books about JasperReports available? TIA, Jim McLean --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
AW: [jasperreports-questions] Calculation between a Field and a Variable
That sounds complicated to me. If you do select count(*) in the title band you will also be able to do that in the select statement of the report. Why do you use a subreport to calculate? select a.price, (100/sum(b.price))*a.price from pricing_table a, pricing_table b group by a.price; I'm not sure if not all databases can execute this statement but I think so. Regards, Marco -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Martin Clough Gesendet: Montag, 21. November 2005 17:57 An: jasperreports-questions@lists.sourceforge.net Betreff: Re: [jasperreports-questions] Calculation between a Field and a Variable The only way I have been able to achieve this is to have an invisible sub-report in the report title band which performs the total calculation (eg select count(*)...) and passes this back as a variable. Martin On 21/11/05, Paolo [EMAIL PROTECTED] wrote: Hello everyone, my name is Paolo and this is my first email to this list. I used JasperReports for my thesis project, and now I keep using it at work. I would like to ask you all an hint on how to do something. The thing that I (well, someone else...) desire to do is to have a column which each value of it is calculated using as operands a Field and a Variable. For example, if I have a column Price and the total of it in the group footer, I would like to have for each price the percentage of it on the total. Example: Price Percentage 2.00 20% 3.00 30% 5.00 50% Total 10.00100% In this example the column percentage is calculated using the price Field and the Variable that stores its total in the end of the group. I am not sure how to do this... I think I may get that data from the report's source query but I was looking for a way to do it with Jasper. Thank you in advance for any hint, Paolo --- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_idv28alloc_id845op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
RE: [jasperreports-questions] subreport is not loading in parent PDF
I solve the error.I have forgotten to pass datasource(used in child) in paramater from java class --- On Tue 11/22, jyoti Ranjan Sahu [EMAIL PROTECTED] wrote: From: jyoti Ranjan Sahu [mailto: [EMAIL PROTECTED] To: jasperreports-questions@lists.sourceforge.net Date: Tue, 22 Nov 2005 03:30:21 -0500 (EST) Subject: [jasperreports-questions] subreport is not loading in parent PDF brbrbrHi all,brbr I am using subreport and emptydatasoucrce to generate pdf file.Blank value is inluded in parent PDF.brbrbrbrbrbrPARENT PDF FILEbrbrbrbr?xml version=1.0 encoding=UTF-8?brbr!DOCTYPE jasperReport PUBLIC -//JasperReports//DTD Report Design//EN http://jasperreports.sourceforge.net/dtds/jasperreport.dtd;brbrbrbrjasperReport name=MultiReport pageWidth=565 pageHeight=842 columnWidth=545 leftMargin=10 rightMargin=10 topMargin=30 bottomMargin=30brbr brbrimport value=net.sf.jasperreports.engine.* /brbr import value=net.sf.jasperreports.engine.data.* /brbr parameter name=childpdf class=net.sf.jasperreports.engine.JasperReport/parameter brbrparameter name=SAMPLES_DATASOURCE class=net.sf.jasperreports.engine.JREmptyDataSource/brbrbrbr titlebrbr band height=35brbr staticTextbrbr reportElement x=0 y=0 width=520 height=30 /brbr text![CDATA[ParentTitle:]]/textbrbr /staticText brbrlinebrbr reportElement x=0 y=30 width=520 height=1 /brbr graphicElement /brbr /linebrbr /bandbrbr /titlebrbrbrbr pageHeaderbrbrband/bandbrbr /pageHeaderbrbr detailbrbrband height=30 brbr staticTextbrbr reportElement x=5 y=5 width=400 height=15 isPrintWhenDetailOverflows=false /brbr text![CDATA[ParentColumn:]]/textbrbr /staticText brbrbrbrsubreportbrbr reportElement positionType=Float x=0 y=20 width=1 height=1 isRemoveLineWhenBlank=true backcolor=#99ccff /brbr brbr dataSourceExpression ![CDATA[$P{SAMPLES_DATASOURCE}]]/dataSourceExpressionbrbr brbrsubreportExpression class=net.sf.jasperreports.engine.JasperReportbrbr ![CDATA[$P{childpdf}]]brbr /subreportExpressionbrbr /subreportbrbr brbr/bandbrbr /detailbrbr pageFooterbrbrband height=40brbr brbr staticTextbrbr reportElement x=280 y=20 width=75 height=15 /brbr text![CDATA[ParentPage:]]/textbrbr /staticText brbrbrbr/bandbrbr /pageFooterbrbr/jasperReportbrbrbrbrbrbrbrbrbrbrbrbrCHILD PDFbrbr-brbrbrbr?xml version=1.0 encoding=UTF-8?brbr!DOCTYPE jasperReport PUBLIC -//JasperReports//DTD Report Design//EN http://jasperreports.sourceforge.net/dtds/jasperreport.dtd;brbrbrbrjasperReport name=OrderHistory pageWidth=565 pageHeight=842 columnWidth=545 leftMargin=10 rightMargin=10 topMargin=30 bottomMargin=30brbr brbrtitlebrbr band height=50brbr linebrbr reportElement x=0 y=10 width=520 height=1 /brbr graphicElement /brbr /linebrbr staticTextbrbr reportElement x=0 y=12 width=345 height=30 /brbr textElement brbr/textElementbrbr text![CDATA[Child Title:]]/textbrbr /staticTextbrbr /bandbrbr /titlebrbrbrbr pageHeaderbrbrband/bandbrbr /pageHeader brbrbrbrcolumnHeaderbrbr band height=20brbr staticTextbrbr reportElement x=0 y=2 width=130 height=15 /brbr brbrtextElementbrbr font isUnderline=true/brbr /textElementbrbr text![CDATA[child_column_1]]/textbrbr /staticTextbrbr staticTextbrbrbrbr reportElement positionType=Float x=130 y=2 width=130 height=15 /brbrtextElementbrbr font isUnderline=true/brbr /textElementbrbr
Re: [jasperreports-questions] Jdt-Compiler + Java 1.5
Hi We've added initial support for Java 1.5 compilation: the JDT compiler jar has been upgraded to 3.1.1 and JR or system properties specify whether 1.5 compilation should be perfomed (as suggested by Havier). There is a sample that shows how 1.5 compilation can be used. To be noted that some things (like generic types for parameters/variables) are not yet supported. Regards, Lucian Chirita Xavier Frisaye wrote: Thanks again for replying. It works only when i use the 3 parameters related to jdk version : settings.put(CompilerOptions.OPTION_Compliance, CompilerOptions.VERSION_1_5); settings.put(CompilerOptions.OPTION_Source, CompilerOptions.VERSION_1_5); settings.put(CompilerOptions.OPTION_TargetPlatform, CompilerOptions.VERSION_1_5); But for more usability (working with system properties), I made this patch to JRJdtCompiler at line 301 : Enumeration systemPropertiesName = System.getProperties().propertyNames(); while (systemPropertiesName.hasMoreElements()) { String systemPropertyName = (String) systemPropertiesName.nextElement(); String systemPropertyValue = (String) System.getProperties().get(systemPropertyName); if ( systemPropertyName.startsWith(org.eclipse.jdt.core.compiler) systemPropertyValue != null systemPropertyValue.length() 0) { log.info(Adding system property \ + systemPropertyName + \ with value \ + systemPropertyValue + \ to compiler settings map); settings.put(systemPropertyName,systemPropertyValue); } } Is-it possible to make similar functionality in future release? Of course, only if the community think it could be useful and it was not done yet. ;-) Regards, Xavier Frisaye -Original Message- From: Lucian Chirita [mailto:[EMAIL PROTECTED] Sent: lundi 3 octobre 2005 17:21 To: jasperreports-questions@lists.sourceforge.net Subject: Re: [jasperreports-questions] Jdt-Compiler + Java 1.5 You can also set settings.put(CompilerOptions.OPTION_TargetPlatform, CompilerOptions.VERSION_1_5); if you want 1.5 class files generated.. Lucian Chirita wrote: Hi If you want to use 1.5 code in your report, you'll have to set the following option when compiling the report (in JRJdtCompiler.java): settings.put(CompilerOptions.OPTION_Source, CompilerOptions.VERSION_1_5); Regards, Lucian Xavier Frisaye wrote: Thanks a lot for your reply. Your patch seems to work but i'm encountering another problem, i have the same auto-boxing compilation error than with the non 3.1 jdt-compiler : Caused by: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Cannot cast from boolean to Boolean value = (java.lang.Boolean)(true); --- 2. Cannot cast from boolean to Boolean value = (java.lang.Boolean)(true); --- 3. Cannot cast from boolean to Boolean value = (java.lang.Boolean)(true); --- 3 errors Is there a way (sys property or any) to activate Java 1.5 compilation in Jdt-Compiler? Best regards, Xavier -Original Message- From: Lucian Chirita [mailto:[EMAIL PROTECTED] Sent: lundi 3 octobre 2005 15:07 To: jasperreports-questions@lists.sourceforge.net Subject: Re: [jasperreports-questions] Jdt-Compiler + Java 1.5 Hi Xavier The following patch ensures support for the 3.1 Jdt compiler: http://sourceforge.net/tracker/index.php?func=detailaid=1233072group_id=36382atid=416705 JRJdtCompiler rev 1.12 supports both the 3.1 compiler and the one distributed with JasperReports. This is part of the 1.0.0 release. If upgrading to 1.0.* is not an option, you could apply the patch to the 0.6.7 sources and use the 3.1 compiler. HTH, Lucian Xavier Frisaye wrote: Hi all, I'm using Jasper Reports 0.6.7 with Java 1.5 and JavaC for template compilation . But i would try to use jdt compiler instead of JavaC but it doesn't work with Java 1.5 (autoboxing compilation error). I also try the lastest jdt compiler from Eclipse (3.1.0) but it seems its api has changed and it is no more compatible with Jasper 0.6.7. Am i missing something? Does anyone have this problem? Regards, Xavier Frisaye --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions --- This SF.Net email is sponsored by: Power Architecture Resource
Re: AW: [jasperreports-questions] Calculation between a Field and a Variable
Have you tried using the evaluationTime=Group attribute of the textField? Yes, I did try that, Jason. I'm not sure if it'll evaluate properly, $F{price} may be gone at Group time, but it is worth a try. Yes, I thought it was worth a try as well, and, as you suspected, it doesn't work because using the Group evaluation time the Field value is gone. Better said, every column using the field in that group will have the value of that field in the LAST column of that group. Paolo P.S. Now I am studying how to do it with subreports, as Jacob suggested. It's gonna be not easy I think, and it will have to be placed on the group header because the value that it calculates has to be specific for every group. Thank you everyone for the hints (if someone else has other ideas I would still like that hear them ;-) ), if/when I will sort this out I will post my solution. --- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=7628alloc_id=16845op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Using a .jprint as subreport
Hi all, I have the following scenario: I have one already generated .jrprint (filled report). How can i insert this file, keeping its data, into another report? In summary, i need to insert in one master report, two other fullfilled reports that i generated sometime ago. The master report will have the data of the two other report plus its own. Any ideas. Regards, Thiago Almeida --- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_idv28alloc_id845op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] multiple column header
Hi all, I want to render PDF report with respect to attached word document. Could anybody please solve this technical issue. reagrds Jyoti ___ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com report.doc Description: Binary data
Re: [jasperreports-questions] Compatibility Problem i_Report_0_2_3 and i_Report-0.5.1
Hi Your error is due to a bug (#1290957) that was fixed in JasperReports 1.0.3. iReport 0.5.1 comes with JR 1.0.1, you could download JR 1.0.3 and replace it in the iReport lib directory. HTH, Lucian janardhana p wrote: Hi, We have compiled the old report files with i_Report-0.5.1. We are getting the following exception when there is a subreport in title page section and the main query(report) returns 0 rows. [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R java.lang.ClassCastException: net/sf/jasperreports/engine/base/JRBasePrintPage incompatible with net/sf/jasperreports/engine/base/JRVirtualPrintPage [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.Throwable.init(Throwable.java) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.Throwable.init(Throwable.java) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr nbs p; R at java.lang.ClassCastException.init(ClassCastException.java:53) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.registerSubfiller(JRBaseFiller.java:1719) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:727) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.Thread.run(Thread.java:802) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R java.lang.ClassCastException: net/sf/jasperreports/engine/base/JRBasePrintPage incompatible with net/sf/jasperreports/engine/base/JRVirtualPrintPage [11/17/05 11:57:10:909 EST] 5e70 5e7 SystemErr R at java.lang.Throwable.init(Throwable.java) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.Throwable.init(Throwable.java) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.ClassCastException.init(ClassCastException.java:53) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.registerSubfiller(JRBaseFiller.java:1719) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:727) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R nbs p;at java.lang.Thread.run(Thread.java:802) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R NESTED BY : [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R java.lang.ClassCastException: net/sf/jasperreports/engine/base/JRBasePrintPage incompatible with net/sf/jasperreports/engine/base/JRVirtualPrintPage [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.Throwable.init(Throwable.java) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.Throwable.init(Throwable.java) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.ClassCastException.init(ClassCastException.java:53) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.registerSubfiller(JRBaseFiller.java:1719) [11/1 7/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:727) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R at java.lang.Thread.run(Thread.java:802) [11/17/05 11:57:10:909 EST] 5e705e7 SystemErr R NESTED BY : If we move subreport from title section to summary section then the report is working fine. Please throw some light on this to resolve this problem. Thanks in Advance. Jana. Yahoo! FareChase - Search multiple travel sites in one click. http://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/ --- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=7628alloc_id=16845op=click ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions