sanbez

I don't know why blank line here :( In this cases I'm moving all fields into frames in every section and "to paint" frames borders into the various colors. After that i see in what band appear empty string. With best regards Post Edited by sanbez at 11/10/2011 05:32

You may add detail band in context Detail1 band (see picture) choosing "Add another detail band" Post Edited by sanbez at 11/08/2011 13:20

Are you implements <b>JRDataSource</b> interface in DataSource java-class for subreport? I make some reports with inners ArrayList<Object> and its work fine (from JR version 3.7.6 to 4.1.2)

May be new java.net.URL($F{thumbnail_url}) ?

Maybe u solve your problem by setting parameter "When No Data"? In iReport properties on master (and maybe in subreport). Set "When No Data"="No Pages" or "All Sections, No Detail". One of this choices (in various specific variants) must to help you

1. Try use checkbox "remove line when blank" on field of master report and subreport or 2. Move field of master report and subreport into frame, and use this checkbox for the frame

Try adding "manually" two days in milliseconds. For example: new SimpleDateFormat( "dd.MM.yyyy" ).format(new Date().getTime()+86400000*2) But IMHO is not good solution. But it must work. Post Edited by sanbez at 10/13/2011 17:00

1. Not "=="! Use $V{NOT_PROCESSED}.equals(new java.lang.Integer(0)) ? new java.math.BigDecimal(0) : new java.math.BigDecimal(1) If "==" this expression always false. 2. May be this expression is never computing? Try to clear initialValueExpression. Are you get not null $V{NOT_PROCESSED} value in this case?

It is strange behavour. But probably I was too short in the explanations. I writing in iReport by using java-collections. In this case i do next steps: 1. Define java-class for the storage of result my calculations. For example: class FirstColumnInfo private String FirstColumnValue; private List<FirstColumnChildren> ... class FirstColumnChildren private String SecondColumn; private String ThirdColumn; and so on 2. Writing java-code for search data. In this code i fill my structure: Collections<FirstColumnInfo> resultComputing = findCollection(); 3. Creating DataSource and filling JasperReport: JRBeanCollectionDataSource dataSource = new JRBeanCollectionDataSource(resultComputing); 4. Filling Report: JasperFillManager.fillReport("report.jasper", reportParametrs, dataSource) ... and so on (some actions for subreport) If you are use SQL-query as data source for report, i think that you must to do two query (1. for main report and 2. for subreport): 1. select distinct(first column) from (yuor query) 2. For subreport you must define parameter: firstColumn and query for subreport (select * from (your query) where first_column=Parameter) It is very bad by productivity, but i think you may find optimal queries for both reports (main and subreport). Good luck

Sorry, i am forget that in the case of using subreport you may solve your problem by setting "Stretch type" for first field with "Relative to Band Height".

I make subreport with all fields (excluding first field). First field and subreport placed into frame with displayed borders. First field haven't borders. In result of execution report, first field displayed with borders of the frame (borders not in every row for first field). Sorry for bad english

There is no way of the decision of this problem :( Try uncheck option "Print repeated values" on first field, but this field will be displayed only on the first row (not in middle)

Hi! Method "add" is the method of java.util.Calendar, but not java.util.Date You need: 1. Write java-class to work with dates (or find in internet, it's named approximately "DateUtils"). Example method of whis class: public static Date addField(Date date, int field, int count) { Calendar calendar = Calendar.getInstance(); calendar.setTime(date); calendar.add(field, count); return calendar.getTime(); } 2. Define classPath in iReport(Tools/Options/Classpath) with path to DateUtils.class 3. in iReport define Initial Value Expression for Variable: ru.rtec.sgsr.util.report.DateUtils.addField($F{mydatefield}, Calendar.MONTH, 2) With best regards

Is it solving of your problem? http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=89230

Hi 1. Set "Stretch With Overflow" for both fields 2. Add another Detail band 3. Move second field in new Detail band Post Edited by sanbez at 07/07/2011 07:46

It's very strange error. Are you sure that this error occurs at report performance? By a subreport calling (*.jasper) compilation don't must to do. In this case calling method loadObject(). The stack error in this case looks approximately so: Caused by: net.sf.jasperreports.engine.JRException: Could not load object from location: ... main\Project\Reports\reports\r1140_points.jasper (it's my stack trace) It's error is not error of compilation! I don't see the full stack trace of yours error, therefore it's very hard to give correct advice. But I have one assumption: I Has received the similar stack trace on COMPILATION of my main report (jasper v 4.02): Unable to locate the subreport with expression: "$P{SUBREPORT_DIR}.concat($F{time})". java.lang.Exception at com.jaspersoft.ireport.designer.utils.Misc.locateFileFromExpression(Misc.java:1396) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.compileSubreports(IReportCompiler.java:1418) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:509) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) This error has occurred by the compilation of my main report from iReport Designer. In my iReport at "Tools/Options/Compilation and execution" tabs chekbox "Compile subreports (if can be found)" sets on. Uncheck this. Sorry for bad english

no a direct way to do this (imho) for more information see not full solving of analogic problems: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=88855

Hi. If you are haven't problems with displaing this maps ( for example toString(key_of_Map) ), then you may to use the next advice. Display list by using subreport. For subreport you must write java-class implementing JRDataSource interface (methods next() and getFieldValue() ) and initialization data (the same List<String>) for this methods Sorry fo bad english

For removing images you must set FALSE to exporter parameters IS_USING_IMAGES_TO_ALIGN cut the code: --- start cut JRExporter exporter = null; ... if (reportFormat.equals(ReportFormat.HTML)) { exporter = new JRHtmlExporter(); ... exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, false); } ... exporter.exportReport(); -- end cut Sorry for bad english :)