2006 JR Open Discussion

By: meenamca - meenumca To generate report 2006-01-23 19:27 hi, Good Morning, I am new to this forum and this is my first question.I am doing a project with NetBeans IDE4.1 and MS-Access.My OS is Windows Server 2003.Can I use Jasper Report for my project? Can I download Jasper Report and use well with the softwares used by me? By: Alexander Wallace - aows RE: To generate report 2006-01-23 19:40 As far as Netbeans 4.1 and JasperReports, Certainly. The other elements you mention are unknown to me. But if they both run in the same enviroment as you are running netbeans, it should work fine. By: meenamca - meenumca RE: To generate report 2006-01-23 20:35 hi, Thank you so much for your quick reply.I saw your reply and dwonloaed the following 1.jasperreports-1.1.1-applet.jar 2.jasperreports-1.1.1.jar in the following directory. C:Documents and SettingsAdministrator. When I open this file I got the following error message. Failed to Load Main-Class manifest attribute form C:Documents and SettingsAdministratorjasperreport-1.1.1-applet.jar What is my error.Please help me to solve this,then only I can start report module of my project. Thank you so much. Is any mistake in my way of downloading? By: Vinod Kumar Singh - vinodsingh RE: To generate report 2006-01-24 01:03 Look at the tutorial at: http://jasperreports.sourceforge.net/tutorial/index.html jasperreport-1.1.1-applet.jar does not have a main class. Try to dig in deeper in the documentation. Vinod By: venz98 - venz RE: To generate report 2006-02-08 17:00 Ive also encountered the same problem, when i try opening the file. I've even try to redownload the two files, because i thought their is something wrong with my download. But when i try opening it again..still the same problem i encounter. Venus By: venz98 - venz RE: To generate report 2006-02-19 18:26 I've already found a solution to our problem: The error means that this jar file(jasperreport-1.1.1-applet.jar) is not an application. Since on Window platform you can create a jar file and allow it to be launched by double-click on it by specifying the "Main-Class" attribute in the Manifest file. This jar file is just a regular jar file, technically it is a zip file since it uses the same compression method. You can use a WinZip utility on Window to open and extract it or using the jar command to extract its content. To extract the content of the jar file by using the Java's jar command type the following at the command prompt(Make sure your PATH contains the path to you Java JDK): jar xvf jasperreport-1.1.1-applet.jar venz By: stone_cold - bssai RE: To generate report 2006-02-19 22:03 Guys relax, U got the latest version of JR 1.2 relased 10 days ago..try to download that. http://sourceforge.net/project/showfiles.php?group_id=36382&package_id=28579 I had downloaded it and had no issues with it. Austin

By: stone_cold - bssai Using Jasper Reports with Hibernate 2006-02-17 01:10 I have a query or concern with respect to the JasperDesign class of the Jasper reports. Let me be more clear on wat i would like to say, If u see the examples or samples which are under the samples folder of JSR/demo/samples/noxmldesign/ provided along with the binary , this particular struture has been given for those who does nt want to use the designing tool or to be precise the .jrxml file. I am ok with creating my own structure. But the problem i am facing is In the program u have to pass the query to fill the report.But i already have the data in the form of objects using Hibernate. Now if at all i pass on the query again..Does it mean that i am doing a repeatition of the code by executing the query twice. Let me show us with example. This part of the code is in jsr/demo/samples/noxmlDesign/noxmlDesignApp.java //Query JRDesignQuery query = new JRDesignQuery(); query.setText("SELECT * FROM Address $P!{OrderByClause}"); jasperDesign.setQuery(query); Here is the click I dont want to send a query string again coz i have already got the queries data..i mean the result. I hope u got my point. Looking ahead for ur reply, By: Teodor Danciu - teodord RE: Using Jasper Reports with Hibernate 2006-02-17 02:11 Hi, Supplying a query in the report template is optional. If you already have you data in-memory, you could wrap it using JRBeanCollectionDataSource implementation and pass this data source to the report filling process. Look at the supplied /demo/samples/datasource sample provided with the project. I hope this helps. Teodor

