titan115

Hi,everyone, I have a new default jrxml created by iReport,and i modified the properties like bellow, Report: Print order Horizontal Columns 5 Column Width 111 Detail band Print When Expression Boolean.valueOf($F{id}.intValue() % 2 == 0) I enter 10 values(100~109),I get the report like bellow: 100 102 104 106 108 but the report as i expect should like bellow: 100 102 104 106 108 What's wrong? Thanks titan115 Post Edited by titan115 at 04/27/2010 07:57

lucianc Wrote: You can also use a crosstab for this. Regards, Lucian Can you show me how to use crosstab to solve this problem?I quite new to jasperreport. regards titan115

/uploads/projects/jasperreports/image/recordlost1.bmp Post Edited by titan115 at 09/07/2009 16:12

pawel_r Wrote: I am quite new to jaspereports but the only way I know is subreporting (making 3 different subreports) Thank you. But i think this not a graceful solution.I have to add many subreports if i add some new items to display.

/uploads/projects/jasperreports/image/horizontal%20filling.bmp Post Edited by titan115 at 09/07/2009 04:04

Hi, I'll study crosstabs first to see if that's a solution for my project. Enhance the list component to fill horizontally definitely is also a good solution,it will be useful in medical industry.Because in this industry,there are many charts and data show details in horizontal style. Thank you titan115 Post Edited by titan115 at 08/21/2009 13:53

Hi, The number of field values is dynamic，not static. My datasource where come from a XML datasource,not from database directly. Post Edited by titan115 at 08/21/2009 13:37

Hi,everyone, In my project,I won't to show data as horizontal style at detail. Just like this: FieldName1 Field1Value1 Field1Value2 Field1Value3 Field1Value4 FieldName2 Field2Value1 Field2Value2 Field2Value3 Field2Value4 FieldName3 Field3Value1 Field3Value2 Field3Value3 Field3Value4 ................................. How can i implement this? Thanks!

jambalaya Wrote: Hi. I do it like this: I'm using JPA with Oracle, and the entity that has images has a java.awt.Image member, which is populated when the entity instance is loaded from the db. The property name is, say, "image". The template has a field for this property, named "image" (JPA data source expects the field names to correspond to entity property names), and an image element in the detail section. The expression class is set to java.awt.Image and the expression is simply "$F{image}". And this is all you have to do. You can of course set scaling and positioning, but this is specific to your app. If you store the images in a BLOB and execute a JDBC query, you can feed the result set to jasper or have the query incorporated into the template, and Jasper will use a javax.jdbc.Connection that you need to supply. The rest is pretty similar - the field has the same name as the column / alias you use in the query, the type is java.awt.Image, and the imge has the same properties set. Jasper automatically tries to transform BLOBs into images. Hope this helps. This is very useful for me.Thank you.But my app has a small difference to this you said.I use JRXMLDataSource,because the record in database cann't be used directly,I have to convert my database record to my report record.So there is problem how I pass my images to template?Maybe uses customized JRDataSource is a resolution. Post Edited by titan115 at 07/24/2009 01:52

Hi,everyone, I use jasperreport 3.5.1 in my project. I meet a problem like this,I store my images in database,i want to display this images in detail,but images amount isn't fixed.How can I create my report template file,and assign images to the report? Best regards. Mxking