psentosa

Hi Shaded.. what I did is exactly what Lucian has recommended: using crosstabs, and define your dynamic columns as column groups.. further I set the rest of the columns which are static (i.e only 1 column) as measures... try to play with the crosstabs a bit and you'll get what I mean Cheers

Hi all, How can I manage not to see the option "Position Type"?? :) So, I just need to set the position type of all elements below the tables to "Float" so that they'll be pushed down as soon as the tables are bigger than the place holder Regards

Hi Lucian, thanks for your hints. I managed to create the table I want. Just a further question, that you could answer if you have some spare time :) : Actually there are some more columns beside delivery and price, two of which are related with the price: unit price total price unit price is a fix value, while total price is based on the sum of the number or ordered shoes, so it would look like: Amount Unit Price Total price 33 35 37 39 2 2 2 2 8 15 120 I still manage to get the amount value right (by using calculation type "Sum" on the number measure, but is there any possibilty to automaticall calculate the total price? Thanks and have a nice weekend! Regards

Hi, thanks again for your prompot reply! I attached my main and one of subreport below. As you can see, the width of the first subreport element, the main report, and the subreport itself are all the same. Still, if I have much more records than the height of the subreport element allows, it didn't push down all other texts. Maybe you can take a look at the templates? Thanks Regards

Hi, thanks for your reply and sorry for my late one! Do mind explaining further what do you mean by spanning the width of the main report (how?) Thanks a lot Regards

Hi all, I'd like to make a report, which has several tables in the title area. But all the tables could have any number of records, so that every other texts in the title area below the table should be automatically pushed down further. Is this possible? Thanks for any explanations Regards Post Edited by psentosa at 05/06/2010 15:32

Hi Lucian, again, thanks a lot for your reply. One last question, actually the records are a little bit more: Model A Shop name Order Delivery Price Shop1 33 35 37 38 10.11.2012 100 2 2 5 9 Shop2 31 32 38 42 44 12.10.2012 200 1 2 3 5 6 So, as you can see, actually there are some more columns; using "your model", is it ok to have the records like this: Shop1, 33, 2, 10.11.2012, 100 Shop1, 35, 2, 10.11.2012, 100 Shop1, 37, 5, 10.11.2012, 100 Shop2, 31, 1, 12.10.2012, 200 Shop2, 32, 2, 12.10.2010, 200 And as there are some columns now, how to decide which 2 are the column groups and how to determine the row group? Many many thanks! Regards

Hi Lucian, thanks for your reply. Do you mind giving some more hints on this? Thanks in advance

Hi all, I'd like to print a report (Shoe order for a certain model) which have the following form: Model A Shop name Order Shop1 33 35 37 38 2 2 5 9 Shop2 31 32 38 42 44 1 2 3 5 6 As you can, each records contains following information: 1. The name of the shop that give the orders 2. Amount of the shoes pair for each ordered size There are so many different sizes, and any shop should order shoes in certain sizes that they currently need; so the number of the columns for the table in the "Order"-Column should be dynamic. Any advices on how to create the table? FYI, I use java data source for the report, so in this case I will have a data model such as: public class OrderDataEntry { String shopName; /** the key of the map is the size, and the value is the amount* Map<Integer, Integer> shoeOrders; } Thanks in advance Post Edited by psentosa at 04/29/2010 14:45

Hi Teodor, can't find 3.7.2 on your public Maven repo...any possibiliy to upload this?

Hi all, I have a report which has a single subreport-element in detail-band (all other bands are set to 0). The height of the subreport-element is exactly the same as the detail band, which is the height of the page (landscape, A4) minus the top and bottom margin. In my case, the subreport will be only filled once (as there is only one subreport), but it contains quite a lot of records so that they don't fit in one page. But when the report is created, the first page is an empty page, and the report starts at the 2nd page (and several records are on the 3rd page). If I tried with another subreport which contains less records (which would fit in only one page), it started directly on the first page. Anyone could give any hints on possible cause of this? Thanks in advance

Apparently I made a mistake by having the printOrder set to "Horizontal", that's why the records are printed through the different columns. But still I have another problem: By activating the isStartOnANewColumn, the first three groups are printed in the different columns. But the next groups will be then printed on the next pages. How can I make that the spaces in first page are filled in before moving to next page? i.e the 4th group will be under the 1st the 5th under the 2nd the 6th under the 3rd and so on... Having pagination ignored make the groups are all printed in the first page, but also everything in the first column although startOnNewColumn is still active. Any hints on this?Thanks in advance

Hi all, I'd like to do some grouping in my report. The page is divided in 3 columns. Each group has several entries and each new group should be placed in the next column, so it should look like this: GroupName1 GroupName2 GroupName3 Entry11 Entry21 Entry31 Entry12 Entry22 Entry32 Entry13 Entry23 Entry33 But somehow I got the following form: GroupName1 Entry11 Entry12 Entry13 GroupName2 Entry21 Entry22 Entry23 GroupName3 Entry31 Entry32 Entry33 The question is, why are the entries spreaded into the different columns? I activate isStartANewColumn with the hope that each group will be placed in the next column, but then only the entries are placed in the different columns I attached my jrxml file, please have a look, and would be very thankful for any hints Regards Post Edited by psentosa at 04/13/2010 14:43 Post Edited by psentosa at 04/14/2010 07:47 Post Edited by psentosa at 04/14/2010 11:48

Hi all, I made a report using fontName="SansSerif" and having a jar extension for fonts on the classpath. Inside the fonts.xml, I define the following: <bean id="sansSerifFamily" class="net.sf.jasperreports.engine.fonts.SimpleFontFamily"> <property name="name" value="SansSerif"/> <property name="normal" value="net/sf/jasperreports/fonts/helvetica/Helvetica.ttf"/> <property name="bold" value="net/sf/jasperreports/fonts/helvetica/HelveticaBold.ttf"/> <property name="italic" value="net/sf/jasperreports/fonts/helvetica/HelveticaItalic.ttf"/> <property name="boldItalic" value="net/sf/jasperreports/fonts/helvetica/HelveticaBoldOblique.ttf"/> <property name="pdfEncoding" value="Identity-H"/> <property name="pdfEmbedded" value="true"/> <property name="exportFonts"> <map> <entry key="net.sf.jasperreports.html"> <value>'DejaVu Sans', Arial, Helvetica, sans-serif</value> </entry> <entry key="net.sf.jasperreports.xhtml"> <value>'DejaVu Sans', Arial, Helvetica, sans-serif</value> </entry> </map> </property> </bean> Having the font extension, the generated report is identical on different machines (Windows, Linux). But then I have another problem: Although there are still spaces, some texts are not printed/shown completely. Attached is a screenshot of the report. You can see the text "Saved, Nach I" which is supposed to be "Saved, Nach IFF". does this have something to do with missing fonts? Maybe the placeholder for the text is calculated using another font and helvetica just doesn't fit into it? How can I solve this problem? Thanks a lot for any hints regards Update: I attached another screenshot: it shows that for the fields, there is somehow an invisible limit for the font width, and the max. number of letters is set to 11 letters, but the text of parameter ("aus anderer VKST") is printed completely, and they have exactly the same attributes. Anyone can explain? Post Edited by psentosa at 03/03/2010 07:46 Post Edited by psentosa at 03/03/2010 07:47 Post Edited by psentosa at 03/03/2010 08:39

Hi all, I try to include jasperfonts 3.7.1.jar in my application to avoid extra line for PDF created on linux system. In jrxml I use the fontName DejaVuSans, and tick the pdfEmbedded option But then I got the following exception: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dejaVuSansFamily' defined in URL [jar:file:/opt/jboss-versionen/jboss-4.2.3.GA/server/default/tmp/deploy/tmp60304myapp.ear-contents/myapp-exp.war/WEB-INF/lib/jasperreports-fonts-3.7.1.jar!/net/sf/jasperreports/fonts/fonts.xml]: Initialization of bean failed; nested exception is java.lang.NoClassDefFoundError: org/springframework/beans/propertyeditors/CustomNumberEditor org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:480) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) java.security.AccessController.doPrivileged(Native Method) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221) org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:168) net.sf.jasperreports.extensions.SpringExtensionsRegistry.getExtensions(SpringExtensionsRegistry.java:77) net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:103) net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:76) net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:174) net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:74) net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:56) net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:143) net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:79) net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624) ....................... root cause java.lang.NoClassDefFoundError: org/springframework/beans/propertyeditors/CustomNumberEditor org.springframework.beans.PropertyEditorRegistrySupport.doRegisterDefaultEditors(PropertyEditorRegistrySupport.java:193) org.springframework.beans.PropertyEditorRegistrySupport.getDefaultEditor(PropertyEditorRegistrySupport.java:128) org.springframework.beans.TypeConverterDelegate.findDefaultEditor(TypeConverterDelegate.java:251) org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:171) org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:138) org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:386) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.convertForProperty(AbstractAutowireCapableBeanFactory.java:1288) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1249) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) java.security.AccessController.doPrivileged(Native Method) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221) org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:168) net.sf.jasperreports.extensions.SpringExtensionsRegistry.getExtensions(SpringExtensionsRegistry.java:77) net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:103) net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:76) net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:174) net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:74) net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:56) net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:143) net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:79) net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624) 2nd question: It is possible to use the SansSerif-Font if I use the extension jasperfonts3.7.1.jar? Would be very thankful for any hints Regards Post Edited by psentosa at 03/02/2010 10:08 Post Edited by psentosa at 03/02/2010 10:09