By: venz98 - venz Why use jasper reports? 2006-02-08 16:55 Hi! I've just heard about jasper reports. My immediate boss wants to know my recommendation regarding this matter. Please help me Can you give me the reasons why you are using jasper reports. Thanks, Venus By: jasperkan - jasperkannan RE: Why use jasper reports? 2006-02-10 17:02 the best available reporting tool in opensource at the moment. full support of the Open source industry with SourceForge GNLU licensed Very flexible and powerful with features like subreports eg master /detail reports easy database support with the data source customizable from a JDBC , Collection etc . Can easily plugin custom java code for processin business logic of the returned data using Scriptlets Very fast Features addition with full feature request support Very good response/mailing support / user groups community with direct mails from Teodar (father of Jasper Reports) can make Dynamic reports at run time which is a big advantage compared to Crystal reports . PS : I work in a product development company in insurance/benefits and use this tool. we were using crystal reports and switched to jasper since crystal wasnt allowing us to generate dynamic reports on the fly. By: raffimd - raffimd RE: Why use jasper reports? 2006-02-13 01:05 Hi Kannan, Can you please share little more on how do you make use of jasperReports to define the dynamic reports. Is it by passing parameters? Thanks, Raffi By: jasperkan - jasperkannan RE: Why use jasper reports? 2006-02-14 09:50 u can conditionally show/hide a field based on PrintWhenExpression dynamically change the label of a column by using a java expression which check for a flag and display the field header differntly. $P{REPORT_FOR}.equals("A")?"MEMBER":"BILLING"

By: amodg - amodg IllegalArgumentException Sheet name cannot... 2006-02-14 05:50 Hi, I am trying to export my report in MSExcelSheet using net.sf.jasperreports.engine.export.JRXlsExporter class.While doing that, I am getting an Exception as... java.lang.IllegalArgumentException: Sheet name cannot be blank, greater than 31 chars, or contain any of /*?[] at org.apache.poi.hssf.record.BoundSheetRecord.setSheetname(BoundSheetRe cord.java:175) at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:458) at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:452) at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.j ava:369) at net.sf.jasperreports.engine.export.JRXlsExporter.createSheet(JRXlsExp orter.java:126) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport ToStream(JRXlsAbstractExporter.java:279) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport (JRXlsAbstractExporter.java:154) Could you plzzzzz.... help me out...? I am eagerly waitng for any reply.... Thanks in advance !!!! -Amod

By: Per Nyfelt - per_nyfelt jasperreports-portal 2006-02-04 06:03 Hi, I would like to get the jasperreports-portal working on jboss-portal 2.2.1. Deployment descriptor among other things has changed. also it would be nice to upgrade to use the latest JR release. I wanted to check if someone had already started to look at upgrading but I cannot find jasperreports-portal in CVS. Cound someone please point out where to find it? Best regards, Per By: Barry Klawans - bearklaw RE: jasperreports-portal 2006-02-07 13:56 Hi Per, Looks like the source didn't get added for some reason. I'll track it down and put it on SourceForge. -Barry By: Barry Klawans - bearklaw RE: jasperreports-portal 2006-02-07 14:55 By the way, the source is available from the files download area, its just not in CVS currently. Download jasperreports-portal.src.zip. -Barry By: Teodor Danciu - teodord RE: jasperreports-portal 2006-02-08 06:42 Hi, The JasperReports Portal application is now on the public Sourceforge CVS repository here: http://cvs.sourceforge.net/viewcvs.py/jasperreports/jasperreports-portal/ Thanks, Teodor By: rrogger - rrogger RE: jasperreports-portal 2006-02-10 11:02 Excuse, please. Sorry for poor English. What is license for jasperreports-portal. Not found in CVS or download. Cheers, -R By: Barry Klawans - bklawans RE: jasperreports-portal 2006-02-10 13:46 LGPL. I'll make sure it gets added in the immediate future. -Barry

By: jessica - zhou527 Reports can't be viewed with running portal 2006-02-10 08:34 I followed JasperReports Portal installation guide and I deployed two war files. The jrxml files can be uploaded, but I have the problem of viewing the report: nothing shows up to the report viewer. I checked my report file, which does contain a-few-page data. JBOSS runs fine except some warnings. I can't figure out the problem from the warnings, but I still post them as following in case any of you need them to see a problem. Thanks for your kind help. 2006-02-09 17:15:26,796 WARN [org.jboss.portal.core.invocation.StrategyInterceptor] No strategy name found, using 'default' 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] looking for strategy with name: default 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] found strategy to use: org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] adding region: center 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] adding region: left 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.StrategyFactory] creating portlet context for: ReportDisplayPortletWindow 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.StrategyFactory] creating portlet context for: ReportListPortletWindow 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.StrategyFactory] creating portlet context for: ReportListPortletWindow 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.StrategyFactory] creating strategy context for: 2ColumnLayout jasperreports-portal front 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl] evaluating strategy for: org.jboss.portal.core.theme.impl.PortalLayoutImpl@11cbec9 />2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl] evaluating portlet: ReportDisplayPortlet 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl] evaluating portlet: ReportListPortlet 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] setting layout URI: /layouts/twoColumns.jsp 2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] done analyzing layout strategy 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.servlet.CoreServlet] requesting theme: null 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.servlet.CoreServlet] using layout returned from the strategy: 2ColumnLayout uri: /layouts/twoColumns.jsp 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.servlet.CoreServlet] got layout to use [2ColumnLayout] in app [/jasperreports-layout] uri [/layouts/twoColumns.jsp] 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.theme.LayoutDispatcher] got request dispatcher for layout resource: true 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] rendering theme ... 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] got theme to render: null 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] requested theme not found. Is there a theme attribute in the tag ? jasperreports 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.impl.ThemeServerImpl] get theme jasperreports 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.impl.ThemeServerImpl] found theme jasperreports 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] Found valid theme to render: null 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] get link ... 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] returning: <link rel='stylesheet' type='text/css' href='/jasperreports-layout/jasperreports.css' media='screen' /> 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] writing theme link: <link rel='stylesheet' type='text/css' href='/jasperreports-layout/jasperreports.css' media='screen' /> 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] get link ... 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] returning: <link rel='stylesheet' type='text/css' href='/jasperreports-layout/jasperreports.css' media='screen' /> 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] done rendering theme 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] rendering left [vertical] 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] done rendering page region 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] rendering center [vertical] 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] done rendering page region 2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.theme.LayoutDispatcher] done with the layout 2006-02-09 17:18:20,015 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000 2006-02-09 17:25:50,015 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000 By: jessica - zhou527 RE: Reports can't be viewed with running portal 2006-02-10 08:54 By the way, my environments: iReport-1.1.0 jboss-portal-2.0.1-jboss-4.0.3SP1 JBoss Reporting Portal JR 1.0.3 Note: since iReport-1.1.0 is using jasperReport-1.1.1 to generate reports, I changed jasperReport-1.0.3 for JBoss Reporting Portal JR 1.0.3 to jasperReport-1.1.1.

By: jasperkan - jasperkannan Subreport path in a Web App 2006-01-20 07:03 i have a main report with a subreport and its working fine in the Ireports env .But when i deploy it to the WebApplication , the SUBREPORT_FILE_NAME has to specified as a relative URL ie /reports/subreport.jasper. this doesnt seem to work and its expecting the absolute path to be specified !!!!! . i tried all options like going one directory down ie subreport.jasper ./subreport.jasper ../reports/subreport.jasper /WEB-INF/resources/reports/subreport.jasper Is there any way to make jasper understand the relative URL ? Thanks n advance. By: Lucian Chirita - lucianc RE: Subreport path in a Web App 2006-01-24 01:10 JR resolves reports (including subreports) locations as fs paths or class loader resources. If you specify a relative file path it will be interpreted relative to the current user directory. You can alternatively add the reports directory to the classpath and specify the subreport location as resource name. HTH, Lucian By: William Baker - wlbaker RE: Subreport path in a Web App 2006-02-09 07:48 I use a different method. My reports use a parameter "BaseDir", which is "prompt=no" and populated by the report generating JSP. It has a default value that allows for good behavior in JasperAssistant. The subreport is then referenced as new File( $P{BaseDir}, "subreport.jasper" ); bbaker

By: kamal - kamalakarareddy Why my datasetRun not accepting dataSourcePar 2006-02-08 12:15 Why my datasetRun is not accepting dataSourceParameter Do you think my template is not set with this? <!ELEMENT datasetRun (parametersMapExpression?, datasetParameter*, (connectionExpression | dataSourceExpression)?)> <datasetRun subDataset="Country_Orders"> <dataSourceExpression><![CDATA[$P{CommodityDataSource}]]></dataSourceExpression> <datasetParameter name="Country"> <datasetParameterExpression><![CDATA[$F{ACity}]]></datasetParameterExpression> </datasetParameter> </datasetRun> By: Lucian Chirita - lucianc RE: Why my datasetRun not accepting dataSourc 2006-02-09 00:11 What do you mean by not accepting dataSourceParameter? Do you have an error? Regards, Lucian

By: venz98 - venz MySQL 2006-02-07 22:46 Ive just heard about Jasper Reports, i just want to ask if it supports MySQL database. thanks Venz By: Barry Klawans - bklawans RE: MySQL 2006-02-08 08:44 Yes it does. JasperReports works many different data sources, and comes with a JDBC data source that works with MySQL (as well as most other RDBMS). We also have a sample application you can download that monitors multiple MySQL instances and then reports off the usage, table growth, etc. -Barry By: venz98 - venz RE: MySQL 2006-02-08 16:54 Thanks Barry Venz

By: Rajender - rajender_anand Show SubReport on click 2006-02-08 09:48 I have created a Master which has hyperlinks in it. I want that on click of teh hyperlink a value will be passed to the Subreport and it will show the SubReport. Otherwise No subreport should be displeyed. Thanks Rajender

By: Rajender - rajender_anand Show SubReport on click 2006-02-08 09:48 I have created a Master which has hyperlinks in it. I want that on click of teh hyperlink a value will be passed to the Subreport and it will show the SubReport. Otherwise No subreport should be displeyed. Thanks Rajender

By: tommy - tommy2381 how to add custom datatype 2006-02-07 05:39 i need to add a new datataype for variables, fields and textfields and i want to used it for sums. We need to make some sums that cannot be done with doubles(precision is lost); we have a custom framework for decimal numbers. What I have to extend/modify? Thanks. By: Lucian Chirita - lucianc RE: how to add custom datatype 2006-02-08 00:17 You'll have to implement JRIncrementerFactory and for JRVariable.CALCULATION_SUM implement a JRIncrementer (you can take JRDoubleSumIncrementer as an example). Then, for all your sum variables of this type you'll have to set incrementerFactoryClass to the class name of your JRIncrementerFactory implementation. HTH, Lucian By: tommy - tommy2381 RE: how to add custom datatype 2006-02-08 00:28 yes. thise "for all your sum variables of this type" - what type i have to put to those variabiles? Thanks. By: Lucian Chirita - lucianc RE: how to add custom datatype 2006-02-08 00:47 I guess that the type of the sum variables will be your custom datatype - I assume that your framework by adding two values produces a value of the same type. Regards By: tommy - tommy2381 RE: how to add custom datatype 2006-02-08 00:52 When i declare a variabile I have something like this : <variable name="PricingMatrixItemCustomerPrice_customerPriceAfterDiscountInEUR_SUM_General_group" class="java.lang.Double" calculation="Sum" resetType="Group" resetGroup="General_group" <variableExpression>$F{PricingMatrixItemCustomerPrice_customerPriceAfterDiscountInEUR}</variableExpression> </variable> the problem is "class" atribute because jasper does a design verification (dtd validation), and i can choose only from java data type (double, boolean ans so on). so what class i have to put there ? Object ? Thanks. By: Lucian Chirita - lucianc RE: how to add custom datatype 2006-02-08 01:19 Which JR version are you using? I don't think there is a restriction on variable typs. What is the exact error you're getting? By: tommy - tommy2381 RE: how to add custom datatype 2006-02-08 01:26 yes you are right. but i want to used this also for fields , and textfields. so there is this problem. i think. thanks again. By: Lucian Chirita - lucianc RE: how to add custom datatype 2006-02-08 02:09 The restrictions on field types have been removed since 1.0.0. With 0.6.6, you should use Object. With textfields, you could format the value to a String or, if your type extends java.lang.Number, use the text field pattern to format it. HTH By: tommy - tommy2381 RE: how to add custom datatype 2006-02-08 03:50 ok .thanks. this is the answer. By: tommy - tommy2381 RE: how to add custom datatype 2006-02-08 01:28 sorry.. i'm using jasperreports 0.6.6 and this from dtd <!ATTLIST field name NMTOKEN #REQUIRED class (java.lang.Object | java.lang.Boolean | java.lang.Byte | java.util.Date | java.sql.Timestamp | java.sql.Time | java.lang.Double | java.lang.Float | java.lang.Integer | java.io.InputStream | java.lang.Long | java.lang.Short | java.math.BigDecimal | java.lang.String) "java.lang.String" >

By: sreenathv@global.com - sreenathv How to add Arial Narrow to pdf output 2006-02-06 02:44 Hi All, I want to add Arial narrow font to pdf generated by iReports. I am not getting the Arial narrow in the font list box. Even I tried with changing the XML code to Arail narrow but it is giving font could not be loaded. Can any body help? Thanking you

By: Giulio Toffoli - gt78 [ANN] iReport 1.1.0 released! 2006-02-02 17:57 The iReport Team is pleased to announce the new iReport release: 1.1.0. - Full support for JasperReports 1.1.1 - New crosstab wizard - New crosstab editor - New draggable panes - Barcode improvments - Serveral bug fixes and improvements And much more... See details on iReport 1.1.0 What's new? page! (http://ireport.sourceforge.net/index.php?p_module=page&pageid=28) iReport home page: http://ireport.sf.net Download it now: http://sourceforge.net/project/showfiles.php?group_id=64348

By: ramesh - ramesh2410 Need to create worksheet in excel 2006-02-01 01:19 Hi Pals, The data retrieved from the databse need to be shown in different worksheets of excel.if anyone is aware to create worksheet,please provide the solution. Thanks for the effort. By: ramesh - ramesh2410 RE: Need to create worksheet in excel (Urgent 2006-02-01 02:37 Using Jasper Reports i need to create the excels multiple work sheet Thanks for the intrest and effort

By: ramesh - dramesh Hi Teodor pls Look this requirement 2006-01-26 01:25 Hi , here i'm using jasreports+ireports. i have a new reuirement i don't know how to design it pls help on this. My reqirement is like this BAFPT 2005/08 ACTIVE MS SEOW LEY WEE, BLK 948 JURONG #10-679 SINGAPORE 640948 BAFPT 2005/08 ACTIVE MS QUEK HUI YING BLK 611 ANG MO #10-2807 SINGAPORE 560611 BAFPT 2005/08 ACTIVE MS NEO CHENG BEE BLK 841 YISHUN ST #12-260 SINGAPORE 760841 . . . like this i'm getting output from my report but i want 1 2 3 4 5 6 like this here i given numbers insted of addresses. pls let me know how can i write the code thanks in advance ramesh By: jay - jay21 RE: Hi Teodor pls Look this requirement 2006-01-30 18:42 Use the Columns in reports properties to get output in label format. Have not tried, but should work. By: avantrik - avantrik RE: Hi Teodor pls Look this requirement 2006-01-31 02:50 Hi Ramesh, Firstly please download Jasper Source and look at samples, where Teo has worked on all samples. Please check Datasource.jrxml file in sample. I hope it helps.

By: gabe12 - gabe12 JRHtmlExporter OutputStream Issue 2006-01-30 02:06 Hi. I'm using JRHtmlExporter (jasperreports 1.1.1) to generate my reports and write the images to a directory within my webapp. If I stream the HTML to my ServletResponse outputstream. The html code is flushed to the stream but the images are not jet generated so my report is empty after hitting the reload button in my browser the image appears. How about changing the generation order? Move line 424 to 519 in JRHtmlExporter to the top of the method. Another solution is not to flush the buffer after the HTML code is generated. greez gabe

By: ramesh - dramesh Any one pls look on this (urjent) 2006-01-24 02:05 HI ALL, i'M USING JASPERREPORTS+IREPORTS IN STRUTS APPLICATION. AFTER DESIGN MY APPLICATION I'M CALLING THE .jrxml file from my action class at the time of .jrxml compilation i'm getting follwing error. Exception: net.sf.jasperreports.engine.JRException: Error at (71, 18: null only when i'm given the pageHeader Band and cloumnHeader band(contain all static fields ) i'm getting this error. If i given only detail section it is executing fine. any one aware of this pls let me know. thanks in advance, Ram By: sreenathv@global.com - sreenathv RE: Any one pls look on this (urjent) 2006-01-27 00:07 Post Exception with details By: Slobodan Kasterovic - kaster RE: Any one pls look on this (urjent) 2006-01-27 00:55 Maybe compare jrxml file before (still compile) and after (erorr). iReport is a little buggy! Kaster

By: slowfinger - slowfinger sub reports data source isn't seen 2006-01-20 03:50 Hi, I have 2 simple reports which will show it's data in single mode but if I put one of them as an subreport in the other one the subreport will not show it's data. I work with jasper reports 1.1.1 from java and the data come from beans collections. Reports and code are following: 1. master report: <parameter name="dataSource" isForPrompting="false" class="net.sf.jasperreports.engine.data.JRMapCollectionDataSource"/> <field name="autoId" class="java.lang.Integer"/> <field name="name" class="java.lang.String"/> <field name="baujahr" class="java.util.Date"/> <field name="farbe" class="java.lang.String"/> <subreport isUsingCache="true"> <parametersMapExpression><![CDATA[new HashMap($P{REPORT_PARAMETERS_MAP})]]></parametersMapExpression> <subreportParameter name="autoId"> <subreportParameterExpression><![CDATA[$F{autoId}]]></subreportParameterExpression> </subreportParameter> <dataSourceExpression><![CDATA[$P{dataSource}]]></dataSourceExpression> </subreport> 2. sub report <field name="autoId" class="java.lang.Integer"/> <field name="name" class="java.lang.String"/> 3. the java code: JasperReport reportCar = ((JasperReport) JRLoader.loadObject(new File(carReportFile + ".jasper"))); JasperReport reportCarParts = ((JasperReport) JRLoader.loadObject(new File(carReportPartsFile + ".jasper"))); Collection dataCar = new ArrayList(); dataCar.add(new AutoReportBean(new Integer(1), "audi", "red", new Date())); dataCar.add(new AutoReportBean(new Integer(2), "golf", "blue",new Date())); Collection dataCarParts = new ArrayList(); dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Lenkrad")); dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Batterie")); dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Auspuff")); dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Sanikasten")); dataCarParts.add(new AutoTeileReportBean(new Integer(2), "Kurbelwelle")); dataCarParts.add(new AutoTeileReportBean(new Integer(2), "Ganghebel")); Map mapCarTeile = new Hashtable(); mapCarTeile.put("dataSource", new JRMapCollectionDataSource(dataCarParts)); JasperPrint printAuto = JasperFillManager.fillReport(reportCar,mapCarTeile, new JRBeanCollectionDataSource(dataCar)); JasperViewer.viewReport(printAuto); The data of the master report will be shown but not the subreports data. What's wrong here. What I want in the end is to display a one to many relation on the report using the sub report mechanism and this easy trial doesn't work. Any helps ;-) Bye Rico By: jasperkan - jasperkannan RE: sub reports data source isn't seen 2006-01-20 06:58 I have encountered the same problem .these are the solns for this . 1: make both reports as subreports and then add them to a main report . 2: put the subreport into the summary area and then set the option show summary data in a new page . By: Lucian Chirita - lucianc RE: sub reports data source isn't seen 2006-01-20 09:20 Hi First an observation: you don't have an subreportExpression for your subreport. This will obviously cause the subreport not to show. Also you load the subreport in the Java code but you don't use it. Now regarding the report you're trying to produce. Usually in JR when you have a subreport that appears multiple times in the master report, the subreport would have a different data source (I mean the same data source type but instantiated with different parameter values). In your case this means that the usual way to do it is to have separate part lists for each car and when you call the subreport to pass the list for the current car (the list could be a member of the AutoReportBean bean). I'm don't know whether you can fetch the data in this manner, but it's the canonic way to use master-detail subreports. Your dataCarParts data source would have to be used by several subreport instances, based on some key matching logic. This not (yet) supported in JR, see this enhancement request: https://sourceforge.net/tracker/index.php?func=detail&aid=1045435&group_id=36382&atid=416706 HTH, Lucian By: slowfinger - slowfinger RE: sub reports data source isn't seen 2006-01-20 12:45 Hi Lucian, thanks for your answer. A subreportParameterExpression I have it is the 'autoId'. So that all car parts should be listed to each car. Your answer sounds clear but how I can solve that. The demo sample of subreport which shows an example of using the subreport mechanism makes exactly what I want in the first step, but it does that unfortunatly with a database connection. So the question keeps how I can do that procedure with bean collections. Thanks in forward Rico By: Lucian Chirita - lucianc RE: sub reports data source isn't seen 2006-01-24 01:25 Let me first ask you again: do you have a subreportExpression for the subreport? Does the subreport show any data at all? Regarding the autoId parameter, how is it used in the subreport? As I was saying in previous post, the easiest way to construct your master-detail report is, if possible, by changing the way you retrieve the data. Currently you have a dataCarParts collection containing parts for all the cars. You need to have a parts collection per car. If you can't fetch your data in this manner, you can process your consolidated parts collection and break it into per car collections. You can do this easily using a parts collection map indexed by the car id or, if both the dataCar and dataCarParts collections are sorted by id, use a faster merge-like algorithm to break down the parts collection. After you have the parts collection broken down per car, you'll have to use for each car the collection of its parts as a data source for the subreport. Regards Lucian By: slowfinger - slowfinger RE: sub reports data source isn't seen 2006-01-24 05:11 No, I have no subreport expression and the subreport doesn't show the data, only the master report shows it. The autoId parameter is only defined in the report definition I never used it outside. The problem in my understanding is I need some more information over the normal way which use database connection. So I adapt the database sample for subreport. But it doesn't really help. I understand your explanations but what me really help would be a short example how to do that all in the right manner. Thanks Rico By: Lucian Chirita - lucianc RE: sub reports data source isn't seen 2006-01-25 11:30 Ok, you can try this: 1. Break down car parts per car (I'm assuming you're not able to fetch the data like this directly): Map carParts = new HashMap(); for (Iterator it = dataCar.iterator; it.hasNext(); ) { AutoReportBean car = (AutoReportBean) it.next(); carParts.add(car.getAutoId(), new ArrayList()); } for (Iterator it = dataCarParts.iterator; it.hasNext(); ) { AutoTeileReportBean carPart = (AutoTeileReportBean) it.next(); List parts = (List) carParts.get(carPart.getAutoId()); parts.add(carPart); } 2. Send both carParts and reportCarParts to the master report as parameters. 3. Define your subreport like this: <subreport> <reportElement .../> <dataSourceExpression>new JRBeanCollectionDataSource((List) $P{carParts}.get($F{autoId}))</dataSourceExpression> <subreportExpression class="net.sf.jasperreports.engine.JasperReport">$P{reportCarParts}</subreportExpression> </subreport> HTH, Lucian By: slowfinger - slowfinger RE: sub reports data source isn't seen 2006-01-26 08:50 Thanks Lucian, it works great. This is an starting point to more. Bye Rico

By: ramesh - dramesh ERROR! pls Help 2006-01-25 18:26 hi all, when i'm trying to execute my report it is throwing follwing exception. my report have one sub report it will generate the rows dynamically. can any one pls help. Thanks in advance Ramesh Error filling print... net.sf.jasperreports.engine.JRRuntimeException: Subreport overflowed on a band that does not support overflow. at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:1120) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:1216) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:1241) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:250) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:697) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) at java.lang.Thread.run(Unknown Source) Print not filled. Try to use an EmptyDataSource...!

By: ramesh - dramesh Hi I'm getting This Error pls Help 2006-01-24 17:07 Hi All, when I'm trying to compile my jrxml i'm getting follwing error , here i'm sending my .jrxml file also if any one know pls let me know Thanks in advance, Ramesh d ERROR--->Exception: net.sf.jasperreports.engine.JRException: Error at (67, 18: null <?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="MyReport" 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="2" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <parameter name="Inner" isForPrompting="false" class="java.lang.String"/> <queryString><![CDATA[select party_id,edu_inst_id from sms_student_program where edu_inst_id=$P!{Inner}]]></queryString> <field name="PARTY_ID" class="java.lang.String"/> <field name="EDU_INST_ID" class="java.lang.String"/> <variable name="date" class="java.util.Date" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA[new Date()]]></variableExpression> <initialValueExpression><![CDATA[new Date()]]></initialValueExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="50" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="50" isSplitAllowed="true" > <staticText> <reportElement mode="Transparent" x="162" y="13" width="167" height="25" forecolor="#000000" backcolor="#FFFFFF" key="staticText-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="18" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[student Information]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="410" y="14" width="100" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <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.util.Date"><![CDATA[$V{date}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="30" isSplitAllowed="true" > <staticText> <reportElement mode="Transparent" x="153" y="7" width="38" height="18" forecolor="#000000" backcolor="#FFFFFF" key="staticText-2" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <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> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="270" y="8" width="51" height="18" forecolor="#000000" backcolor="#FFFFFF" key="staticText-3" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <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> <text><![CDATA[institution]]></text> </staticText> </band> </columnHeader> <detail> <band height="100" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="255" y="21" width="100" height="18" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <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[$F{EDU_INST_ID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="128" y="23" width="100" height="18" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <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[$F{PARTY_ID}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="67" y="27" width="32" height="18" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <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.Integer"><![CDATA[$V{COLUMN_COUNT}]]></textFieldExpression> </textField> </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> By: nsorochan - nsorochan RE: Hi I'm getting This Error pls Help 2006-01-24 17:43 I had no problem compiling it. I use the jdt compiler System.setProperty("jasper.reports.compiler.class", "net.sf.jasperreports.engine.design.JRJdtCompiler") then I just compile it JasperCompileManager.compileReportToFile([jrxml file], [jasper file]); hope this helps

By: Marco - mbon Elements list in a column? 2006-01-24 15:01 Hi, I need something like this in a multicolumn report: Element Name ------------- weight prize part: part1, part2, part3, ..., partN Whats the best structor for build the "part list"? I really need a sub report? Tanks - mabo

By: Alexandre Gomes - alegomes 0.6.4 vs 1.1.1 2006-01-24 09:08 Why JasperReports 0.6.4 takes about 120 seconds to generate a report while 1.1.1 version takes 3547 (29 times slower) seconds to generate the same one?! regards

By: Alexandre Gomes - alegomes Best Practices 2006-01-24 09:04 Is there some kind of pattern for JasperReports usage? Maybe some tricks ou designs for better performance..... For example, is the JasperPrint.fillReport(String, Map, Connection) worst than JasperPrint.fillReport(String, Map, JRDataSource) ? What´s the fastest solution? thanks Alê!

By: tvan66 - tvan66 Problem of parameter of multi values 2006-01-23 05:30 Hi, I have a problem when my application passes a parameter of multi values from a web component such as Listbox to the SQL inside the xxx.jrxml file. For example, I have 1,2 values of parameter journalistId. I pass journalistId to SELECT * FROM... WHERE TABARTICLESJOURNALISTS.ID_JOURNALIST IN($P{journalistId}), Jasper launch the exception that this is not a valide number. But I tried to test with the direct values in the SQL: ...TABARTICLESJOURNALISTS.ID_JOURNALIST IN(1, 2) that works, even with ...TABARTICLESJOURNALISTS.ID_JOURNALIST IN('1', '2') that works too.So I think that Jasper does not parse correctly the parameters of multi values to the SQL. Thank you in advance for your help. Tvan By: Teodor Danciu - teodord RE: Problem of parameter of multi values 2006-01-23 06:04 Hi, Those are not query parameters that you could be used with a PreparedStatement in JDBC, where we put a ? for each parameter. Using the IN function in SQL is like modifying the query. Is like executing a different query each time, if the list of values changes. So you need the $P!{} syntax to include that part of the query. Check the /demo/samples/query sample provided with the project. I hope this helps. Teodor By: tvan66 - tvan66 RE: Problem of parameter of multi values 2006-01-23 08:47 Hi Teodor, Thank you for the answer. You are absolutelly right. I have just changed $P to $P! and that works. The $P! means "to dynamically modify portions of the SQL query". Thank you again. Best wishes Tvan